Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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 to turn it off again. I can also filter by partial fields. In the Company field I'll double-click on the word Deli and then go to the Selection button, now my choices are Contains "Deli", Does Not Contain "Deli", Ends With "Deli" and Does Not End With "Deli".
I'll choose Contains "Deli" and I can see that I have three stores that have the word Deli in the name. Filter by Selection is just one of a variety of ways to use Access's Filtered tools. Please see your Access 2010 Essential Training to see more of them in action.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91133 Viewers
80 Video lessons · 138168 Viewers
59 Video lessons · 56986 Viewers
52 Video lessons · 70622 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.