MS Access MCQs

Question 1

In Access press CTRL+W or CTRL+F4 to

Accepted Answer

Close the active window

Answer

Display the Control menu

Answer

Display the shortcut menu

Answer

None of these

Question 2

A query prompts a user for a data and then displays only records that contain the specified date. The type of of query is this

Accepted Answer

A parameter query

Answer

A crosstab query

Answer

An update query

Answer

An action query

Question 3

A report module includes code for all event _______ triggered by events occurring on a specific report or its controls.

Accepted Answer

procedures

Answer

properties

Answer

macros

Answer

commands

Question 4

What are the columns in a Microsoft Access table called?

Accepted Answer

Fields

Answer

Rows

Answer

Records

Answer

Columns

Question 5

What are the different views to display a table

Accepted Answer

All of above

Answer

Datasheet view

Answer

Design view

Answer

Pivote table & pivot chart view

Question 6

Validation Rule in a field will

Accepted Answer

Checks the value entered when user leaves the field

Answer

Displays the value in specified format when user leaves the field

Answer

Defines the appearance for the text

Answer

There is no option of Validation Rule

Question 7

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

Accepted Answer

Structural

Answer

Relational

Answer

Network

Answer

All of the above

Question 8

What is the purpose of indexing?

Accepted Answer

To speedup data search

Answer

To reduce table size

Answer

both A and B

Answer

none of the above

Question 9

data items groped together for storage purposes are called a

Accepted Answer

Record

Answer

Title

Answer

List

Answer

String