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 - Microsoft Access Tutorial
From the course: Office 365: Access Essential Training
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…
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.