Exam 3: Access: Using Queries to Make Decisions

Having the user input the values directly is the best way to ensure that errors will not be included in the data.

The ________ sheet allows you to format a field.

Two good ways to test the results of a calculated field is to use a calculator or Excel.

What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?

Which of the following is not a common aggregate function?

If you wanted to find the youngest person in your table you would use the ________ function in a calculated field.

When you want to add a condition to a Totals query, which option do you select from the Totals row list?

Some functions have optional arguments.

A totals query allows you to see only the results of aggregate functions, not the detail.

Match the following mathematical terms with how they are displayed in Access: I. Parenthesis II. Exponentiation III. Division IV. Multiplication V. Subtraction A. \ B. - C. ^ D. * E. ()

When you run a query, what is the default view?

Match the following terms with their description: I. Argument II. Expression III. Grouping IV. Function V. Constant A. Combination of elements that produce a value B. Value that does not change C. Input used in a function D. Predefined computation E. Method of summarizing data

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