Exam 3: Querying a Database

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

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

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

A query that prompts for input whenever it is run is a run-time query.

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

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

An inner join is the default join in Access.

To find all clients whose names begin with Gr, enter ____________________ as the criterion for the Client Name field.

A(n) ____________________ is a window containing the various properties of the object.

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

Grouping means creating groups of records that share some common characteristic.

In the accompanying figure, the criterion for Current Due is 0. The query results for this query will display ____ in the Current Due field.

To combine criteria with ____________________, place the criteria on the same line.

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

To restrict the objects that appear on the Navigation Pane use the Restrict Bar.

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

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.

The expression for a calculated field can be typed directly into the Field row.

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.