FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Building and Using Queries

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

Match each term with the statement that best describes it. -Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

A) Is Null
B) wildcard
C) sorting
D) query
E) datasheet
F) filter
G) criteria
H) query grid

I) E) and G)
J) A) and E)

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

Match each term with the statement that best describes it. -The lower pane in Query Design View

A) Is Null
B) wildcard
C) sorting
D) query
E) datasheet
F) filter
G) criteria
H) query grid

I) A) and B)
J) None of the above

Correct Answer

verified

Show Answer

Question 23

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.

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

Match each term with the statement that best describes it. -Creates a temporary subset of records

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

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

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. ____________________

Match each term with the statement that best describes it. -Putting records in ascending or descending order based on a field's values

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

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

Enter OR criteria on different Criteria rows in the query design grid.

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

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.

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

____________________ a table or query datasheet temporarily displays only those records that match given criteria.

Which of the following comparison operators means "less than or equal to"?

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

A query datasheet is sometimes called a ____ of the data.