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

Forgetting the colon between a column title and the formula would give you an invalid syntax error.

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

Which aggregate function would be used to find the least valued item in a column?

Following the order of operations,3+2*6 evaluates to 30.

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

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

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

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

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

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

It is a good habit to use spaces in calculated field names so that it will be easier to reference these fields in other queries.

Which of the following is NOT a total row option?

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

Explain what a totals query is and the steps necessary to create one.

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

When you use a table field in an expression,Access will automatically correct any spelling errors in the field name.

Explain how the Pmt function is used and identify two of its required arguments.

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

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