Exam 8: Access: Querying a Database

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

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

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

To indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

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

When you sort data, duplicates are not included.

The arithmetic symbols for use in query calculations are ____.

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

You can export data from Access to the standard Word format.

In the accompanying figure, the lower pane in the window where you enter criteria is called the ____.

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

A summary function is a function that performs some mathematical function against a group of records.

Crosstab queries are useful for summarizing data by category or group.

You cannot create a report for a query.

In the accompanying figure, Amount Paid is the ____ key.

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

In the accompanying figure, you can delete the table by pressing and holding or right-clicking the field list and tapping or clicking ____ on the shortcut menu.

In the accompanying figure, press and hold or right-click the join line and tap or click ____ on the shortcut menu to display the Join Properties dialog box.