MS Access MCQ Questions and solutions with explanations

1

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

A) Table B) Form C) Query D) Report

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

2

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.

A) A-1, B-2 B) A-2, B-2 C) A-1, B-1 D) A-2, B-1

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

3

Query design window has two parts. The upper part shows

A) Name of fields, field type and size B) Tables with fields and relationships between tables C) Criteria D) Sorting check boxes

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

4

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

A) The actual tab order setting for a form can be used in the Form View. B) The tab order setting determines the movement of the insertion point through a form. C) The tab order setting is usually right-to-left and top-to-bottom. D) The default tab order setting can be altered by moving the controls in the Design View.

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

5

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

A) ? B) ! C) # D) \

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

6

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

A) Right click the left side of the column heading B) Double click the left side of the column heading C) Double click the right side of the column heading D) Select tools>adjust column width from the menu

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

7

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

A) One-To-One B) Indeterminate C) One-To-Many D) Many-To-Many

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

8

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

A) Use custom calculation B) Type in the currency symbol C) Modify the field settings D) None of the above

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

9

In Access to switch to the property sheet (Design view in forms and reports in both Access databases and Access projects)

A) F2 B) F4 C) F5 D) F6

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

10

Which data type is better to use for storing phone number in the following format "977-1-1234567"?

A) Text B) AutoNumber C) Number D) Currency

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

MS Access MCQ Questions and solutions with explanations | MS Office