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

Short Answer

Review LaterAdd Note

Review Later

The ____________________ wildcard represents any individual character.

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

A) curly braces { }
B) brackets [ ]
C) parentheses ( )
D) slashes //

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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.

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

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

The only calculated fields you can create in Access are those involving addition and subtraction.

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.

The ____________________ wildcard represents any collection of characters.

When you sort data, duplicates are not included.

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

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

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

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

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

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

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 largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.

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

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