MS Access MCQs

Question 1

In Access to open new database press

Accepted Answer

CTRL+N

Answer

CTRL+O

Answer

ALT+F4

Answer

None of these

Question 2

Press the following keys in Access to Save a database object

Accepted Answer

CTRL+S or SHIFT+F12

Answer

CTRL+P

Answer

P or CTRL+P

Answer

F12

Question 3

In Access press TAB

Accepted Answer

Exit the combo box or list box

Answer

Move up one line

Answer

Move up one page

Answer

None of these

Question 4

Microsoft Access is a

Accepted Answer

RDBMS

Answer

OODBMS

Answer

ORDBMS

Answer

Network database model

Question 5

To sort records in a table

Accepted Answer

All of above

Answer

Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar

Answer

Open table, click Sort button on database toolbar, choose field based on which to sort, click OK

Answer

Click the field heading to sort it ascending or descending

Question 6

Which of the following can be an example of a database?

Accepted Answer

All of above

Answer

Address book of all the suppliers of a company

Answer

Salary sheet of all the employees of a company

Answer

Records of daily sales transactions of a company

Question 7

In Access press F11 to

Accepted Answer

Toggle the Navigation Pane

Answer

Cycle between open windows

Answer

Restore the selected minimized window when all windows are minimized

Answer

Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window

Question 8

In Access press SHIFT+F10 to

Accepted Answer

Display the shortcut menu

Answer

Display the Control menu

Answer

Close the active window

Answer

None of these

Question 9

How can you display the relationship in a database?

Accepted Answer

All the above are true

Answer

Select View > Relationship form the menu

Answer

Click the Relationship button on the toolbar

Answer

Select Edit >Relationship from the menu