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.

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

  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. Question 10. When creating a query, we can sort data by how many fields:
    1. first
    2. 2
    3. 3
    4. Optional
  11. 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
  12. Question 12. In a query, can you group the maximum data according to how many fields?
    1. 3
    2. 4
    3. ten
    4. Optional
Update 24 May 2019
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile