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