A field is a category of information. The table shown above has separate fields for first name, last name, address, city, state, and zip code information.
Each record is a collection of fields, that is, one piece of data for each field. A record holds related data for one entity.
In the table shown, each record holds the contact information for one person.
Unlike a spreadsheet, the rows and columns in a database table cannot be reversed, columns are always fields,
which contain a category of data, and rows are always records, which contain a number of pieces of related data.
Breaking Data into Fields
It is important to break your data into small, but meaningful, pieces.
Learn what the other Access database objects--queries, forms, and reports are for.