MS Access MCQs

Question 1

What data type should yo choose for a zip code field in a table?

Accepted Answer

Text

Answer

Number

Answer

Memo

Answer

All of above

Question 2

Which control types is most often associated with a bound control?

Accepted Answer

text box

Answer

command button

Answer

label

Answer

list box

Question 3

The most popular commercial DBMS.

Accepted Answer

Oracle

Answer

Microsoft SQL Server

Answer

Microsoft Access

Answer

MySQL

Question 4

Which of the following statements regarding charts is incorrect?

Accepted Answer

It can be inserted into a form only.

Answer

It can be designed as a stand-alone object.

Answer

It can be linked to the object in which it is plac

Answer

None of these

Question 5

To apply an AutoFormat to an entire Form, what must you select first?

Accepted Answer

Form Selector

Answer

Document tab

Answer

Detail section

Answer

Any control

Question 6

In Access 2007, to make changes in the Trust Center, you need to go to the _________.

Accepted Answer

Microsoft Office button

Answer

Navigation Pane

Answer

Quick Access toolbar

Answer

Database Tools command tab

Question 7

Which of the following views enables users to create and modify the sections of a form?

Accepted Answer

Design

Answer

Datasheet

Answer

Form

Answer

Layout

Question 8

When entering field name, how many characters you can type in maximum?

Accepted Answer

64

Answer

60

Answer

68

Answer

Any number of character

Question 9

In a table to insert User's Voice, Data field should be

Accepted Answer

OLE Object

Answer

SoundField

Answer

VoiceField

Answer

Memo