Exam 4: Querying a Database

To find all book reps whose start date is after 1/1/2013, use the ____________________ operator.

Crosstab queries are useful for summarizing data by category or group.

For group calculations, Microsoft Access supports ____ built-in statistics.

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

If a Security Warning appears when you open an Access database, tap or click the ____________________ button.

To sort records by amount paid within book rep number, specify Book Rep Number as the ____________________ key.

To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, tap or click ____ on the ribbon, and then tap or click the Report Wizard button.

A(n) ____________________ query is a query that prompts for input whenever it is used.

To create a top-values query, use the Top Values box on the DESIGN tab to change the number of records to be included from All to the desired number.

Critical Thinking Questions Case 2-1 Bavant needs to gather some additional statistics on its customers. An employee at Bavant has created an initial query as shown in the accompanying figure that calculates the average amount paid. The employee is unsure what aggregate functions to use for additional calculations. Which aggregate function will find the standard deviation?

To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

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

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

In ____________________ files, the width of any field is the same on every record.

A summary function is a function that performs some mathematical function against a group of records.

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

The results of a query display in ____________________ view.

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

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

The ____________________ function finds the smallest value in a group of records.