Exam 3: Using Queries to Make Decisions

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

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

Unless you add a minus sign, the Pmt function by default returns a(n) ________ value.

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

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

A totals query allows you to see only the results of aggregate functions, not the detail.

What can help you build more complex expressions in calculated fields?

All aggregate functions can be used with any field type.

Calculating values will help to avoid inconsistencies.

Access will identify logical errors in calculated fields.

Another name for an input in a function is a(n) ________.

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

You can add aggregate functions to calculated fields.

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

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

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

What symbol does Access use to express exponentiation?

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

Which element will you never find in a calculated field?

What button do you click to see the results of a query?