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

Which of the following aggregate functions CANNOT be used with Short Text data?

Function arguments are enclosed in ________.

It is NOT possible to change the caption for a calculated field column heading.

Following the order of operations,3+2*6 evaluates to 30.

You must have a query open in Design view to launch the Expression Builder.

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

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

Forgetting the colon between a column title and the formula would give you an invalid syntax error.

Sum,Count,and Avg are all examples of aggregate functions.

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

Which of the following is NOT a total row option?

Expression Builder inserts ________ that tell you where each argument belongs.

The order of operations determines the sequence by which operations are calculated.

An expression or integer value specifying total number of payments in a loan is the ________ argument in the PMT function.

Aggregate functions perform calculations on an entire row of data and return a single value.

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

When viewing the results of a query,a series of ________ symbols indicates that a column is too narrow to display the complete results.

The MAXIMUM aggregate function can work with Short Text data.