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

Compare the capabilities of queries and filters.

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 wants to build a query that will show each customer name, day of the week (if specific), and subdivision. What criterion should he use to quickly find his customers whose day of the week varies?

A(n) ____ is a temporary view of the data whose criteria are discarded when you close the datasheet.

This button searches for data in a single field or in all fields.

The wildcard character that stands for any single character is the ____.

Filter By ____________________ filters records based on more than one selection criteria by using a special window.

Once you have filtered a datasheet to display a subset of records, you cannot sort the records.

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

In Query Design View, the query design ____________________ shows you the fields that you have requested for the query.

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

The records of a datasheet are always automatically sorted in ascending order on the first field.

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

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

The Find and Replace dialog box allows you to specify whether Access looks for search criteria in a single field or in the entire datasheet.

Define sorting, filtering, and finding.

A query allows the selection of several fields and records from one or more tables, then presents the selected data as a single datasheet.

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

A(n) ____ is a temporary view of the data whose criteria is discarded when you close the datasheet.

Filter By ____________________ filters records based on selected data and hides records that do not match.

To find all records where there is any entry in the field, even if the entry is 0, use which criteria?