MOS Access: Queries, Forms and Reports 2

Question 1

A manager wants a query that shows total sales with salespeople as row headings and months as column headings. Which query type should you create?

Accepted Answer

Crosstab query

Answer

A crosstab query summarizes values in a grid with one field as row headings and another as column headings.

Question 2

Which criteria entry makes a query prompt the user to type a state each time it runs?

Accepted Answer

[Enter State]

Answer

Text enclosed in square brackets that doesn't match a field name becomes a parameter prompt.

Question 3

You need to include the Region field in a query's criteria but not display it in the results. What should you do?

Accepted Answer

Clear the Show check box for the field

Answer

Clearing the Show check box keeps the field's criteria active while hiding it from the datasheet.

Question 4

Which expression correctly creates a calculated field named LineTotal in a query?

Accepted Answer

LineTotal: [Quantity]*[UnitPrice]

Answer

In the Field row, a calculated field uses the format Alias: expression, with field names in brackets.

Question 5

Which criteria returns all customers whose last name begins with the letter S?

Accepted Answer

Like "S*"

Answer

The asterisk wildcard after S matches any characters that follow it.

MOS - Microsoft Office Specialist Certification Practice Test