How to Filter Records in a Microsoft Access Table

Video Transcript

"Hi, my name is Chip Browne. I teach computer programing in Microsoft Office applications at Steven Henagar college. Here in Utah. I also create practice tests for Microsoft Office Applications Specialists Certification tests. Today we're going to learn how to filter records in a Microsoft Access Table. Microsoft Access is a Registered Trademark of Microsoft Corporation. I'm not affiliated with Microsoft Corporation. To learn how to filter records in a Microsoft Access Table, you need to be familiar with the filter mechanism in, on the Home tab. On the Home tab, in here in the Sort and Filter group. Here is the Filter command. In order to activate it, we need to open up a table. Let's open up customers. Now you can see what the table opened. The Filter command is now available to us. In order to Filter, you need to click on the field that you want to Filter your data by. Let's click on Job Title. With the job Title field selected, we can now click on the Filter icon. Or we can click on this down arrow. In order to bring up the Filter menu. I'll click on the Filter icon. This is the Filter menu. It represents all the data, the NIC data that is in this field. By default, all values are being represented. To uncheck the Select All. We would then Filter out every value. But if we want to have one or more values. We simply click on that particular value. And then click o.k. As you can see, Microsoft Access automatically filtered all the other records out. Leaving the one that we checked. Now those records are still present. But they simply are not in our view. If you'd like, you can actually modify this. By clicking on that same down arrow. To bring up the Filter option. And we can add another. And click o.k. And it will give us that additional value in our Filter. With that Filter present, we can use the Toggle Filter to turn on or to turn off, the Filter. Turning it on, and it returns. Turning it off, it goes back to All Values. This is how to filter records in a Microsoft Access Table. The Filter can be saved by clicking on the Save button here in the Click Access Tool Bar. And it will be saved with your table, the next time you open it up. For more information and videos, visit me Chip Browne at ChipBrowne.com. That's Browne with an E."