Exam 3: Access: Using Queries to Make Decisions

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

When creating a calculated field in a query, what common error will not give you a direct indication that there is a problem?

What button do you click to see the results of a query?

Calculated fields must always contain at least one constant.

What error will you get if there is something wrong with the formula in a calculated field?

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. <<Rate>> E. =Sum

You can add aggregate functions to calculated fields.

Which element will you never find in a calculated field?

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

What type of query will allow you to see statistics by category?

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

When you are prompted to enter a value when you run a query which includes a calculated field, you probably ________.

Unless you add a minus sign, the Pmt function by default returns a(n)________ value.

You can add multiple levels of grouping to a Totals query.