From the course: Office 365: Access Essential Training

Unlock the full course today

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

Filtering table data

Filtering table data - Microsoft Access Tutorial

From the course: Office 365: Access Essential Training

Start my 1-month free trial

Filtering table data

- 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. Let's work with the Guests table again. I'll double-click on it here in the navigation pane, and, once again, we're going to return our attention to the Home tab and the Sort & Filter section right over here. Now let's say that I wanted to find all of the guests that live in the country of China. In order to do that, one of the easiest ways is to find one of these people. In this case, this person here, Anne Harvey. We'll go ahead and click on this field that says China, and we can come up here to the ribbon. We have a Filter by Selection option here, 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". Let's go ahead and say Equals "China", and that will Filter out my data table to just the people who…

Contents