Exam 8: Access: Querying a Database

The accompanying figure illustrates using a query to ____ tables; that is, to find records in two tables that have identical values in matching fields.

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

The only calculated fields you can create in Access are those involving addition and subtraction.

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

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.

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

In the accompanying figure, Book Rep Number is the ____ key.

The ____________________ wildcard represents any collection of characters.

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

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

To re-use saved export steps, tap or click the Saved Exports button on the ____ tab on the ribbon.

____________________ are symbols that represent any character or combination of characters.

To include all fields for a table in the design grid, double-tap or double-click the ____________________ in the field list.

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.

The ____________________ wildcard represents any individual character.

Wildcards are symbols that represent any character or combination of characters.

To include the Total row in the design grid, click the ____ button on the DESIGN tab.

Critical Thinking Questions Case 2-2 Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013.What criteria should Bavant enter in the Start Date column of the design grid?