MS Access MCQs

Question 1

Which of the following field properties enforces the use of parentheses when keying an area code?

Accepted Answer

Input Mask

Answer

Field Size

Answer

Format

Answer

Validation Rule

Question 2

In Access press to Open the Choose Builder dialog box (Design view window of forms and reports)

Accepted Answer

F7

Answer

F6

Answer

F8

Answer

None of these

Question 3

Which of the following is not a type of relationship that can be applied in Access database

Accepted Answer

All of above can be applied

Answer

One to One

Answer

One to Many

Answer

Many to Many

Question 4

Which of the following functions CANNOT be used in the Totals row?

Accepted Answer

Round

Answer

Average

Answer

Count

Answer

Maximum

Question 5

Which criteria do not return the position "Officer" as a match?

Accepted Answer

position = "O#r"

Answer

position = "*ff*"

Answer

position = "O??icer"

Answer

position = " ?ff*"

Question 6

To remove all Sorts in a table you can click the ______ command.

Accepted Answer

Clear All Sorts

Answer

Delete All Sorts

Answer

Eliminate All Sorts

Answer

Remove All Sorts

Question 7

The expression builder is an access tool that controls an expression___ for entering an expression

Accepted Answer

Box

Answer

Table

Answer

Cell

Answer

Palette

Question 8

The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.

Accepted Answer

primary, foreign

Answer

primary, common

Answer

foreign, primary

Answer

foreign, common

Question 9

Which of the following may not be a database?

Accepted Answer

A presentation created in PowerPoint

Answer

Data presented in table in MS Word document

Answer

Data entered in Excel spreadsheet

Answer

A telephone diary