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

According to the order of operations, addition and subtraction are evaluated before multiplication and division if the addition and subtraction equations are contained within parentheses

The MAXIMUM aggregate function can work with Short Text data.

When viewing the results of a query, a series of ________ symbols indicates that a column is too narrow to display the complete results.

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

A(n) ________ is a predefined computation that performs complicated calculations.

When creating a calculated field using field names, Access automatically surrounds the field names with ________.

You can use the Expression Wizard to supply fields, operators, and functions to help you create expressions.

A(n) ________ function performs a calculation on an entire column and returns a single result.

Consider the following equation: 3 * (6 + 5) - 4 / 2. Which operation would be calculated FIRST according the order of operations?

Which of the following is NOT an aggregate function?

Following the rules for the order of operations, what is the result of the following expression: 1 + 2 * 5 ^ 2?

The SUM aggregate function can work with Date/Time data.

Which of the following is NOT a Pmt function argument?

In terms of creating a calculated field in a query, define the term expression and give two examples of expression elements.

A(n) ________ is a formula used to calculate new fields from the values in existing fields.

Which of the following is NOT an Expression Builder component used when constructing an expression?

It is NOT possible to change the caption for a calculated field column heading.