In Access 2003 viewing table records is simple. In Access 2003 adding table records is easy as well. Just follow these instructions.
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 Contact table.
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—there are many fields in the record. Choose RecordsSave on the Standard toolbar to save data without moving the cursor out of the record's row.