Exam 7: Access_Module_2

The ____________________ wildcard represents any collection of characters.

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

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

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

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

The ____________________ wildcard represents any individual character.

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.

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

To show the Navigation Pane if it is hidden, click the ____ Button.

A crosstab query calculates a statistic for data that is grouped by two different types of information. ____________________

You can include ____ in calculations to indicate which calculation should be done first.

The special criteria that can be used in queries are ____.

To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.

A summary function is a function that performs some mathematical function against a group of records. ____________________

For group calculations, Microsoft Access supports ____ built-in statistics.

When you sort data, duplicates are not included.

To print the results of a query that is open, click FILE on the ribbon, click the ____ tab in the Backstage view, and then click Quick Print.

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 ____.

The only calculated fields you can create in Access are those involving addition and subtraction.

To include all fields for a table in the design grid, double-click the ____________________ in the field list.