The Microsoft Access Test Has Answers

This article presents Microsoft Access Test Has Answers in a clear, structured format. It helps readers review key concepts, test their understanding, and learn from the material.

Understanding Microsoft Access Test Has Answers

• Question 1. In a query (Query) containing at least several parameters:
  • 0
  • first
  • 2
  • More
• Question 2. The database model used in MS Access is:
  • Tables, Queries, Forms.
  • . MDB database model
  • Linked data model
  • All is wrong
• 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:
  • New data will be added to the existing table (the table already exists before)
  • New data will replace the data already in the existing table.
  • Cannot execute this query
  • All is wrong
• Question 4. In the objects of MS Access database, which object should be created first?
  • Table
  • Query
  • Form
  • Report
• Question 5. When designing a table, the number of foreign keys that may be in that table are:
  • 0
  • first
  • 2
  • Depending on each table
• 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:
  • Page Header
  • Group Header
  • Report Header
  • Detail
• 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:
  • Switch the subform to the default display mode, Columnar.
  • Switch the subform to the default mode of Datasheet.
  • Switch the subform to the default display mode of Tabular.
  • All of the above statements are true
• Question 8. The function of the primary key in a table is:
  • Uniquely identify a record when knowing the value of the primary key corresponding to that message.
  • Use to create external links with other tables.
  • Use to create links with multiple tables
  • All right
• Question 9. From the make table query window, we want to convert that query to the select query, then we do:
  • Select Query/MakeQuery
  • Select View/Make Query
  • Select Query/SelectQuery
  • Select View/SelectQuery
• Question 10. When a Table is opened, Record order will prioritize according to:
  • Do not arrange in any order
  • Field is selected as Table key
  • Field is selected in the Table Filter property.
  • Field is selected in the Order by Table property.