Microsoft Access

Let’s talk for a minute about the hierarchy of data, and make sure we fully understand some very important database terms.

Field – is first as we move up the hierarchy. A field is a characteristic about an object, person, place or event. A field is a category of information. A field is represented in Access by a column.

Record – is second as we move up the hierarchy. A record is a collection of fields. A record is specific information about an object, person, place or event. A record is represented in Access by a row.

Table – is next as we move up the hierarchy. A table is a collection of records A table is represented in Access by a matrix. A table contains records (represented as rows) and fields (represented as columns).

Database – is next as we move up the hierarchy. A database is a collection of tables. In Access, each file is a database. An Access database file contains all the tables for that database. Access database files use the .accdb extension (stands for Access Database).