MS Access MCQ Questions and solutions with explanations

1

What are the different views to display a table

A) Datasheet view B) Design view C) Pivote table & pivot chart view D) All of above

Discuss

Answer & Solution

Answer: Option D

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

2

Validation Rule in a field will

A) Checks the value entered when user leaves the field B) Displays the value in specified format when user leaves the field C) Defines the appearance for the text D) There is no option of Validation Rule

Discuss

Answer & Solution

Answer: Option A

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

3

which of the following terms does not describe a database structure used by a dbms to link data from several files?

A) Relational B) Structural C) Network D) All of the above

Discuss

Answer & Solution

Answer: Option B

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

4

What is the purpose of indexing?

A) To reduce table size B) To speedup data search C) both A and B D) none of the above

Discuss

Answer & Solution

Answer: Option B

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

5

data items groped together for storage purposes are called a

A) Record B) Title C) List D) String

Discuss

Answer & Solution

Answer: Option A

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

6

It is an association established between common fields of two tables.

A) line B) relationship C) primary key D) records

Discuss

Answer & Solution

Answer: Option B

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

7

In a query, which row do you need to place wildcards to affect a parameter?

A) Arguments B) Criteria C) Fields D) Tables

Discuss

Answer & Solution

Answer: Option B

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

8

To create a new table, in which method you don't need to specify the field type and size?

A) Create table in Design View B) Create Table using wizard C) Create Table by Entering data D) All of above

Discuss

Answer & Solution

Answer: Option C

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

9

To assign a macro to an event, users need to open the form in Design View.

A) event B) property C) title D) macro

Discuss

Answer & Solution

Answer: Option A

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

10

A DBMS that runs on many different operating systems is said to be __________.

A) scalable B) robust C) platform independent D) distributed

Discuss

Answer & Solution

Answer: Option C

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

MS Access MCQ Questions and solutions with explanations | MS Office