From the course: Access 2019 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Filtering table data
- [Instructor] The filtering options on a table allow you to limit the number of records on screen to only those of interest. Just like with sorting, this allows you to quickly get to the information that you need. I'm gonna go ahead and open up the guest table once again and this time we're gonna take a look at the filtering options in the sort and filter group here on the home tab. For this example, I just wanna see the guests that live in China. The easiest way to do that is to find a record that matches what you want to filter by for instance I've got this customer right here, Anne Harvey, on line number 11, and she is from the country of China. Then I can come up to the filter icons, the ones with the little funnel icon, and go to selection and I have the option of either saying, equals China, does not equal China, contains China, or does not contain China. I'm gonna choose equals China, and then I'll filter all of the guests to just those from the country of China. If I take a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.