MS Access MCQs

Question 1

Which of the following field properties displays a model or pattern for entering data?

Accepted Answer

Input Mask

Answer

Field Size

Answer

Format

Answer

Validation Rule

Question 2

What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor?

Accepted Answer

The associated code is displayed in the Code pane.

Answer

The associated code is displayed in a new window.

Answer

The object is deleted from the Project pane.

Answer

The object's property sheet opens.

Question 3

Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?

Accepted Answer

Match: Start of Field

Answer

Match Case

Answer

Match: Whole Field

Answer

Match: Any Part of Field

Question 4

Which of the following database objects can have more than one Group Header/Footer section?

Accepted Answer

Reports

Answer

Forms

Answer

Queries

Answer

Tables

Question 5

Which of the following best describes the grouped report?

Accepted Answer

A report that displays data grouped by fields you specify

Answer

A part of report that can be generated by the report wizard

Answer

A report that displays data that has been sorted in ascending or descending order

Answer

None of a the above

Question 6

The ______ is a wild card that represents one or more characters.

Accepted Answer

asterisk

Answer

question mark

Answer

exclamation mark

Answer

dollar sign

Question 7

Which control lets a user create multiple pages in a form?

Accepted Answer

Tab control

Answer

Check box control

Answer

Combo box control

Answer

Option group control

Question 8

In Access press to Toggle the focus forward between controls in the wizard

Accepted Answer

TAB

Answer

ALT+N

Answer

ALT+B

Answer

ALT+F

Question 9

______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.

Accepted Answer

Layout View

Answer

Design View

Answer

Print Preview

Answer

Report View