Exam 4: Query Calculations and Expressions

If the arguments in a formula are in the wrong order, you will get a syntax error.

What best describes the concept of syntax?

Functions generate results based on ________.

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

Access will identify logical errors in calculated fields.

Using the Expression Builder can help you avoid ________ errors in field names.

Access refers to ________ as aggregate functions.

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

The rate argument in the Pmt function always uses the annual rate.

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

The ________ aggregate function totals the items in a column.

If the formula, 3*[Bonus], the 3 is considered a(n) ________.

Match the following terms with their description: I. Total row II. Totals query III. Property Sheet IV. Expression Builder V. Aggregate function A. Calculation performed on a column and returns one value B. Way to display aggregate function results when a query is run C. Tool to create complicated expressions D. Where you can change the number of decimals E. Displays aggregate function results as the last row in a table or query

What symbol does Access use to express exponentiation?

When you want to add a condition to a Totals query, which option do you select from the Totals row list?

Calculating values will help to avoid inconsistencies.

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

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

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

The ________ sheet allows you to format a field.