Exam 4: Querying a Database

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

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

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

A question that is asked of Access or any other database management system is called a(n) ____________________.

To combine criteria with ____________________, each criterion must go on separate rows in the Criteria area of the grid.

To view the results of a query, open it by pressing and holding or right-clicking the query in the Navigation Pane and tapping or clicking ____ on the shortcut menu.

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

When you sort data, duplicates are not included.

If the criterion for Current Due field is 0, the query results for this query will display ____ in the Current Due field.

Which aggregate function will find the customer with the largest amount paid?

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

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

The field or fields on which records are sorted is called the sort key.

Critical Thinking Questions Case 2-2 Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013. The caption for the Start Date field should be Started when the query results display. How can Bavant change the caption?

When you create a query, you should follow some general guidelines for query design. What are these six guidelines?

To include all fields in the design grid, double-click the question mark (?) in the field list.

A(n) ____________________ function is a function that performs some mathematical function against a group of records.

To find all customers whose names begin with S, enter S? in the Criteria row of the design grid.

To print the results of a query that is open, tap or click FILE on the ribbon, tap or click the ____ tab in the Backstage view, and then tap or click Quick Print.