MS Access MCQs

Question 1

The _________ Builder is an Access tool for selecting colors from a palette or creating custom colors.

Accepted Answer

Color

Answer

Expression

Answer

Palette

Answer

Property

Question 2

This form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading.

Accepted Answer

Tabular

Answer

Columnar

Answer

Justified

Answer

Datasheet

Question 3

The following database object can you import from one Microsoft Access database to another?

Accepted Answer

All of the above

Answer

Queries

Answer

Tables

Answer

Forms

Question 4

Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?

Accepted Answer

Edit Relationships

Answer

Indexes

Answer

Option

Answer

Show Table

Question 5

The _________ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.

Accepted Answer

Date

Answer

Time

Answer

Calendar

Answer

Appointment

Question 6

how do you filter by selection?

Accepted Answer

Right click the field value and select filter by selection from the shortcut menu

Answer

Find and double click the value on which you want to base the filter

Answer

Find and select the value on which you want to base the filter and select tools>filter by selection from the menu

Question 7

The key uniquely identifies each record in a table.

Accepted Answer

primary key

Answer

key word

Answer

filed name

Answer

All of above

Question 8

A _______ often display summary data such as totals or counts.

Accepted Answer

Group Footer

Answer

Group Header

Answer

Report Header

Answer

Page Footer

Question 9

The __________ is used to access one record at a time.

Accepted Answer

form

Answer

query

Answer

filter

Answer

report