MS Access MCQs

Question 1

In Access to open an existing database press

Accepted Answer

CTRL+O

Answer

CTRL+N

Answer

ALT+F4

Answer

None of these

Question 2

To create queries in Access

Accepted Answer

All of above

Answer

You can drag and drop fields on query builders

Answer

you can type the SQL command in SQL view

Answer

You can use query wizard or design view

Question 3

In Access, to Exit Office Access 2007Access

Accepted Answer

ALT+F4

Answer

CTRL+N

Answer

CTRL+O

Answer

None of these

Question 4

In Access press CTRL+N to

Accepted Answer

Open a new database

Answer

Open an existing database

Answer

Exit Office Access 2007

Answer

None of these

Question 5

Cascade update option

Accepted Answer

Both of above

Answer

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

Answer

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

Answer

None of above

Question 6

What determines a table's sort order?

Accepted Answer

Index field

Answer

AutoNumber field

Answer

Field order

Answer

Primary key

Question 7

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

Accepted Answer

CTRL+V

Answer

CTRL+C

Answer

CTRL+X

Answer

None of these

Question 8

In Access press LEFT ARROW or CTRL+LEFT ARROW

Accepted Answer

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

Answer

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

Answer

Move the selected control up

Answer

None of these

Question 9

What is a form in MS Access

Accepted Answer

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

Answer

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

Answer

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

Answer

All of above