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…

Question

Options

• AFilter By Selection
• BFilter By Record
• CAdvanced Filter
• DFilter By Form

• A
  4% (2)
• B
  11% (5)
• C
  6% (3)
• D
  79% (37)

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 Answer: B is incorrect. There is no such feature as Filter by Record in Access 2010.

No community discussion yet for this question.