Exam 8: Access: Querying a Database

To export data from a query to Excel, select the query in the Navigation Pane, tap or click ____ on the ribbon, and then tap or click the Excel button.

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

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

Modified Multiple Choice The special criteria that can be used in queries are ____.

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

When you sort data in a query, the records in the underlying table are actually rearranged.

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

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

After you create and save a query, you can use it in a variety of ways.Name three of these ways.

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

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

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

In the accompanying figure, the Customer table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

To find all individuals whose name is Robin or Robyn, enter ____ in the Criteria row of the appropriate column.

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

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