Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

Case Example

The following case example reviews some of the tools and techniques you learned about in this chapter.

1.	Open the frmCustomers form.
2.	In the State field, select any instance of CA, right-click, and choose Filter by Selection.
3.	Select any instance of Sacramento, right-click, and choose Filter by Selection.
4.	In the ZIP Code field, select 94205, right-click, and choose Filter Excluding Selection.
5.	Choose Records, Filter, Advanced Filter/Sort (see Figure 7.15) to see the criteria you've designated. Figure 7.15. The design grid shows that the filter has three conditions, all of which must be true at the same time.
6.	Choose Filter, ...