The Microsoft Access Test Has the Answer P6

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

Understanding Microsoft Access Test Has the Answer P6

• Question 1. How many components does Access 2003 database have:
  • There are 7 components: Table, Query, Form, Page, Module, Report, Macro.
  • There are 5 components: Table, Query, Form, Module, Report.
  • Only the Table component
  • There are 6 components: Table, Query, Form, Module, Report, Macro.
• Question 2. Which of the following objects is used to store data.
  • Form
  • Query
  • 1. Table

  • Report

• Question 3. To create the Command Button with the Wizard to add new records, we choose the type - which of the following actions:
  • Record Operation, Add new record
  • Record Navigation, Add new record
  • Record Operation, New record
  • Go to record, new
• Question 4. The Query tool is used to:
  • Extract and calculate data according to given conditions from Tables or Query.
  • Delete the records in the Table
  • Update data in Table
  • All three sentences (a), (b), (c) are correct.
• Question 5. A Macro associated with the object:
  • It is only possible with the object it is attached to.
  • It can be done independently when it is activated.
  • Not possible
  • Optional
• Question 6. Want to append data from Table or Query to another table we use:
  • Append Query
  • Update Query
  • Select Query
  • Make Table Query
• Question 7. In a form, a Textbox associated with an expression, that expression can contain:
  • Math operations
  • School names
  • Functions
  • All three sentences (a), (b), (c) are correct.
• Question 8. When an Update Query is open in Datasheet View mode:
  • Cannot add any items to the results table.
  • Cannot edit the value of the records in the results table.
  • You can add or edit records in the results table.
  • Cannot add or edit records in the results table.
• Question 9. In the "NhanVien" Form, to create an input Textbox for the PHAI field, which attribute must be set:
  • Control Source = PHAI
  • Set Name = PHAI and Control Source = PHAI.
  • Optional
  • All is wrong
• Question 10. When creating a query, we can sort data by how many fields:
  • first
  • 2
  • 3
  • Optional
• Question 11. Select the best statement in the statements below: When creating a query, if there are two or more tables with the same field name:
  • We cannot show all those fields
  • We have to change names for those schools.
  • Query cannot be performed
  • Still creating the query as usual
• Question 12. In a query, can you group the maximum data according to how many fields?
  • 3
  • 4
  • ten
  • Optional