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

Creating a Database

You build your database by entering the information into your worksheet. Enter the field names into the first row and then enter the information under the row of field names, which are your records. Now you have yourself a database.

Follow the steps in the following exercise to create a database from scratch. Use a new workbook for your database. Before you start the exercise, create a new workbook and name it My Database.

To Do: Create a Database

1.
The first step toward building a database is to enter the field names. In the My Database workbook on Sheet1, select cells B4:E4. This range is where you will enter the field names for your database.

Selecting the range for the field names allows you to use the Enter key to enter ...

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