1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel 2003 Step by Step Database Tutorial

By Ted French, About.com

4 of 9

Rows are Records

A data record in an Excel database

A data record in an Excel database

© Ted French

Rows are Records

Note: For help on these steps, refer to the image above.

As mentioned, rows of data, in a database are known as records. When entering records keep these guidelines in mind:

  • Leave no blank rows in the table being created, not even between the headings and the first row of data.

  • A record can contain data about only one specific item.

  • A record must also contain ALL the data in the database about that item. There can't be information about an item in more than one row.

Return to Index page

4 of 9

Explore Spreadsheets

More from About.com

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Data Management in Excel
  5. Create Excel Database- How to Create an Excel Database - Creating Data Records

©2008 About.com, a part of The New York Times Company.

All rights reserved.