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

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 3

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

Question 4

Function arguments are enclosed in ________.

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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 7

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

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 10

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 11

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 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

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

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

Match between columns
                        Premises: Minimum
Sum
Count
Maximum
Avg

Accepted Answer

The Answer of Returns the total value of a column is...

Question 17

Match between columns
                        Premises: Operators
Functions
Constants
Variables
Identifiers

Accepted Answer

The Answer of Produce results based on inputs and Values is...

Question 18

Match between columns
                        Premises: ^
-
*
+
/

Accepted Answer

The Answer of Addition and Exponentiation and Subtraction and Division is...

Question 19

Match between columns
                        Premises: Property sheet
Expression Builder
Totals Query
Syntax
Aggregate function

Accepted Answer

The Answer of Contains formatting information and Specifies structure and is...

Question 20

Match between columns
                        Premises: Expression
Argument
Total Row
Order of operations
Grouping

Accepted Answer

The Answer of Displays results of aggregate functions in last is...

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