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

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.