MS Access MCQs

Question 1

In Access 2007, to set a table to open as a document tab, you need to go to the ____.

Accepted Answer

Microsoft Office button

Answer

Navigation Pane

Answer

Quick Access toolbar

Answer

Database Tools command tab

Question 2

The ascending order of data hierarchy is?

Accepted Answer

Bit - byte - field - record - file - databse

Answer

Bit - byte - record - field - file - database

Answer

Byte - bit - field - record - file - database

Answer

Bit - byte - field - record - database - file

Question 3

To insert a graphic of your company's logo on a report

Accepted Answer

Click the image button on the toolbox and drag on the report to draw a place holder for the graphics

Answer

You can't. Microsoft Access won't let you insert graphics files.

Answer

Select Insert > Picture from the menu

Answer

Select Tools > Insert Picture from the menu

Question 4

In Access press ENTER to

Accepted Answer

Restore the selected minimized window when all windows are minimized

Answer

Toggle the Navigation Pane

Answer

Cycle between open windows

Answer

Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window

Question 5

What happens when a user selects a record in a form and presses [Delete]?

Accepted Answer

The record is deleted in the form and from its source table.

Answer

The record is deleted in the form, but not from its source table.

Answer

The record is neither deleted in the form, nor from its source table.

Answer

The record is not deleted in the form, but is deleted from its source table.

Question 6

Which of the following statement is true

Accepted Answer

Queries can include calculated fields that do not exist in table

Answer

Reports can be used to retrieve data from tables and calculate

Answer

Queries can be printed in well formatted manner and presented as the information

Answer

Reports and forms are similar but forms are use to print but reports to display on screen only

Question 7

DCL provides commands to perform actions like

Accepted Answer

authorizing access and other control over database

Answer

Change the structure of tables

Answer

insert, update or delete records and data values

Answer

None of above

Question 8

In Access to open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only)

Accepted Answer

CTRL+F

Answer

CTRL+H

Answer

SHIFT+F4

Answer

None of these

Question 9

What do you mean by one to many relationship between Student and Class table?

Accepted Answer

One student can have many classes

Answer

One class may have many student

Answer

Many classes may have many students

Answer

Many students may have many classes