Exam 4: Access: Query Calculations and Expressions

Calculating values will help to avoid inconsistencies.

The ________ aggregate function totals the items in a column.

Access will identify logical errors in calculated fields.

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

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

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

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

Match the following mathematical terms with how they are displayed in Access: i. Parenthesis II. Exponentiation III. Division IV. Multiplication v. Subtraction

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

Which of the following is not an arithmetic operator?

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

All aggregate functions can be used with any field type.

Two good ways to test the results of a calculated field is to use a calculator or Excel.

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

Access uses parenthesis () to identify a field name.

A combination of elements that produce a value is known as a(n) ________.

When creating expressions, the ________ is useful to beginning users.

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

Another name for an input in a function is a(n) ________.

Match the order of operation with its priority: i. Multiplication II. Parenthesis III. Exponentiation IV. Addition v. Division