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

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

All of the following are true in reference to built-in functions EXCEPT:

When using the Pmt function,principal is another term for the ________ of a loan.

Calculated fields can only be displayed on a form.

Following the rules for the order of operations,what is the result of the following expression: (9 * 5)+ 5 + 10 - 10 * 6?

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

Explain what the Expression builder is,and how it is used.

The AVG function can only be used with the Number data type.

The arguments to a function are enclosed in:

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

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 you use a table field in an expression,Access will automatically correct any spelling errors in the field name.

When using Design view,you click Totals in the ________ group on the QUERY TOOLS DESIGN tab to display the total row.

When creating a calculated field,field names are enclosed in ________.

Expression Builder can be opened by clicking Builder in the:

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

Sum,Avg,and Max are examples of ________ functions that are used to evaluate entire columns of data.

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