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 the field names and move to the next cell, moving across the row. That way, you don't have to use the Tab key to move to the right each time you enter data in a cell. When you enter data in the last selected cell and press Enter, Excel makes the first selected cell active again.

  2. Type EmpID and press Enter.

  3. Type Lname and press Enter.

  4. Type Fname and press Enter.

  5. Type Dept and press Enter.

  6. Save the workbook.

  7. Click any cell to deselect the range. Your field names should look like the ones in Figure 21.2.

    Figure 21.2. Field names.


    Part I: Excel Basics