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

When designing an expression for a calculated field,the name of the calculated field is followed by a(n):

A constant is a value that remains the same in an expression.

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

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

The Property Sheet enables you to change settings such as number format,number of decimal places,and other settings.

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

A Total row in a table can include functions such as Sum,Avg,and Count.

^ is the symbol for ________.

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

When designing a calculated field,complex formulas can be created with the:

PEMDAS is a mnemonic device used to remember the ________.

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

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

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

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

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.

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

The Calculated fields in Datasheet view can be edited in the same way other fields from a table are edited.