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

Exponents are evaluated first according to the order of operations.

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

Which of the following is the correct mathematical sequence for the order of operations?

A ________ query has an additional row displaying aggregate data.

* is the symbol for ________.

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

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

A Total row displays the results of aggregate functions as the last row in the Datasheet view.

According to the order of operations,multiplication and addition are evaluated before Division and subtraction.

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

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

Calculated fields can only be displayed on a form.

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

A(n)________ is the data used by a function to produce a result.

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

When using the Pmt function,principal is another term for the ________ of a loan.

Function arguments are separated by ________.

A(n)________ is used to change settings such as formatting and captions.

The AVG function can only be used with the Number data type.