Exam 2: Building and Using Queries

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

A query allows the selection of a subset of fields and records from one or more tables, then presents the selected data as a single datasheet.

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

The record selector button is to the right of a record in a datasheet. ____________________

To find numbers greater than or equal to 500, use which comparison operator?

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

The top button in the accompanying figure ____.

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

To search for a pattern, you can use a(n) ____________________ character, a symbol you can use as substitute for characters to find information that matches your find criteria.

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

In the accompanying figure, "StateName" and "StateAbbreviation" appear in the States ____ list.

Discuss adding or deleting a table in a query.

SQL is the acronym for " Simple Query Language ." _________________________

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

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

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 wants to make even more use of wildcard characters. Which operator is he most apt to use in these searches?

The accompanying figure shows the query in ____ View.

By default, the printout of a datasheet contains the object name and current date in the footer . ____________________

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

SQL stands for ____.