MS Access MCQs

Question 1

When a picture or other graphic image is placed in the report header section it will appear____

Accepted Answer

Once in the beginning of the report

Answer

At the top of every page

Answer

Every after record break

Answer

On the 1st and last pages of the report

Question 2

The insertion point looks like a(n) ______.

Accepted Answer

I-beam

Answer

H-pointer

Answer

I-pointer

Answer

H-beam

Question 3

What does the expression [detail] ! [product] * 1.30 do?

Accepted Answer

multiplies the contents of product in the detail table by 1.3

Answer

multiplies the contents of detail and product fields by 1.3

Answer

First divides detail by product and then multiplies by 1.3

Answer

multiplies the contents of detail in the product table by 1.3

Question 4

In Access press DOWN ARROW or CTRL+ DOWN ARROW

Accepted Answer

None of these

Answer

Move the selected control to the right (except controls that are part of a layout)

Answer

Move the selected control to the left (except controls that are part of a layout)

Answer

Move the selected control up

Question 5

In a query's Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?

Accepted Answer

The relationship between the two tables locally

Answer

The join line but not the relationship between the two tables

Answer

The relationship between the two tables globally

Answer

The primary key of the first table

Question 6

The file extension for an access 2003 database is

Accepted Answer

Mdb

Answer

Exe

Answer

Doc

Answer

Exc

Question 7

Which of the following is a condensed form of standard generalized markup language?

Accepted Answer

XML

Answer

HTML

Answer

XSD

Answer

XSL

Question 8

According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control?

Accepted Answer

cbo

Answer

cob

Answer

cmb

Answer

cbx

Question 9

Press the following keys in Access to Open the Save As dialog box

Accepted Answer

F12

Answer

CTRL+P

Answer

P or CTRL+P

Answer

CTRL+S or SHIFT+F12