MS Access MCQs

Question 1

How to make a date field DOB store the dates like "2002/10/17" ?

Accepted Answer

By setting the format property to "yyyy/mm/dd"

Answer

By setting the input mask property to "yyyy/mm/dd"

Answer

By entering dates in yyyy, mm, dd order

Answer

none of the above

Question 2

In Access press to Move to the previous page of the wizard

Accepted Answer

ALT+B

Answer

TAB

Answer

ALT+N

Answer

ALT+F

Question 3

The operation of checking input data against specified criteria is known as?

Accepted Answer

Data validation

Answer

Data verification

Answer

Cross check

Answer

Data control

Question 4

A(n)_______ is a major object that can run independent of a control.

Accepted Answer

macro

Answer

event

Answer

property

Answer

procedure

Question 5

(IF [Age]>65, "Senior","Adult") This expression is an example of:

Accepted Answer

A conditional expression

Answer

Algebraic expression

Answer

Something that belongs in a Microsoft Excel book

Answer

A financial expression

Question 6

It is a query that when run displays its own dialog box prompting you for information, such as

Accepted Answer

Parameter

Answer

Select

Answer

crosstab

Answer

Append

Question 7

Which of the following can a Report Wizard NOT do?

Accepted Answer

Group fields into more than one Control Layout

Answer

Add summary functions

Answer

Create groups

Answer

Select fields

Question 8

A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.

Accepted Answer

aggregate function

Answer

format row

Answer

criteria row

Answer

format layout

Question 9

Cascade delete option

Accepted Answer

is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted

Answer

is used to delete all the records of all tables in a database

Answer

will repeat the recent delete operation to all the records of current table

Answer

None of above