Acess Chapter 2

To re-use saved export steps, 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.

Less than (<), greater than (>), and NOT (not equal to) are examples of _

To create a crosstab, click the ____ button on the CREATE tab.

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

The ____ operator allows you to search for a range of values in one field.

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

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

To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

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 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 save a query, click the Save button on the ____.

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

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

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

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 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 order the records in the answer to a query in a particular way, you ____ the records.

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

To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Report Wizard button

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.

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

Square brackets []