MS Access MCQs

Question 1

Query can be use to select data from

Accepted Answer

Both A & B

Answer

Single Table

Answer

Multiple Tables

Answer

None of above

Question 2

The most open source DBMS.

Accepted Answer

MySQL

Answer

Microsoft SQL Server

Answer

Microsoft Access

Answer

Oracle

Question 3

Print options can be changed in the Print _______.

Accepted Answer

dialog box

Answer

tab

Answer

layout mode

Answer

setup routine

Question 4

Which of the following term is least related to database?

Accepted Answer

Columns

Answer

Attributes

Answer

Tuples

Answer

Relationship

Question 5

Which of the following database object produces the final result to present?

Accepted Answer

Reports

Answer

Forms

Answer

Queries

Answer

Tables

Question 6

If a piece of data is stored in two places in the database, then

Accepted Answer

Both a and b

Answer

Storage space is wasted

Answer

Changing the data is one spot will cause data inconsistency

Answer

It can be more easily accessed

Question 7

Which of the following statement is true?

Accepted Answer

In an indexed field you may or may not enter duplicate value depending upon setting

Answer

Foreign key fields don't allow duplicate values

Answer

In primary key field you can enter duplicate value

Answer

All statements are true

Question 8

You can set a controls border type to make the border invisible.

Accepted Answer

Do not display

Answer

Transparent

Answer

Invisible

Answer

No border

Question 9

How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:

Accepted Answer

Look up Wizard

Answer

Query Wizard

Answer

Form Wizard

Answer

Report Wizard