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

Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  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

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

All rights reserved.