Access: Queries, Forms and Reports Flashcards

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?

Answer: Crosstab query

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

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

Answer: [Enter State]

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

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

Answer: Clear the Show check box for the field

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

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

Answer: LineTotal: [Quantity]*[UnitPrice]

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

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

Answer: Like "S*"

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

In a totals query, you want to show how many orders each customer placed. CustomerID is set to Group By. What should the OrderID field's Total row be set to?

Answer: Count

Count tallies the number of records in each group.

Which query type creates a brand-new table from the results of a query?

Answer: Make Table query

A Make Table query writes the query results into a new table.