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


5 of 9

Columns are Fields
Field names in an Excel table

Field names in an Excel table

© Ted French

Columns are Fields

While rows in an Excel database are referred to as records, the columns are known as fields. Each column needs a heading to identify the data it contains. These headings are called field names.

  • Field names are used to ensure that the data for each record is entered in the same sequence.

  • Make sure that all the data in a column is entered using the same format. If you start entering numbers as digits (such as 10 or 20) keep it up. Don't change part way through and begin entering numbers as words (such as ten or twenty). Be consistent.

  • Do not leave blank columns in the table.

©2014 About.com. All rights reserved.