Exam 7: Access_Module_2

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.

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

A query that prompts for input whenever it is run is a dialog query.

Less than (<), greater than (>), and NOT (not equal to) are examples of ____.

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

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

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

In fixed-width files, each record is on a separate line and the fields are separated by a special character.

To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Report Wizard button.

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

Grouping means creating groups of records that share some common characteristic.

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.

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