Exam 3: Building and Using Queries

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?

A filter can be used to create calculated fields.

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

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

Compare the capabilities of queries and filters.

SQL stands for ____.

Discuss adding or deleting a table in a query.

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.

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

Match each term with the statement that best describes it. -Criterion that finds all records where no entry has been made in the field

A(n) ____________________ answers a question about the information in the database.

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

To find all records where there is any entry in the field, even if the entry is 0, which criteria should you use?

-The accompanying figure shows the query in ____ View.

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

Which of the following comparison operators means "greater than"?

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

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.

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