Exam 3: Access: Using Queries to Make Decisions

The Zoom window allows you to see the entire contents of a cell.

Match the following terms with their description: I. Total row II. Totals query III. Property Sheet IV. Expression Builder V. Aggregate function A. Calculation performed on a column and returns one value B. Way to display aggregate function results when a query is run C. Tool to create complicated expressions D. Where you can change the number of decimals E. Displays aggregate function results as the last row in a table or query

The ________ aggregate function returns the value with the highest value.

According to the order of operations, what is not calculated after exponentiation?

It is useful, at times, to add the same field to a query several times.

If you are not using a totals query, then you must display the Totals row in a query if you want to use aggregate functions.

Which of the following is not an arithmetic operator?

Access uses parenthesis ()to identify a field name.

Match the following aggregate functions with what they compute: I. Avg II. Sum III. Count IV. Min V. Max A. Counts the number of values in a column B. Average of a column C. Returns the lowest value D. Returns the highest value E. Totals the items in a column

What result would be generated by the formula =10*2-3*2?

________ fields can use any aggregate function.

A calculated field has a(n)________ after the field name.

A combination of elements that produce a value is known as a(n)________.

Which of the following is not an argument used in the Pmt function?