MS Access MCQ Questions and solutions with explanations

1

Which of the following is a database management system?

A) Ms word B) Ms excel C) Oracle D) Lotus 1-2-3

Discuss

Answer & Solution

Answer: Option C

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

2

Which of the following statements about PivotChart View is NOT true?

A) It is used to graphically summarize and analyze data in a table, query, or form. B) It can be used to view different levels of detail or to specify custom layout. C) It displays field values that can be switched for different views of data. D) It displays the same information as a crosstab query, except for the counts and sums of numeric fields.

Discuss

Answer & Solution

Answer: Option D

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

3

__________ is the clear leader for personal databases.

A) Microsoft Access B) Microsoft FoxPro C) Borland dBase D) MySQL

Discuss

Answer & Solution

Answer: Option A

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

4

Which of the following relationship is not valid in MS Access ?

A) Many to Many B) Many to Null C) One to One D) One to Many

Discuss

Answer & Solution

Answer: Option B

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

5

This is the stage in database design where one gathers and list all the necessary fields for the database project.

A) Data definition B) Data refinement C) Establishing relationship D) None of the above

Discuss

Answer & Solution

Answer: Option A

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

6

In Access press ALT+SPACEBAR to

A) Display the Control menu B) Display the shortcut menu C) Close the active window D) None of these

Discuss

Answer & Solution

Answer: Option A

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

7

The database language that allows you to access or maintain data in a database

A) DCL B) DML C) DDL D) None of above

Discuss

Answer & Solution

Answer: Option B

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

8

A collection of related tables is called

A) Row B) Record C) Database D) File

Discuss

Answer & Solution

Answer: Option C

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

9

In Access to switch to Form view from form Design view

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

Discuss

Answer & Solution

Answer: Option C

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

10

In an application created using the database wizard, the main menu is presented as a:

A) form, called a switchboard B) report, called a menu C) table, called a switchboard D) query, called a menu

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