MS Access MCQs

Question 1

Which of the following field properties is an expression that specifies criteria or requirements for entering data?

Accepted Answer

Validation Rule

Answer

Field Size

Answer

Format

Answer

Input Mask

Question 2

Referential integrity cannot be set for _______________ relationships.

Accepted Answer

Indeterminate

Answer

One-To-One

Answer

One-To-Many

Answer

Many-To-Many

Question 3

When you add fields in ________, a Field List pane displays.

Accepted Answer

Layout View

Answer

Design View

Answer

Print Preview

Answer

Report View

Question 4

To display value from table for a label control

Accepted Answer

Set the record source property and then control source

Answer

Set teh control source and record source prom property panel

Answer

Choose the databse, table, field and select data value to display

Answer

Look at the table and type value in the caption

Question 5

In a junction table, the _________ field consists of the foreign key from both the linked tables.

Accepted Answer

foreign key

Answer

first defined

Answer

last defined

Answer

primary key

Question 6

In a datasheet, what does each column represent?

Accepted Answer

Field

Answer

Record

Answer

Database

Answer

Table

Question 7

You can move between fields in a form by using any of these keys except

Accepted Answer

Page up

Answer

Tab

Answer

Enter

Answer

Shift+tab

Question 8

What do you call a collection of records matching parameters of a query?

Accepted Answer

Dynaset

Answer

Field

Answer

Record

Answer

Query

Question 9

Which data type is better to use for storing the price of an item?

Accepted Answer

Currency

Answer

Text

Answer

AutoNumber

Answer

Number