Ten Minute Guide to Excel 97

Creating a Database

To create a database, you don't have to use any special commands. All you do is enter data into the cells as you would enter data on any worksheet. However, as you enter data, you must follow these guidelines:

• Enter field names in the top row of the database. Enter the first record just below this field name's row.

• Type field entries into each cell in a single row to create a record. (You can leave a field blank, but you may run into problems later when you sort the database—that is, if you sort the database by that particular field.)

• Do not leave an empty row between the field names and the records or between any records.

• If you want to enter street numbers with the street names at the beginning of the field (such as 155 State ...