Opening a Table and Learning to Navigate Records

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

The Record Selector

The Record Selector, located to the left of each record in Datasheet view, identifies the operation being performed against a selected record at any given time.

Record Selector

The Record Selector can display any of the following symbols:

  • Current Record Indicates the current record; the record is saved with the information displayed on the screen
  • Selected Record Indicates the selected record is being edited and the changes have not yet been saved
  • Blank Record Indicates a blank record into which information for a new record can be added to the table

A blank record row always appears as the last row in a table. You must add new table records using this row.