1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

How to Create a Database in Excel

By

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

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.

©2014 About.com. All rights reserved.