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

Multiple Choice

Review LaterAdd Note

Review Later

To move a field in the query design grid, click its ____, and then drag it left or right.

A) field selector
B) field key
C) field string
D) field tag

E) B) and C)
F) C) and D)

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

SQL is the acronym for " Simple Query Language ." _________________________

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

Essay

Review LaterAdd Note

Discuss adding or deleting a table in a query.

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

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

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

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

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

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?

In Access, the Save As command allows you to save either the entire database or the current object with a new name.

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

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

If, for example, a find-and-replace effort does not work correctly, click the Undo button to cancel the changes. _________________________

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

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?

Quotation marks are automatically added to criteria for fields with a Date/Time data type. ____________________

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

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

Query criteria are not case sensitive.

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.