Exam 3: Using Queries to Make Decisions

Where does the Total row of an aggregate function display its results?

Match the following formulas with their resultant value: I. =(4*6)+2^2-34 II. =4*(6+(2^2-34)) III. =4*(6+2^2)-34 IV. =4*(6+2^2)-34+(9^3) V. =4*(6+2^2)-(34+9^3) A. -723 B. 735 C. -6 D. 6 E. -96

If you want to see the results of several aggregate functions for one field, you would add the field in the Totals query several times.

When creating a calculated field in a query, what common error will not give you a direct indication that there is a problem?

If you type the name of a calculated field incorrectly you will get an invalid ________ error.

________ fields can use any aggregate function.

<> is an example of an argument.

________ your output will make your query results more readable.

What symbols does Access use to indicate a field name?

Using the Expression Builder can help you avoid ________ errors in field names.

Match the order of operation with its priority: I. Multiplication II. Parenthesis III. Exponentiation IV. Addition V. Division A. Second B. First C. Fourth D. Fifth E. Third

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.

Calculated fields must always contain at least one constant.

What sheet will allow you to change the formatting of a field in a query?

Access uses parenthesis () to identify a field name.

Which of the following is not an advantage of using the Expression Builder?

In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate second?

When you are prompted to enter a value when you run a query which includes a calculated field, you probably ________.

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

What is not a necessary piece of data needed for the Pmt function?