TipsMake

The Microsoft Access test has the answer P6

If you are a beginner using access software, then the quiz below will give you lots of useful information for the process.

★ Microsoft Access has a P2 answer
★ The Microsoft Access test has the answer P4
  • 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

Discover more

quizzes Microsoft Access computer literacy tests access 2010 access usage databases
Lesley Montoya

Share by

Lesley Montoya
Update 24 May 2019

You should read it