FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Access 2007 Unit B: Building and Using Queries

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

In the figure above, item 3 points to ____.

A) the title field
B) a field list
C) the Category field
D) a criteria entry

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

Correct Answer

verified

D

Question 2

True/False

Review LaterAdd Note

Review Later

This button sorts records in ascending order.

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

Queries evaluate multiple sort fields in a left-to-right order making the leftmost sort field the primary sort field.

____ are rules or limiting conditions you set to determine which records will appear when a filter is used.

A query can be used to create calculated fields.

By default, records in a table datasheet are sorted on the ____________________ key field.

Matt Miller owns a lawn and landscape business. He has some very particular clients who want their lawns manicured on a specific day of the week. He has other clients who allow him to use his own judgement as to when their lawns need cutting. To maximize his efficiency, he wants to build a query that will show his weekly customers by name, day of the week, subdivision and fee. Matt creates a table called Customers. For those customers whose day of the week varies upon need, he leaves the day of the week field blank. Matt creates a query using the Name, Day of the Week, and Subdivision fields. He wants to sort the records by day of the week, beginning with Monday and ending with Sunday. Because he knows both Ascending and Descending orders sort by number, then alphabetically, he knows the days of the week will be sorted alphabetically and not chronologically. He decides on a workaround that uses a unique number for each day of the week: 1=Monday, 2=Tuesday, etc. a. Will his idea work? b. Why or why not? c. Should he plan to sort in ascending or descending order?

Every query in the database has a(n) ____ View in which you change the structure of the query.

Is ____________________ criteria will find all records where no entry has been made in the field.

Match each term with the statement that best describes it.

____________________ means temporarily isolating a subset of records.

In the figure above, item 6 points to the ____.

This button filters records that equal, do not equal, or are otherwise compared to the current value.

This button provides filter features such as Filter by Form, Save As Query, and Clear Grid.

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

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

In the figure above, item 5 points to the ____.

____________________ refers to reorganizing the records in either ascending or descending order based on the contents of a field.

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

The upper portion of Query Design View shows a table's ____________________ list.