1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel 2007 Step by Step Database Tutorial

By Ted French, About.com

4 of 9

Rows are Records

Excel 2007 Database Tutorial

Excel 2007 Database Tutorial

© Ted French

Rows are Records

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

Each individual row of data, in a database is known as a record. When entering records keep these guidelines in mind:

  • Leave no blank rows in the table being created. This includes NOT leaving a blank row between the column 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. Excel 2007 Database Tutorial - How to Create an Excel Database - Step by Step Database Tutorial

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

All rights reserved.