Exam 4: Access: Querying a Database

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

Critical Thinking Questions Case 1 JSP Recruiters needs to gather some additional statistics on its clients. An employee at JSP has created an initial query as shown in the accompanying figure that calculate the average amount paid. The employee is unsure what aggregate functions to use for additional calculations. Figure 2-5 Which aggregate function will calculate the total amount due for all clients?

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

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

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

The ____________________ wildcard represents any individual character.

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

To change the design of a query, right-click the query and then click ____ on the shortcut menu.

The question mark (?)wildcard represents any collection of characters.

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

To display the Join Properties dialog box, right-click the join line and click ____ on the shortcut menu.

A field name used in a calculation always must be enclosed in square brackets.

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

The caption for the Current Due field should be Owed when the query results display. How can JSP change the caption?

To find all clients whose amount paid is greater than $20,000.00 or whose recruiter is recruiter 21, enter each criterion on the same line.

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

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.

If there are no restrictions involved in the query, nor any special order or calculations, you can use the ____________________ wizard.

The ____________________ wildcard represents any collection of characters.