Datasheet

To demonstrate this functionality in action, open the CustomerMaster table
and right-click in the State column. The popup menu shown in Figure 1-9
activates. Type CA in the Filter For text field to filter only those customers based
in California.
Figure 1-9 The Filter For functionality
allows you to filter your data on-the-fly.
You can easily remove the filter and restore the table to its natural state by
clicking the following: Records → Remove Filter/Sort. Another useful filter
works in the opposite manner. The Filter Excluding Selection hides all records
that have the same value in the column that you clicked. Going back to our
example, if a user selects a record with California as its state, the Filter
Excluding Selection hides all records where the state is California. All records
with that data value have been temporarily hidden from view.
Getting Data into Access
Now that you have learned basic and advanced table concepts, you are ready
to bring data from outside sources into Access. Apart from creating a table
from scratch and manually entering the data, the two main methods for bring-
ing data into Access are importing and linking.
16 Chapter 1
05_59978X ch01.qxp 12/1/05 7:46 PM Page 16