Exam 3: Access: Using Queries to Make Decisions

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

Access will identify logical errors in calculated fields.

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

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

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

As what does Access refer to aggregate functions?

The ________ aggregate function totals the items in a column.

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

What symbols does Access use to indicate a field name?

Functions generate results based on ________.

All aggregate functions can be used with any field type.

The rate argument in the Pmt function always uses the annual rate.

A calculated field displays the results of an expression in contrast to other data which is stored directly in a(n)________.

Calculating values will help to avoid inconsistencies.

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

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