MS Access MCQs

Question 1

A collection of related records in database is known as a

Accepted Answer

Table

Answer

Database

Answer

File

Answer

None of above

Question 2

How can you define a field so that when entering data for that field it will display ****** instead of actual typed text

Accepted Answer

Input mask

Answer

Validation Rule

Answer

Indexed

Answer

IME Mode

Question 3

In Access to increase the width of the selected control

Accepted Answer

SHIFT+RIGHT ARROW

Answer

SHIFT+DOWN ARROW

Answer

DOWN ARROW or CTRL+DOWN ARROW

Answer

None of these

Question 4

Saving a database in access is done

Accepted Answer

At the beginning of the database

Answer

The first time you save data

Answer

When closing the application

Answer

During auto save

Question 5

What is the maximum length a text field can be?

Accepted Answer

255

Answer

120

Answer

265

Answer

75

Question 6

This query wizard will create a select query.

Accepted Answer

Simple

Answer

Crosstab

Answer

Find duplicates

Answer

Design view

Question 7

in a relational schema, each tuple is divided into fields called

Accepted Answer

Domains

Answer

Relations

Answer

Queries

Answer

All of the above

Question 8

Which is NOT an option of the Picture Size Mode property?

Accepted Answer

Fit

Answer

Clip

Answer

Stretch

Answer

Zoom

Question 9

To print information from a table, the __________ tool is the best choice.

Accepted Answer

report

Answer

form

Answer

query

Answer

macro