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

^ is the symbol for ________.

When designing an expression for a calculated field,the name of the calculated field is followed by a(n):

It is NOT possible to add a condition to a Totals query.

A query with a Total row is the same as a totals query.

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

The Pmt function returns the monthly payment due on a loan.

A ________ query has an additional row displaying aggregate data.

To display the total row,you click Totals in the:

Function arguments are separated by ________.

A constant is a value that remains the same in an expression.

The SUM aggregate function can work with Date/Time data.

The sequence which operations are performed is determined by the order of operations.

Which of the following aggregate functions CANNOT be used with Data/Time data?

Which aggregate function would be used to find the least valued item in a column?

The present_value argument of the Pmt Function is the amount owed after the final payment has been made.

Consider the following equation: 3 * (6 + 5)- 4 / 2.Which operation would be calculated FIRST according the order of operations?

A ________ query is used to summarize data organized by field values.

Which of the following can be used to zoom in and see an entire calculated field expressions?

Aggregate functions are most commonly used in all of the following Access objects EXCEPT: