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



Fields of Data in an Excel Database

Fields of Data in an Excel Database

© Ted French

Database Fields

In database terminology, a record holds all the information or data about one specific object that has been entered into the database.

Each individual element of information in the record - such as a telephone number or hair color - is referred to as a field.

In an Excel database, records are normally organized in rows with each cell in the row contains one item or element of information.

A field in an Excel database, therefore, is a cell containing information about a specific object.

To ensure that data is entered in the same order for each record, headings are added to the columns included in the record. These column headings are referred to as field names.

Form Fields

In a form, fields or controls are objects that are added to the form to display data - such as headings - or to make it easier for users to select options and to enter or edit data.

Commonly used form fields include list boxes, option or radio buttons, and check boxes.

©2014 About.com. All rights reserved.