Exam 4: Access: Query Calculations and Expressions

When you want to add a condition to a Totals query, which option do you select from the Totals row list?

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

In the PMT function, what is not true about the Present_value argument?

Match the following formatting options with their examples: i. Long Date II. Medium Date III. Short Date IV. Long Time v. Medium Time

Match the following terms with their examples: i. Formula II. Function III. Argument IV. Expression v. Constant

Access refers to ________ as aggregate functions.

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

You can add aggregate functions to 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(n) ________ query has an additional row which is used to display aggregate data.

What is a type of field that displays the result of an expression rather than the data stored in a field?

What symbols does Access use to indicate a field name?

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

What best describes the concept of syntax?

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.

What are predefined computations that perform complex calculations?

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

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

Match the following aggregate functions with what they compute: i. Avg II. Sum III. Count IV. Min v. Max

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