You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based
computer with Microsoft Office 2010 installed on it. The computer has a database named Customers
created in Microsoft Office Access 2010. You want to find all customer records where the contact
person’s title is Owner and the person is located either in Portland or in Eugene. Which of the
following filter features will you use to accomplish the task?

A.
Filter By Selection

B.
Filter By Record

C.
Advanced Filter

D.
Filter By Form

Explanation:
In order to accomplish the task, you should use the Filter By Form feature. The Filter by Form feature
is used to filter records based on the values in fields of a table, query, or form. It displays a filtering
datasheet with blank fields. Each blank field is a combo box that contains a list of all the entries
made in those fields. A user can select a value from this list or enter a new value. It is easy to use the
Filter by Form feature when a table contains only a few fields.
Answer A is incorrect. The Filter by Selection feature is used to filter records based on the current
selection in a field.
Answer C is incorrect. The Advanced Filter feature is used to create a simple query on a single table.
Answer B is incorrect. There is no such feature as Filter by Record in Access 2010.