Viewing and Adding Table Records

In Access XP viewing table records is simple. In Access XP adding table records is easy as well. Just follow these instructions.

Entering and adding table records in Datasheet view

Each record in a table is represented by a row. Field names are represented as columns in the table. To add a new record, navigate to the last row in the table—it's a blank row—or click the new record button in the status area. Then input the requested information into each field in the new record. In this lesson, you will add a new record to the Contacts table.

To enter or add a table record in Datasheet view:

Saving your work: Information in a table is saved automatically when the mouse, an arrow key, the Tab key, or the Enter key is used to move the cursor out of that row and into a different record.

You can manually save data being entered for a record as you work your way across the different fields in the record. Choose RecordsSave on the Standard toolbar to save data without moving the cursor out of the record's row.