Here's a crib sheet of filtering commands to help you narrow down your data in Microsoft Access.
Filtering allows you to select out the data you want. For instance - perhaps you'd like to filter your customers to show just those in Essex who have spent more than £20,000 this year. Or you might filter out all employees in your HR database who have worked for the company more than 5 years.
In Access 2007, Microsoft have improved filtering and made it a breeze. You just right-click on the field you want to filter and then follow the menus.
But in earlier versions, there is just a white "Filter For" box and you need to know how to enter the right commands in order to get the data you want. That's where the attached PDF document comes in. You'll need Adobe Acrobat Reader to view it.
Use it as a reference or a learning tool - have a practice on one of your Access database forms so you really get to know your way around the filtering process - it's well worth it.
Attachments: