Question 1

To create complicated expressions, you would use the ________ tool.

Accepted Answer

The answer of To create complicated expressions, you would use...

Question 2

A(n) ________ displays the results of the aggregate functions as the last row in the Datasheet view.

Accepted Answer

The answer of A(n) ________ displays the results of the...

Question 3

When using a datasheet, explain what an aggregate function is and identify an aggregate function and explain what it does.

Accepted Answer

The answer of When using a datasheet, explain what an...

Question 4

Explain how the Pmt function is used and identify two of its required arguments.

Accepted Answer

The answer of Explain how the Pmt function is used...

Question 5

Function arguments are separated by ________.

Accepted Answer

The answer of Function arguments are separated by ________....

Question 6

Explain what the order of operations is and why parentheses might be needed when evaluating an expression. Give a specific example of where parentheses would be need.

Accepted Answer

The answer of Explain what the order of operations is...

Question 7

When using Design view, you click Totals in the ________ group on the QUERY TOOLS DESIGN tab to display the total row.

Accepted Answer

The answer of When using Design view, you click Totals...

Question 8

________ is used to summarize data by values of a field.

Accepted Answer

The answer of ________ is used to summarize data by...

Question 9

When creating a calculated field, field names are enclosed in ________.

Accepted Answer

The answer of When creating a calculated field, field names...

Question 10

In terms of creating a calculated field in a query, define the term expression and give two examples of expression elements.

Accepted Answer

The answer of In terms of creating a calculated field...

Question 11

Explain what a totals query is and the steps necessary to create one.

Accepted Answer

The answer of Explain what a totals query is and...

Question 12

Function arguments are enclosed in ________.

Accepted Answer

The answer of Function arguments are enclosed in ________....

Question 13

The ________ aggregate functions return the item with the lowest value.

Accepted Answer

The answer of The ________ aggregate functions return the item...

Question 14

A(n) ________ is a predefined computation that performs complicated calculations.

Accepted Answer

The answer of A(n) ________ is a predefined computation that...

Question 15

When using Expression Builder, you can ________ an item in the Expression Categories or Expression Values sections to automatically add it to the expression box.

Accepted Answer

The answer of When using Expression Builder, you can ________...

Question 16

To change a field's caption or the number of decimal places, you would use its ________.

Accepted Answer

The answer of To change a field's caption or the...

Question 17

A(n) ________ contains an additional row in the query design grid and displays aggregate data when the query is run.

Accepted Answer

The answer of A(n) ________ contains an additional row in...

Question 18

A(n) ________ function performs a calculation on an entire column of data and returns a single value.

Accepted Answer

The answer of A(n) ________ function performs a calculation on...

Question 19

Explain what the Expression builder is, and how it is used.

Accepted Answer

The answer of Explain what the Expression builder is, and...

Question 20

Sum, Avg, and Count are examples of ________ functions.

Accepted Answer

The answer of Sum, Avg, and Count are examples of...

Quiz 3: Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions