Exam 4: Query Calculations and Expressions

Sometimes it is best to verify calculations by using a(n)________ on a few records.

A(n)________ query has an additional row which is used to display aggregate data.

In the PMT function,Future_value is considered an optional argument.

If you type the name of a calculated field incorrectly you will get an invalid ________ error.

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

If you are not using a totals query,then you must display the Totals row in a query if you want to use aggregate functions.

If you wanted to find the youngest person in your table,you would use the ________ function in a calculated field.

When creating a calculated field a(n)________ is entered after the field name.

In the formula,3*[BaseSalary],the 3 is considered a(n)________.

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

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

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

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

A calculated field displays the results of an expression in contrast to other data which is stored directly in a(n)________.

You can add conditions to a Totals query.

In the formula,=1+(2-3)+5/6-6^2,what will Access evaluate first?

What is not a necessary piece of data needed for the Pmt function?