FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 16: Access: Querying a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

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) DATABASE TOOLS
B) EXTERNAL DATA
C) OFFICE EXPORT
D) CREATE

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

Identify the letter of the choice that best matches the phrase or definition. -Either individual criterion must be true in order for the compound criterion to be true.

Identify the letter of the choice that best matches the phrase or definition. -Row that displays in the design grid when aggregate functions are used.

The ____________________ wildcard represents any individual character.

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

To find all customers whose names begin with S,enter ____ in the Criteria row of the Customer Name field.

To re-use saved export steps,tap or click the Saved Exports button on the ____ tab on the ribbon.

Identify the letter of the choice that best matches the phrase or definition. -Use to select values in a list.

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

To order the records in the answer to a query in a particular way,you ____ the records.

The asterisk (*)wildcard represents any collection of characters.

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

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.

A(n)____________________ query is a query that prompts for input whenever it is used.

To create a parameter query,enter a parameter rather than a specific value as a criterion in the design grid.The parameter must be enclosed in ____.

To change the design of a query that is not currently open,press and hold or right-click the query in the Navigation Pane and then tap or click ____________________ on the shortcut menu.

Case 2-1 Bavant needs to gather some additional statistics on its customers.An employee at Bavant has created an initial query as shown in the accompanying figure that calculates the average amount paid.The employee is unsure what aggregate functions to use for additional calculations. -Which aggregate function will find the customer with the largest amount paid?

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

To use a parameter query,press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.