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

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

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

In the figure above, item 3 points to ____.

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

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

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

This button sorts records in ascending order.

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

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

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

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

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

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?

A query can be used to create calculated fields.

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

____________________ means temporarily isolating a subset of records.

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

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

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