FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Building and Using Queries

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Like
B) Is Null
C) And
D) Is Not Null

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

To filter for comparative data, use the Filter By Selection feature.

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

To move fields in the query grid, drag the field ____________________.

The bottom button in the accompanying figure ____.

The ____ button provides a list of values in the selected field that can be used to customize a filter.

In Query Design View, the query design ____________________ shows you the field names, sort orders, and criteria used with a query.

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet.

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

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

A(n) ____ is a saved object within the datasheet.

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

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

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

Which of the following comparison operators means "not equal to"?

You enter and edit data in a query datasheet in the same way you do in a table 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 asterisk (*) is the wildcard used to represent one and only one character in criteria.

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?

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

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