MS Access MCQ Questions and solutions with explanations

Section 1 Section 2 Section 3 Section 4 Section 5 Section 6

1.
Which of the following is a database management system?

A. Ms word

B. Ms excel

C. Oracle

D. Lotus 1-2-3

Answer & Solution Discuss in Board Save for Later

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.

Answer & Solution Discuss in Board Save for Later

3.
__________ is the clear leader for personal databases.

A. Microsoft Access

B. Microsoft FoxPro

C. Borland dBase

D. MySQL

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

8.
A collection of related tables is called

A. Row

B. Record

C. Database

D. File

Answer & Solution Discuss in Board Save for Later

9.
In Access to switch to Form view from form Design view

A. F2

B. F4

C. F5

D. F6

Answer & Solution Discuss in Board Save for Later

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

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

MS Access MCQ Questions and solutions with explanations | MS Office

1. Which of the following is a database management system?

Answer & Solution

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

Answer & Solution

3. __________ is the clear leader for personal databases.

Answer & Solution

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

Answer & Solution

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

Answer & Solution

6. In Access press ALT+SPACEBAR to

Answer & Solution

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

Answer & Solution

8. A collection of related tables is called

Answer & Solution

9. In Access to switch to Form view from form Design view

Answer & Solution

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

Answer & Solution

Read More Section(MS Access)

1.
Which of the following is a database management system?

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

3.
__________ is the clear leader for personal databases.

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

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

6.
In Access press ALT+SPACEBAR to

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

8.
A collection of related tables is called

9.
In Access to switch to Form view from form Design view

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