Access 2019 For Dummies by Laurie A. Ulrich & Ken Cook

Author:Laurie A. Ulrich & Ken Cook
Language: eng
Format: epub
ISBN: 9781119513285
Publisher: Wiley
Published: 2018-10-09T00:00:00+00:00

Filter by Form

You can tighten a search by using additional filters to weed out undesirable matches, but that takes a ton of extra effort. For an easier way to isolate a group of records according to the values in more than one field, try Filter by Form.

Filter by Form uses more than one criterion to sift through records. In some ways, it’s like a simple query. (What’s a query? See Chapter 13.) It’s so similar to a query that you can even save your Filter by Form criteria as a full-fledged query!

Suppose, for example, that you need a list of all the employees at your company who work in a certain department and have a particular title. You can perform two Selection filters (on the Department and Job Title fields, using the employee database as an example) and write down the results of each to get your list; or you can do just one search with Filter by Form and see all the records that meet your criteria (based on their entries in multiple tables) in a single step.

To use Filter by Form, follow these steps:

On the Ribbon’s Home tab, click the Advanced button in the Sort & Filter section.

A menu appears.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.