Exam 4: Access: Query Calculations and Expressions

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.

What symbol does Access use to express exponentiation?

Which of the following is not a common aggregate function?

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

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

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

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

Functions generate results based on ________.

Fields with a ________ data type can use any aggregate function.

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

A(n) ________ function performs a calculation on an entire column of data and returns a single value.

You can add conditions to a Totals query.

The ________ sheet allows you to format a field.

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

If you wanted to find out how many people are going on a trip you would use the ________ function in a calculated field.

What allows you to summarize data by the values of a field?

The ________ aggregate function returns the value with the lowest value.

<> is an example of an argument.

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

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