Exam 4: Query Calculations and Expressions

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

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

What symbol does Access use to express exponentiation?

Access will identify logical errors in calculated fields.

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

When you add ________ to a query you can summarize data by fields.

What symbols does Access use to indicate a field name?

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

<> is an example of an argument.

Access refers to ________ as aggregate functions.

Calculating values will help to avoid inconsistencies.

Which of the following is not an advantage of using the Expression Builder?

You can enter an expression in the Expression Builder by either typing the expression manually or by right-clicking the expression.

Functions generate results based on ________.

Access uses parenthesis ()to identify a field name.

What punctuation do you use to separate the arguments in a function?

You can add aggregate functions to calculated fields.