Exam 4: Query Calculations and Expressions

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

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

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

Which of the following is not an arithmetic operator?

When you are prompted to enter a value when you run a query which includes a calculated field, you probably ________.

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

If you want to see the results of several aggregate functions for one field, you would add the field in the Totals query several times.

The Expression Builder tool helps you create complex expressions.

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

Some functions have optional arguments.

When creating a calculated field a(n) ________ is entered after the field name.

What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?

Match the order of operation with its priority: I. Multiplication II. Parenthesis III. Exponentiation IV. Addition V. Division A. Second B. First C. Fourth D. Fifth E. Third

If you wanted to find the youngest person in your table, you would use the ________ function in a calculated field.

If you are not using a totals query, then you must display the Totals row in a query if you want to use aggregate functions.

Where does the Total row of an aggregate function display its results?

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

What symbols does Access use to indicate a field name?

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 A. / B. - C. ^ D. * E. ()