MS Access MCQs

Question 1

The size of Yes No field is always

Accepted Answer

1 bit

Answer

1 byte

Answer

1 character

Answer

1 GB

Question 2

The Input Mask wizard does NOT include the ability to do which of the following?

Accepted Answer

Force all uppercase

Answer

Define placeholder

Answer

Store symbols with data

Answer

Use preset masks

Question 3

The_______ operator will cause a record to be selected only if two or more conditions are satisfied

Accepted Answer

And

Answer

Or

Answer

If or

Answer

Range

Question 4

Which control does access use to link data access page components to Access data?

Accepted Answer

Microsoft office data source control

Answer

Microsoft dynamic data control

Answer

Microsoft data connection control

Answer

None of the above

Question 5

The Fill/Back Color button on the formatting toolbar applies color to:

Accepted Answer

The text in the selected control

Answer

The border fo the selected control

Answer

All aspects of the control

Answer

The background of the selected control

Question 6

Unlike text data type, this can store up to maximum of 65, 535 characters.

Accepted Answer

memo

Answer

data/time

Answer

number

Answer

All of above

Question 7

Database Management Systems are featured with:

Accepted Answer

The ability to store large amount of data to facilitate easy update, sort and retrieval

Answer

The facility to easy editing, spelling check, auto pagination, lay out and printing reports

Answer

The ability to calculate efficiently with the help of built-in functions and analyze

Answer

All of above

Question 8

In access press to Move to the next page of the wizard

Accepted Answer

ALT+N

Answer

TAB

Answer

ALT+B

Answer

ALT+F

Question 9

Which tool do you use to create a query object?

Accepted Answer

Simple query wizard

Answer

Database wizard

Answer

Simple filter wizard

Answer

Table query wizard