Advertisement Upgrade to remove ads

Query Design

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

Open

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

Design View

To change the design of a query, right-click the query and then click ________ on the shortcut menu.

Print

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.

Gr*

To find all clients whose names begin with Gr, enter ________ in the Criteria row of the appropriate column.

Franc?s

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

Open

To use a parameter query, right-click the query in the Navigation Pane and then click ________ on the shortcut menu.

comparison operators

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

BETWEEN

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

sort

To order the records in the answer to a query in a particular way, you ________ the records.

Sort

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.

Yes

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

Join

Use a query to ________ tables; that is, to find records in two tables that have identical values in matching fields.

inner

A(n) ________ join is the default join in Access.

Join Properties

To display the Join Properties dialog box, right-click the join line and click ________ on the shortcut menu.

Create

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.

External Data

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.

Build

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.

Caption

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.

Totals

To include the Total row in the design grid, click the ________ button on the Design tab.

MAX

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

Where

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.

Group By

To indicate grouping in Access, select ________ as the entry in the Total row for the field to be used for grouping.

Query Wizard

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.

Close

To quit Access, click the ________ button on the right side of the Access title bar.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set