What is a...
...?
Definition:
In a database, a field holds exactly one type of information about an item or subject. It is like one line written on an index card in an index card file.
Explanation:
There are many fields on a record. In the example shown, there are 4 fields on each address record: the Name field, Address field, City field and Phone Number field.
Sentence:
"Enter 'Jane Doe' in the Name field."
In the sample database below, there are 4 fields in each record. Each field holds exactly one type of information.
In a more complex database, you will have more than 4 fields. For instance, instead of 1 Name field, you might break the name up into 2 separate fields: a Last Name field and a First Name field.Find out More!