Microsoft Office Tutorials and References
In Depth Information
Using Filter By Selection
Remove Filter button
Filter By Selection button
Next, Matt wants to view only those records with a StateProv value of NH, because the
recruit is interested in positions in NH only.
3. Click in any StateProv field value of NH , and then click the Filter By Selection button
on the Query Datasheet toolbar. The filtered display now shows only the 2 records for clerk
positions available in New Hampshire.
Now you can redisplay all the query records by clicking the Remove Filter button; this but-
ton works as a toggle to switch between the filtered and nonfiltered displays.
4. Click the Remove Filter button
on the Query Datasheet toolbar. Access redisplays all
the records in the query datasheet.
5. Click the Save button
on the Query Datasheet toolbar, and then click the Close
on the menu bar to save and close the query and return to the
6. Click the Restore Window button
on the menu bar to return the Database window to
its original size.
The queries you’ve created will help NSJI employees retrieve just the information they
want to view. In the next session, you’ll continue to create queries to meet their informa-