Exam 2: Building and Using Queries

____ are tests or limiting conditions you set to determine which records will be selected in a filter or query.

The wildcard character that stands for any single character is the ____.

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

Access saves ____ automatically as you move from record to record.

The top button in the accompanying figure ____.

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

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

Is ____________________ criteria will find all records where no entry has been made in the field.

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

A query can be used to create calculated fields.

To add a table's field list to the upper pane of Query Design View, click the ____________________ Table button on the Design tab.

SQL is the acronym for " Simple Query Language ."

Critical Thinking Questions Case 2-1 Daniel Arno owns a lawn and landscape business with many clients. 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)?

Enter OR criteria on different Criteria rows in the query design grid.

Filters are used to select a subset of records in a datasheet.

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

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

Compare the capabilities of queries and filters.

To make a page wider than it is tall, use landscape orientation.

Deleting a field from a query also deletes it from the underlying table.