MS Access MCQs

Question 1

It is most common type of query. It retrieves records from one or more tables and then displays the

Accepted Answer

Select

Answer

Parameter

Answer

crosstab

Answer

All of above

Question 2

When using Access Database, use this feature to have Access select only certain records in the database to prepare form letters.

Accepted Answer

Query

Answer

Report

Answer

Table

Answer

Tools

Question 3

Which of the following database object hold data?

Accepted Answer

Tables

Answer

Forms

Answer

Reports

Answer

Queries

Question 4

This database has only one table.

Accepted Answer

flat-file

Answer

relational

Answer

large

Answer

DBMS

Question 5

Switch from the Visual Basic Editor back to form or report Design view in Access press

Accepted Answer

A and B both are true

Answer

ALT+F11

Answer

SHIFT+F7

Answer

None is true

Question 6

A _______ is a major database object used to display information in a printable page format.

Accepted Answer

report

Answer

form

Answer

query

Answer

table

Question 7

Which of the following options is NOT a part of an option group?

Accepted Answer

Option group button

Answer

Option button label

Answer

Option group frame

Answer

Option group label

Question 8

The arranging of data in a logical sequence is called

Accepted Answer

Sorting

Answer

Classifying

Answer

Reproducing

Answer

Summarizing

Question 9

the way a particular application views the data from the database that the applicaton uses is a

Accepted Answer

Sub-schema

Answer

Module

Answer

Relational model

Answer

Schema