Exam 4: Querying a Database

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

In the accompanying figure, you can delete the table by pressing and holding or right-clicking the field list and tapping or clicking ____ on the shortcut menu.

To change the design of a query that is not currently open, press and hold or right-click the query and then tap or click ____ on the shortcut menu.

You can export data from Access to the standard Word format.

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.

If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

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

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

The asterisk (*) wildcard represents any collection of characters.

Less than ( ), and NOT (not equal to) are examples of ____.

In the accompanying figure, the lower pane in the window where you enter criteria is called the ____.

In fixed-width files, each record is on a separate line and the fields are separated by a special 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.

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

After you create and save a query, you can use it in a variety of ways. Name three of these ways.