MS Access MCQs

Question 1

Which of the following is the default join between two recordsets?

Accepted Answer

Inner join

Answer

Left outer join

Answer

Right outer join

Answer

Self join

Question 2

It is a sign or symbol that specifies, operator, and values that produce a result

Accepted Answer

operator

Answer

query

Answer

expression

Answer

None of the above

Question 3

The report footer section is most useful for displaying:

Accepted Answer

grand totals

Answer

Column headings

Answer

subtotals

Answer

page numbers

Question 4

Which part of the IIF expression is the action performed if the true condition exists?

Accepted Answer

second

Answer

inner

Answer

first

Answer

third

Question 5

how do you update pivot table report data after changes are made to the source data?

Accepted Answer

Click the report, and on the pivot table toolbar, click the refresh data button

Answer

Save your changes, close the workbook, and then reopen it.

Answer

Select the pivot table worksheet and press f9 on the keyboard

Answer

All of the above

Question 6

In the form wizard dialog box, the fields from the selected table are displayed in this list box.

Accepted Answer

Available fields

Answer

All fields

Answer

All records

Answer

Available records

Question 7

To store your picture in a database requires a(n) __________ field.

Accepted Answer

BLOB

Answer

text

Answer

image

Answer

logical

Question 8

You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?

Accepted Answer

60

Answer

7

Answer

17

Answer

Not enough information to tell

Question 9

If a color property contains "#336699", how many blue units are in the color?

Accepted Answer

99

Answer

33

Answer

66

Answer

255