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.

The following steps enable you 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.

  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.

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

    Figure 50.2. Field names.

    graphics/50fig02.gif



Sams Teach Yourself Office Productivity All in One
Sams Teach Yourself Office Productivity All in One (Sams Teach Yourself All in One)
ISBN: 0672325349
EAN: 2147483647
Year: 2003
Pages: 474
Authors: Greg Perry

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net