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

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) >
B) >=
C) <
D) <=

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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

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

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

The bottom button in the accompanying figure ____.

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

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

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

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.

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

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.

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

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

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

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

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?