Exam 4: Access: Querying a Database

To search for a range of values in one field, use the RANGE operator.

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

To find all individuals whose name is Tom or Tim, enter ____ in the Criteria row of the appropriate column.

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

An inner join is the default join in Access.

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

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

Explain the difference between an inner join and an outer join.

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 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 show the Navigation Pane if it is hidden, click the ____ Button.

Figure 2-1 In the accompanying figure, you can find all clients whose names begin with Be, by entering _____ in the Criteria row of the Client Name field.

Parameter queries are useful for summarizing data.

To print a query without first opening it, select the query in the Navigation Pane and then click the Office Button, point to Print on the Office Button menu, and then click ____ on the Print submenu

You can click either the View button or the ____ button on the Ribbon to execute a query.

To remove a table from a query, right-click the field list and then click Drop Table on the shortcut menu.

A(n)____________________ is a condition that the records to be included in a query must satisfy.