MS Access MCQs

Question 1

While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into

Accepted Answer

outline rectangle

Answer

a doctor's sign

Answer

thin + sign

Answer

None of above

Question 2

An Access database object that is used to enter, view or edit records

Accepted Answer

Form

Answer

Table

Answer

Query

Answer

Report

Question 3

A- Press DOWN ARROW or CTRL+DOWN ARROW , B- Press SHIFT+LEFT ARROW: 1- Move the selected control down, 2- Reduce the width of the selected control.

Accepted Answer

A-1, B-2

Answer

A-2, B-2

Answer

A-1, B-1

Answer

A-2, B-1

Question 4

Query design window has two parts. The upper part shows

Accepted Answer

Tables with fields and relationships between tables

Answer

Name of fields, field type and size

Answer

Criteria

Answer

Sorting check boxes

Question 5

Which of the following statements about tab order setting is NOT true?

Accepted Answer

The tab order setting is usually right-to-left and top-to-bottom.

Answer

The actual tab order setting for a form can be used in the Form View.

Answer

The tab order setting determines the movement of the insertion point through a form.

Answer

The default tab order setting can be altered by moving the controls in the Design View.

Question 6

When creating an input mask this character does not require an entry, but if an entry is made it must be a letter from a-z

Accepted Answer

?

Answer

!

Answer

#

Answer

\

Question 7

what is a fast way to adjust the width of a column?

Accepted Answer

Double click the right side of the column heading

Answer

Right click the left side of the column heading

Answer

Double click the left side of the column heading

Answer

Select tools>adjust column width from the menu

Question 8

What type of relationship is created when you select a primary key in both related tables?

Accepted Answer

One-To-One

Answer

Indeterminate

Answer

One-To-Many

Answer

Many-To-Many

Question 9

How can you display Pivot Table report summary data in a currency format?

Accepted Answer

Modify the field settings

Answer

Use custom calculation

Answer

Type in the currency symbol

Answer

None of the above