Question 1

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 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

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 5

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

Question 6

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

Question 7

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

Accepted Answer

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

Question 8

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

Question 9

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

Accepted Answer

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

Question 10

Function arguments are separated by ________.

Accepted Answer

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

Question 11

Function arguments are enclosed in ________.

Accepted Answer

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

Question 12

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

Accepted Answer

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

Question 13

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 14

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 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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 18

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 ________ an...

Question 19

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

Question 20

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

Quiz 15: Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions