Chapter 33. Working with Records

As you’ll see in the next chapter, you can locate information and extract it from the database using queries, but you can also sort records in a table, filter records to show only those that match certain criteria, and find items in a database using simple toolbar buttons (Figure 33.1).

The Sort, Filter, and Find buttons.

Figure 33.1. The Sort, Filter, and Find buttons.

Figure 33.2 shows a database table. This table can be sorted by the entries in any column (Figure 33.3), and it can be filtered to show only entries that have certain entries in a field (Figure 33.4).

Figure 33.2. A table in the database.

Figure 33.3. The table sorted by Start Date.

Figure 33.4. The ...

Get Microsoft Office XP for Windows: Visual QuickStart Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.