Access: Research Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Home-> Sort and Filter ->Advanced

Filter by Form

You can use the form fields to filter the data. It is an effective, visual method for analyzing the data.

 

Try It: Filter By Form

Open one of the Movie forms in Form view. Go to Home-> Sort and Filter.

Select Advanced.

 

Try This, Too: Remove the Filter

If you can add a Filter, you can also remove a Filter.

Go to Home-> Sort and Filter.

Select Clear All Filers.

 
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 5.  Presenting and Sharing Data 

  5.2. Filter data   5.2.4. Filter data within forms