Exam 2: Access 2 Querying a Database

Which aggregate function will find the customer with the largest amount paid?

To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

To include all fields in the design grid, double-click the question mark (?) in the field list.  ____________________

If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

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

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 re-use saved export steps, click the Saved Exports button on the ____ tab on the ribbon.

To combine criteria with ____________________, place the criteria on the same row.

To create a top-values query, use the Top Values box on the DESIGN tab to change the number of records to be included from All to the desired number.

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

In ____________________ files, the width of any field is the same on every record.

To save a query, click the Save button on the ____.

To include the Total row in the design grid, click the ____ button on the DESIGN tab.

The ____________________ wildcard represents any collection of characters.