Exam 2: Access 2: Building and Using Queries

____ will find all records where there is any entry in the field, even if the entry is 0.

Critical Thinking Questions Case 2-1 Daniel Arno owns a lawn and landscape business with many customers. Occasionally, he wants to filter the data about his customers in various ways. Daniel uses a one-character code to indicate which day of the week certain customers of his have their lawns cut. Which of the following wildcard characters could he use to search for a single character (e.g., F for Friday)?

Query Design View presents the fields you can use for a query in small windows called field ____.

Compare the capabilities of queries and filters.

Filter By ____________________ is a fast and easy way to filter records for an exact match.

Use the ____ command to save the current object with a new name.

Criteria ____ is the term for rules by which criteria must be entered in a query.

Which of the following comparison operators means "less than or equal to"?

SQL stands for ____.

You can enter, edit, and navigate data in a query datasheet just like a(n) report datasheet. _________________________

In Query Design View, record selectors are thin gray bars above the field names in the query grid. ____________________

To move a field in the query design grid, click its ____, and then drag it left or right.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.