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.
Quick Access Toolbar
To save a query, click the Save button on the ________.
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 change the design of a query, right-click the query and then click ________ on the shortcut menu.
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 find all clients whose names begin with Gr, enter ________ in the Criteria row of the appropriate column.
To find all individuals who's name is Francis or Frances, enter ________ in the Criteria row of the appropriate column.
square brackets [ ]
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 use a parameter query, right-click the query in the Navigation Pane and then click ________ on the shortcut menu.
Less than (<), greater than (>), and NOT (not equal to) are examples of ________.
The ________ operator allows you to search for a range of values in one field.
To order the records in the answer to a query in a particular way, you ________ the records.
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 omit duplicates from a query, use the property sheet and change the Unique Values property to _______.
Use a query to ________ tables; that is, to find records in two tables that have identical values in matching fields.
A(n) ________ join is the default join in Access.
To display the Join Properties dialog box, right-click the join line and click ________ on the shortcut menu.
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 export data from a query to Excel, select the query in the Navigation Pane, click ________ on the Ribbon, and then click the Excel 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 ________.
parentheses ( )
You can include ________ in calculations to indicate which calculation should be done first.
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 include the Total row in the design grid, click the ________ button on the Design tab.
To find the largest amount paid amount for a client, select _______ as the entry in the Total row for the Amount Paid column.
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 indicate grouping in Access, select ________ as the entry in the Total row for the field to be used for grouping.
To create a crosstab, click the ________ button on the Create tab.
Shutter Bar Open/Close
To show the Navigation Pane if it is hidden, click the ________ Button.
Tables and Related Views
To organize entries in the Navigation Pane by table, click ________ on the Navigation Pane menu.
To quit Access, click the ________ button on the right side of the Access title bar.