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 ->Toggle Filter

Using the Filters

Try It: Apply the Filters

Go to Home-> Sort and Filter.

Select Toggle Filter.


 

What Do You See? There should be a bright orange icon on the navigation bar indicating that the records are filtered.

 

There are two criteria in this filter:

The movie was released after 2000

[Year] >2000....

 

AND the movie must be rated "G."

 
 

 

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

  5.2. Filter data   5.2.4. Filter data within forms