MS Access MCQs

Question 1

Which function can not be used for calculated controls in a report?

Accepted Answer

MPT

Answer

SUM

Answer

AVG

Answer

COUNT

Question 2

A primary key in any table has the properties

Accepted Answer

Both of above

Answer

Not Null

Answer

No Duplicates

Answer

None of above

Question 3

Which of the following is the DBMS type

Accepted Answer

All of the Above

Answer

Flat File System

Answer

Hierarchical DBMS

Answer

Relational DMBS

Question 4

In access, this view is used to create and modify the structure of a form.

Accepted Answer

Form design

Answer

Normal

Answer

Datasheet

Answer

Control

Question 5

The following property determines what is displayed in a control.

Accepted Answer

The control source property

Answer

The display property

Answer

The comes from property

Answer

The data property

Question 6

Which of the following functions is used to all the values in a numeric field?

Accepted Answer

Count

Answer

Num

Answer

Sum

Answer

Total

Question 7

Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called

Accepted Answer

Primary key

Answer

Foreign key

Answer

Native key

Answer

Composite key

Question 8

Press the following keys in Access to Open the Print dialog box from Print Preview

Accepted Answer

P or CTRL+P

Answer

CTRL+P

Answer

S

Answer

C or ESC

Question 9

Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?

Accepted Answer

Press [Ctrl]+[+] and [Ctrl]+[-].

Answer

Press [Ctrl]+[C] and [Ctrl]+[V].

Answer

Right-click, choose from the shortcut menu Copy and Paste.

Answer

From the ribbon, select Copy and Paste.