Exam 32: Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Formats available on the Property Sheet vary based on the data type.

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

Multiple arguments in a function are separated by:

PEMDAS is a mnemonic device used to remember the ________.

________ is used to summarize data by values of a field.

The default option in the total row is:

A(n)________ displays the results of the aggregate functions as the last row in the Datasheet view.

Expression builder can be launched by right-clicking the cell where you want the expression,and selecting Build from the shortcut menu.

Which of the following is NOT a Pmt function argument?

Which of the following is the correct mathematical sequence for the order of operations?

A(n)________ is the data used by a function to produce a result.

All of the following may be used in an expression EXCEPT:

The ________ aggregate functions return the item with the lowest value.

Unlike Excel,Access does not contain any built-in functions.

The future_value argument of the Pmt Function is the amount that is being borrowed.

A summary query is used to display only aggregate data when the query is run.

To display the total row,you click Totals in the:

Syntax can most accurately be defined as the:

Calculated fields are created in the Datasheet view of a table.

Explain what the order of operations is and why parentheses might be needed when evaluating an expression.Give a specific example of where parentheses would be need.