Search Table

The new search feature in Access 2007 allows you to enter a search term into a small text box at the bottom of the screen. As you type each letter, the first segment of data matching your search term is highlighted in the table. If there are a number of records containing your search term, you can click the filter button adjacent to the search box to produce a filtered list matching your search criteria.

Sorted Access List

Access search result - highlighted segment of data matching text entered into the Access Search Box.

Next we shall take a look at Calculating Data in Tables.