Exam 12: Access_Module_2

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

Grouping means creating groups of records that share some common characteristic.

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

A property sheet is a window containing the various properties of the object.

To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

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

To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar. ____________________

To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query.

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

The ____________________ wildcard represents any collection of characters.

To sort records by amount paid within book rep number, specify Book Rep Number as the ____________________ key.

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

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

To enter a number in a criterion, type the number without any dollar signs or commas.

When you sort data in a query, the records in the underlying table are actually rearranged.

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.

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

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