-
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
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:
-
Question 2. Which of the following objects is used to store data
-
Form
-
Query
-
- 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
-