Exam 3: Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

When using Expression Builder, you can ________ an item in the Expression Categories or Expression Values sections to automatically add it to the expression box.

When using a datasheet, explain what an aggregate function is and identify an aggregate function and explain what it does.

Which aggregate function would be used to find the highest value in a column?

The arguments to a function are enclosed in:

Sum, Count, and Avg are all examples of aggregate functions.

Function arguments are enclosed in ________.

Syntax can most accurately be defined as the:

If you misspell a field name in a calculated field of a query and then run the query, Access will:

A(n) ________ is a variable or constant that is needed to produce output for a function in a calculated field.

Which of the following can be used to zoom in and see an entire calculated field expressions?

Match each element of an expression with is definition: I. Identifiers II. Operators III. Functions IV. Constants V. Variables A. Produce results based on inputs B. Values that do not change C. Arithmetic instructions such as * , / , + , or - D. Elements with a changing value E. The names of fields, controls, or properties

Match the following terms to their meanings: I. Aggregate function II. Expression Builder III. Property sheet IV. Totals Query V. Syntax A. Performs calculations on a column of data and returns a single value B. Tool used to create complicated expressions C. Contains an additional row that displays aggregate data D. Specifies structure and components for a calculation E. Contains formatting information

The order of operations determines the sequence by which operations are calculated.

^ is the symbol for ________.

Which of the following is NOT a total row option?

To create a new query, click Query Design in the:

When designing an expression for a calculated field, field names are surrounded by:

The Pmt function returns the monthly payment due on a loan.

You must have a query open in Design view to launch the Expression Builder.

To change a field's caption or the number of decimal places, you would use its ________.