Exam 16: Access: Querying a Database

To change the design of a query that is not currently open,press and hold or right-click the query in the Navigation Pane and then tap or click ____________________ on the shortcut menu.

Identify the letter of the choice that best matches the phrase or definition. -Row that displays in the design grid when aggregate functions are used.

To organize entries in the Navigation Pane by table,click ____ on the Navigation Pane menu.

To order the records in the answer to a query in a particular way,you ____ the records.

To re-use saved export steps,tap or click the Saved Exports button on the ____ tab on the ribbon.

To calculate statistics for only those records that satisfy certain criteria,select ____ as the entry in the Total row for the field,and then enter the criterion in the Criteria row.

To export data from a query to Excel,select the query in the Navigation Pane,tap or click ____ on the ribbon,and then tap or click the Excel button.

The ____________________ function finds the smallest value in a group of records.

To use a parameter query,press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

To create a parameter query,enter a parameter rather than a specific value as a criterion in the design grid.The parameter must be enclosed in ____.

To find all customers whose names begin with S,enter ____ in the Criteria row of the Customer Name field.

____________________ are symbols that represent any character or combination of characters.

The ____________________ wildcard represents any individual character.

The expression for a calculated field can be typed directly into the Field row.

To find the largest amount paid amount for a client,select ____ as the entry in the Total row for the Amount Paid column.

Identify the letter of the choice that best matches the phrase or definition. -Use to select values in a list.

The asterisk (*)wildcard represents any collection of characters.

Identify the letter of the choice that best matches the phrase or definition. -Either individual criterion must be true in order for the compound criterion to be true.

A(n)____________________ query is a query that prompts for input whenever it is used.

Case 2-1 Bavant needs to gather some additional statistics on its customers.An employee at Bavant has created an initial query as shown in the accompanying figure that calculates the average amount paid.The employee is unsure what aggregate functions to use for additional calculations. -Which aggregate function will find the customer with the largest amount paid?