MS Access MCQ Questions and solutions with explanations

Section 1 Section 2 Section 3 Section 4 Section 5 Section 6

11.
To create queries in Access

A. You can drag and drop fields on query builders

B. you can type the SQL command in SQL view

C. You can use query wizard or design view

D. All of above

Answer & Solution Discuss in Board Save for Later

12.
In Access, to Exit Office Access 2007Access

A. CTRL+N

B. CTRL+O

C. ALT+F4

D. None of these

Answer & Solution Discuss in Board Save for Later

13.
In Access press CTRL+N to

A. Open a new database

B. Open an existing database

C. Exit Office Access 2007

D. None of these

Answer & Solution Discuss in Board Save for Later

14.
Cascade update option

A. means do not change the value in the primary key field if that record has related records in another table

B. means change all the related records in child tables if the record in parent table is changed

C. Both of above

D. None of above

Answer & Solution Discuss in Board Save for Later

15.
What determines a table's sort order?

A. AutoNumber field

B. Index field

C. Field order

D. Primary key

Answer & Solution Discuss in Board Save for Later

16.
In Access press . . . . . . . . to Paste the contents of the Clipboard in the upper- left corner of the selected section

A. CTRL+C

B. CTRL+X

C. CTRL+V

D. None of these

Answer & Solution Discuss in Board Save for Later

17.
In Access press LEFT ARROW or CTRL+LEFT ARROW

A. Move the selected control to the right (except controls that are part of a layout)

B. Move the selected control to the left (except controls that are part of a layout)

C. Move the selected control up

D. None of these

Answer & Solution Discuss in Board Save for Later

18.
What is a form in MS Access

A. It is a printed page where users will write their data to fill it up

B. It is an input screen designed to make the viewing and entering data easier

C. This is an important part of database used by analysts to draw conclusions

D. All of above

Answer & Solution Discuss in Board Save for Later

19.
In Access press . . . . . . . . to Move the selected control to the right (except controls that are part of a layout)

A. CTRL+C

B. CTRL+X

C. CTRL+V

D. None of these

Answer & Solution Discuss in Board Save for Later

20.
You can display a database object in design view by

A. Opening the database object and clicking the view button on the toolbar

B. Selecting the database object and clicking the design button on the database window

C. Selecting the database object and press Ctrl + V

D. Opening the database object and selecting Tools>Design view

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

MS Access MCQ Questions and solutions with explanations | MS Office

11. To create queries in Access

Answer & Solution

12. In Access, to Exit Office Access 2007Access

Answer & Solution

13. In Access press CTRL+N to

Answer & Solution

14. Cascade update option

Answer & Solution

15. What determines a table's sort order?

Answer & Solution

16. In Access press . . . . . . . . to Paste the contents of the Clipboard in the upper- left corner of the selected section

Answer & Solution

17. In Access press LEFT ARROW or CTRL+LEFT ARROW

Answer & Solution

18. What is a form in MS Access

Answer & Solution

19. In Access press . . . . . . . . to Move the selected control to the right (except controls that are part of a layout)

Answer & Solution

20. You can display a database object in design view by

Answer & Solution

Read More Section(MS Access)

11.
To create queries in Access

12.
In Access, to Exit Office Access 2007Access

13.
In Access press CTRL+N to

14.
Cascade update option

15.
What determines a table's sort order?

16.
In Access press . . . . . . . . to Paste the contents of the Clipboard in the upper- left corner of the selected section

17.
In Access press LEFT ARROW or CTRL+LEFT ARROW

18.
What is a form in MS Access

19.
In Access press . . . . . . . . to Move the selected control to the right (except controls that are part of a layout)

20.
You can display a database object in design view by