The Microsoft Access test has answers

  1. Question 1. In a query (Query) containing at least several parameters:
    1. 0
    2. first
    3. 2
    4. More
  2. Question 2. The database model used in MS Access is:
    1. Tables, Queries, Forms .
    2. .MDB database model
    3. Linked data model
    4. All is wrong
  3. Question 3. When designing a table creation query, if we enter a new table name that matches the table name already in the database, after the execution of the query, we will have:
    1. New data will be added to the existing table (the table already exists before)
    2. New data will replace the data already in the existing table
    3. Cannot execute this query
    4. All is wrong
  4. Question 4. In the objects of MS Access database, which object should be created first?
    1. Table
    2. Query
    3. Form
    4. Report
  5. Question 5. When designing a table, the number of foreign keys that may be in that table are:
    1. 0
    2. first
    3. 2
    4. Depending on each table
  6. When designing a Report, if we want a control to appear only once when viewing the report in Print Preview mode, in the design window, we will place that control in the :
    1. Page Header
    2. Group Header
    3. Report Header
    4. Detail
  7. Question 7. When designing a subform for a main form (mainform), if you do not want the formulas placed in the Form Footer section of the subform to display when viewing the main form in FormView mode, then we will do:
    1. Switch the subform to the default display mode, Columnar
    2. Switch the subform to the default mode of Datasheet
    3. Switch the subform to the default display mode of Tabular
    4. All of the above statements are true
  8. Question 8. The function of the primary key in a table is:
    1. Uniquely identify a record when knowing the value of the primary key corresponding to that message
    2. Use to create external links with other tables
    3. Use to create links with multiple tables
    4. All right
  9. Question 9. From the make table query window, we want to convert that query to the select query, then we do:
    1. Select Query / MakeQuery
    2. Select View / Make Query
    3. Select Query / SelectQuery
    4. Select View / SelectQuery
  10. Question 10. When a Table is opened, Record order will prioritize according to:
    1. Do not arrange in any order
    2. Field is selected as Table key
    3. Field is selected in the Table Filter property
    4. Field is selected in the Order by Table property
4 ★ | 2 Vote

May be interested

  • IQ puzzle or answer P7IQ puzzle or answer P7
    iq test has answers to help readers discover their own intelligent index. let's do the iq test below to test any iq.
  • TOP best Microsoft Access replacement software for databasesTOP best Microsoft Access replacement software for databases
    microsoft access is a database engine, popularized through the inclusion of most microsoft office packages since 1992. like many database programs, microsoft access is quite complex and takes a long time to build. research.
  • How to quickly eliminate wrong answers in the National High School English test 2017How to quickly eliminate wrong answers in the National High School English test 2017
    in order to help contestants quickly think and choose the best option, the following article will guide you to a few methods to quickly eliminate incorrect answers in english test so you don't have to leave any sentence in the exam.
  • Microsoft Excel P8 testMicrosoft Excel P8 test
    multiple choice questions around the topic of excel, invite readers to test their knowledge with the network administrator. the question set consists of 10 sentences, 4 answers each, find the most accurate answer.
  • Useful Access shortcut keyUseful Access shortcut key
    microsoft access is part of the microsoft office toolkit and comes with all microsoft office versions. the following article is a summary of the most popular and useful shortcuts in microsoft access.
  • Testing computer science knowledge, doing little for fun (part 2)Testing computer science knowledge, doing little for fun (part 2)
    the series of computer science quiz questions covers many areas with a set of 4 answers and answers at the bottom of the page. after part 1, network administrator continues to introduce part 2.
  • CSS test with answer P4CSS test with answer P4
    set of multiple choice questions about css programming language, invite readers to test their knowledge on this topic. with 10 questions including 4 answers, please choose the best answer.
  • Microsoft Excel Test P9Microsoft Excel Test P9
    the following network administrator will send you to read multiple choice questions about excel, invite you to test your knowledge. the set of questions consists of 10 sentences, 4 answers each to choose from.
  • What is Microsoft Access? Instructions on how to use Microsoft AccessWhat is Microsoft Access? Instructions on how to use Microsoft Access
    microsoft access is a relational database management system that enables users to store and manage information.
  • Steps to export Microsoft Access data to Word documentsSteps to export Microsoft Access data to Word documents
    access provides most of the features you would expect from a relational database management system. you can create tables, forms, queries, relationships, reports, macros, modules, etc. but sometimes, you may want to export data from microsoft access to word.