Exam 4: Query Calculations and Expressions

An expression is a formula used in a calculated field that contains only one element.

The ________ aggregate function returns the value with the highest value.

Access will calculate exactly what you tell it to calculate, even if you make logical errors in the calculation.

In the PMT function, what is not true about the Present_value argument?

It is permissible to use the percent (%) sign when entering the interest rate in the Pmt function.

A(n) ________ is a part of a formula that never changes its value.

Calculated fields must always contain at least one constant.

What allows you to summarize data by the values of a field?

What is not an example of a function?

You can add aggregate functions to calculated fields.

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

<> is an example of an argument.

According to the order of operations, what is not calculated after exponentiation?

What sheet will allow you to change the formatting of a field in a query?

For a 15-year loan paid monthly, which of the following would not be correct for the num_periods argument in the Pmt function?

In the PMT function, what is not true about the rate argument?

Which of the following is not an argument used in the Pmt function?

You can add conditions to a Totals query.

In the PMT function, what is not true about the Num_periods argument?

Match the following terms with their examples: I. Formula II. Function III. Argument IV. Expression V. Constant A. 58 B. =9*2 C. (rate, num_periods, present_value, future_value, type) D. <> E. =Sum