Filter a Table

Filter a Table

You can apply a filter to see only the records you want to see. For example, perhaps your database contains students from the states of DE, NJ, and PA and you only want to see the students from DE. You can filter your data so only DE students display.

Each time you apply a filter to a column, it replaces any previous filter you applied to that column. For example, if you apply a filter so you only see students in DE, and later you apply a filter so you only see students in NJ, Access clears the DE filter and then applies the NJ filter.

You can apply filters to multiple columns in the same table. For example, by applying a filter first to the State field and then to the Last Name field, you can see all of the students in the state of DE whose last names are Adams.

To apply a filter:

1.   Click the column label for the column you want to filter.

2.   Activate the Home tab.

3.   Click the Filter button. A menu appears.

4.   Uncheck the items you do not want to appear, making sure only the items you want are checked.

5.   Click OK. Access filters your data and displays the word Filtered at the bottom of the window.

To remove a filter:

1.   Activate the Home tab.

2.   Click Advanced in the Sort & Filter group. A menu appears.

3.   Click Clear All Filters. Access clears all the filters you have applied.

If You Enjoyed This, Take 5 Seconds To Share It

• Facebook
• Twitter
• Google+
• StumbleUpon
• Digg
• Delicious
• LinkedIn
• Reddit
• Technorati