Opening a Table and Learning to Navigate Records

In Access XP opening tables can be done using the steps in this lesson. In Access XP navigating records can be done as well.

Using the status area to navigate the records in a table

Datasheet view looks like an Excel spreadsheet. It consists of columns and rows. Field names—Contact ID, First Name, Last Name, Dear, Address, City, State, etc.—appear as column headings. Records represent rows with data input into the fields. The number of rows that appear in the table will equal the number of records that have been added to the table. One blank row always appears as the last row of the database. This blank row is used to add a new record the table.

Contacts Table in Datasheet View

The status area in the bottom-left area of the window indicates the number of records in the table, as well as the record number displayed in the window.

Status Area

To navigate using the status area: