A field is an item of information which is stored for all records in a database.
Example for a car dealership:
- Information about cars for sale is stored in a table
- A table consists of rows and columns of information
- Each row is called a record and these hold information relating to one car.
- Car Registration
- Manufacturer
- Model
- Colour
- Purchase price
- Sale price
- The column in the table will contain different items of information. These are called fields. Examples:
- If you created a table to store this information using a spreadsheet package then you would instinctively add meaningful headings for each of the columns. These headings are basically the field names of your database.