O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required