MS Access MCQs

Question 1

A small button with three dots usually displayed at the right of field properties box

Accepted Answer

Build button

Answer

Make button

Answer

Expression button

Answer

None of above

Question 2

In Access to Open a combo box

Accepted Answer

F4 or ALT+DOWN ARROW

Answer

DOWN ARROW

Answer

PAGE DOWN

Answer

F9

Question 3

Primary key is

Accepted Answer

All of the above

Answer

Uniquely identifies each record

Answer

Cannot be repeated

Answer

AutoNumber is example of Primary key

Question 4

Which of the following store command to retrieve data from database?

Accepted Answer

Queries

Answer

Forms

Answer

Reports

Answer

Tables

Question 5

An application that executes on separate PCs like this is called a(n) __________ application.

Accepted Answer

distributed

Answer

enterprise

Answer

tier

Answer

global

Question 6

To enter the input mask wizard

Accepted Answer

Click on the three dots to the right of the input mask entry field

Answer

Click on the three dots to the right of the caption entry field

Answer

Click on the three dots to the right of the format entry field

Answer

Click on the input mask toolbar

Question 7

Which is the valid data type in Access?

Accepted Answer

All of the above

Answer

Number

Answer

Text

Answer

Currency

Question 8

How many relations may exist between tables in databases?

Accepted Answer

3

Answer

4

Answer

2

Answer

1

Question 9

It is a database object to view, change, and analyze data in different ways

Accepted Answer

query

Answer

form

Answer

report

Answer

None of the above