FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Access_Module_2

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

A crosstab query calculates a statistic for data that is grouped by two different types of information. ____________________

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

To include all fields for a table in the design grid, double-click the ____________________ in the field list.

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

The ____________________ wildcard represents any individual character.

When you sort data, duplicates are not included.

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

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

You can include ____ in calculations to indicate which calculation should be done first.

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

The expression for a calculated field can be typed directly into the Field row.

To show the Navigation Pane if it is hidden, click the ____ Button.

For group calculations, Microsoft Access supports ____ built-in statistics.

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

To save a query, click the Save button on the ____.

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

To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.

The ____________________ wildcard represents any collection of characters.