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 1

True/False

Review LaterAdd Note

Review Later

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

Correct Answer

verified

False

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

When you double-click a field in a field list in Query Design View, it is ____.

A) deleted from the query
B) added to the next available position in the query design grid
C) used as the first sort order
D) set as the primary key field

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

To delete records from a query datasheet, click the record selector button to the left of the record, click the HOME tab, click the Delete button in the Records group, and click Yes.

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

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

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

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

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

The wildcard character that stands for any group of characters is the ____.

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

Compare the capabilities of queries and filters.

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) ?

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

Explain the difference between AND and OR criteria.

____________________ are limiting conditions you set in the query design grid.

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

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

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

One way to create a new query is with the ____________________, which prompts you for the information it needs to create a new query.

The question mark (?) is the wildcard character which stands for any single character in criteria.