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.

Question 1. How many components does Access 2003 database have:
1. There are 7 components: Table, Query, Form, Page, Module, Report, Macro
2. There are 5 components: Table, Query, Form, Module, Report
3. Only the Table component
4. There are 6 components: Table, Query, Form, Module, Report, Macro
Question 2. Which of the following objects is used to store data
1. Form
2. Query
3. Table
4. Report
Question 3. To create the Command Button with the Wizard to add new records, we choose the type - which of the following actions:
1. Record Operation, Add new record
2. Record Navigation, Add new record
3. Record Operation, New record
4. Go to record, new
Question 4. The Query tool is used to:
1. Extract and calculate data according to given conditions from Tables or Query
2. Delete the records in the Table
3. Update data in Table
4. All three sentences (a), (b), (c) are correct
Question 5. A Macro associated with the object:
1. It is only possible with the object it is attached to
2. It can be done independently when it is activated
3. Not possible
4. Optional
Question 6. Want to append data from Table or Query to another table we use:
1. Append Query
2. Update Query
3. Select Query
4. Make Table Query
Question 7. In a form, a Textbox associated with an expression, that expression can contain:
1. Math operations
2. School names
3. Functions
4. All three sentences (a), (b), (c) are correct
Question 8. When an Update Query is open in Datasheet View mode:
1. Cannot add any items to the results table
2. Cannot edit the value of the records in the results table
3. You can add or edit records in the results table
4. 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:
1. Control Source = PHAI
2. Set Name = PHAI and Control Source = PHAI
3. Optional
4. All is wrong
Question 10. When creating a query, we can sort data by how many fields:
1. first
2. 2
3. 3
4. 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:
1. We cannot show all those fields
2. We have to change names for those schools
3. Query cannot be performed
4. Still creating the query as usual
Question 12. In a query, can you group the maximum data according to how many fields?
1. 3
2. 4
3. ten
4. Optional