Exam 3: Access: Using Queries to Make Decisions

A(n)________ never changes its value.

What is not an example of a function?

Which of the following is not a common mistake when creating calculated fields?

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

You can add conditions to a Totals query.

A function is a predefined computation that is used for simple calculations.

Access will calculate exactly what you tell it to calculate, even if you make logical errors in the calculation.

What symbol does Access use to express exponentiation?

The Property Sheet is very similar to the ________ properties in a table.

Access will always give you step-by-step instructions to help you fix errors in formulas.

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

The Expression Creator tool helps you create complex expressions.

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

Match the following formatting options with their examples: I. Long Date II. Medium Date III. Short Date IV. Long Time V. Medium Time A. 12\26\1959 B. 26-Dec-59 C. Saturday, December 26, 1959 D. 3:03 E. 3:03:03 PM

It is permissible to use the percent (%)sign when entering the interest rate in the Pmt function.

What value will Access calculate from the following formula: =1+(2-3)+5\6-6^2?