Access Lesson 3 Creating Queries. Microsoft Office 2010 Introductory. Pasewark & Pasewark. Objectives. Create a query using a Wizard. Sort and filter data in a datasheet. Create a query in Design view. Create relationships in a database. Create a query based on more than one table .
Access Lesson 3Creating Queries
Microsoft Office 2010 Introductory
Pasewark & Pasewark
Filter By Form
Filter By Selection
Simple Query Wizard
A filter temporarily displays records in a datasheet based on the condition that you specify.
You can use different types of filters to display the data you need. When you use Filter By Selection, you select a field value, and then click the Selection button in the Sort & Filter group on the Home tab.
You can use Filter By Form to display records that contain one or more values based on the values stored in one or more fields. Click the Advanced button in the Sort & Filter group on the Home tab.
Click the Toggle Filter button in the Sort & Filter group on the Home tab to display only records in the datasheet that match the filter.
An easy way to sort and filter data is to use an AutoFilter.
An AutoFilter is a menu that opens when you click the arrow on the right side of a field selector, and contains options for:
Sorting data and clearing filters.
Using Filter By Selection and Filter By Form.
In this lesson, you learned: