Exam 3: Access: Using Queries to Make Decisions

What punctuation do you use to separate the arguments in a function?

If you wanted to find out how many people are going on a trip you would use the ________ function in a calculated field.

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

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

<<Rate>> is an example of an argument.

When you add ________ to a query you can summarize data by fields.

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

Another name for an input in a function is a(n)________.

A(n)________ function performs a calculation on an entire column of data and returns a single value.

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

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

Match the areas of the Expression Builder dialog box with the content they display: I. Top II. Bottom Left III. Bottom Center IV. Bottom Right V. Expression Builder dialog box A. Expression Elements B. Expression Values C. What appears when you open the Expression Builder D. Expression Categories E. Expression box

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.

________ your output will make your query results more readable.

What are predefined computations that perform complex calculations?