Exam 3: Using Queries to Make Decisions

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

Which of the following is not a common aggregate function?

According to the order of operations, what is not calculated after exponentiation?

Some functions have optional arguments.

Match the following aggregate functions with what they compute: I. Avg II. Sum III. Count IV. Min V. Max A. Counts the number of values in a column B. Average of a column C. Returns the lowest value D. Returns the highest value E. Totals the items in a column

Functions generate results based on ________.

Which of the following is not an argument used in the Pmt function?

What result would be generated by the formula =10*2-3*2?

You can add conditions to a Totals query.

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

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

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

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

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

When you run a query, what is the default view?

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

A calculated field has a(n) ________ after the field name.

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

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

Match the areas of the Expression Builder dialog box with the content they display: I. Top II. Bottom Left III. Bottom Center IV. Bottom Right V. Expression Builder dialog box A. Expression Elements B. Expression Values C. What appears when you open the Expression Builder D. Expression Categories E. Expression box