Filtering by selection


show more Filtering by selection provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Filtering by selection

Filter by Selection is the fastest way to locate Records in your Table or Form that match your criteria. Open up to your Customers form and let's say I want to see how many restaurants and stores I have in California. Find an example of CA in the State field, highlight it and then go up to the Home ribbon to the Sort and Filter group, find the Selection button and drop it down. I have four options, Equals "CA", Does Not Equals "CA" Contains "CA" and Does Not Contain "CA". I'll click on Equals California (Equals "CA") and now I can see that I have two customers in California.

To bring all my records back I can see the Toggle Filter is highlighted so I'll click on it, and now all my records return. Let's highlight California again and go back to that Selection button and this time choose Does Not Equal "CA"-- now you can see all of your customers except those in California, and I'll click the Toggle Filter button...

Filtering by selection
Video duration: 1m 26s 3h 43m Intermediate

Viewers:

Filtering by selection provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...