Exam 4: Querying a Database

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?

To find all customers whose returns are greater than $0.00 or whose book rep is book rep number 42, enter each criterion on the same row.

To enter a number in a criterion, type the number without any dollar signs or commas.

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

To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

To find all customers whose names begin with Sr, enter ____________________ as the criterion for the Customer Name field.

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

In the accompanying figure, you can remove a column by tapping or clicking just above the field name to select the column and then tapping or clicking the ____ key(s).

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 find all individuals whose name is Robin or Robyn, enter ____ in the Criteria row of the appropriate column.

The ____________________ is an Access tool that helps you create complex expressions.

To find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.

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.

In the accompanying figure, the ____ line between matching fields in the two tables indicates that the tables are related.

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

To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.