Entering and Adding Data

After you create your database, you can enter your records and add more records to it any time. You append these records at the end of the current database. To make adding these records easier, you can do one of the following:

  • Use a data form

  • Enter the data directly in the cells on the worksheet

Working with a Data Form

The data form is a dialog box that you use to review, add, edit, and delete records in a database. This dialog box shows one record at a time, starting with the first record. Each field name has a text box that you use to enter a new word or value.

The data form also has several buttons on it that you can use to move through the database, add or delete a record, or find a particular set of records.

Here's ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.