Exam 3: Performing Calculations With Formulas and Functions

Which of the following are ways to run a query? Select all the options that apply.

The easiest way to filter the records for an exact match is to use the _____ feature.

What does the criterion <=200 mean?

To add, delete, or change fields in a query, you use Query Design view.

Hiding a column in Table Datasheet view is that same as freezing the column.

Sorting a table datasheet temporarily displays only those records that match given criteria.

Which of the following statistics can you calculate in the Total row for a Currency field in Table Datasheet view? Select all the options thatapply.

You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.

In Query Design view, the _____ shows you the field names, sort orders, and criteria used with a query.

Which of the following criteria uses the correct syntax for a Date/Time field in a query?

What button do you use on the Query Tools Design tab to add a field list to a query?

What happens when you run a query from Query Design view?

In Table Datasheet view, a(n) _____ shows the records on the "many" side of a one-to-many relationship.

Which of the following are changes you make when formatting a datasheet? Select all the options that apply.

Use a Number field to store values that represent money.

One way to format a form is to set the alternate record color of the form in Form Layout view.

Use >500 as the criterion for a Number field in a query to select records with a value less than 500 in that field.

To delete a field from a query, drag the field out of its field list.

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

To add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.