From the course: Access Essential Training (Office 365/Microsoft)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Filter table data

Filter table data

From the course: Access Essential Training (Office 365/Microsoft)

Start my 1-month free trial

Filter table data

“

- [Narrator] 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 the information that you need. I'm gonna open up the guest table once again, and then turn our attention to the sort and filter group, and the icons here on the right side of that group for filtering. First let's take a look at just the guests that come from the country of China. The easiest way to do that is to find one that matches that record, for instance, here on line number 11, and Harvey comes from China. I'll go ahead and click in the cell that says China, and then come up to the selection button. It's a drop down menu, and we have the options of equals China, does not equal China, contains China, or does not contain China. I wanna find all the guests from China, so I'll say equals China here. Now it filters out my table, and if I take a look at the very bottom, I can see I have a total of 19 records…

Contents