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 41

Multiple Choice

Review LaterAdd Note

Review Later

Critical Thinking Questions Case 2-1 Daniel Arno owns a lawn and landscape business with many customers. 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) Find
B) Like
C) Search
D) Near

E) None of the above
F) C) and D)

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

Critical Thinking Questions Case 2-1 Daniel Arno owns a lawn and landscape business with many customers. Occasionally, he wants to filter the data about his customers in various ways. Daniel lives in Oxford and he would like to find all customers who do not live in Oxford. Which comparison operator should he use?

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

E) B) and C)
F) A) and C)

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

A query can be used to create calculated fields.

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

Use the ____ command to save the current object with a new name.

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

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

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.