Exam 4: Query Calculations and Expressions

A(n) ________ query has an additional row which is used to display aggregate data.

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

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

Access uses parenthesis () to identify a field name.

What punctuation do you use to separate the arguments in a function?

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

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 are predefined computations that perform complex calculations?

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

Which of the following is not a common aggregate function?

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

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

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

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

In the formula, 3*[BaseSalary], the 3 is considered a(n) ________.

The Total row, when using aggregate functions, displays both the total and the individual records.

Two good ways to test the results of a calculated field is to use a calculator or Excel.

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

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