Access 2000

Database Terms - Tables, Records, Fields

Table: A table is made up of several records. A table contains data that describes one thing or individual. In a table, data are arranged in columns and rows in an essentially rectangular shape. (A spreadsheet, for example, looks like a table.)

Example: There are several teachers listed in the Teacher Table. Each teacher is assigned a TeacherID, Name, and Room Number.

Record: A record is made up of several fields. A record includes all the data for a specific thing or individual.

Example: All the data for a particular teacher is a record.

Fields: A field is a space allocated for a particular piece of information, located at the intersection of a row and column.

Example: Mrs. Brown's name is Brown. Brown is contained in a field.

Click next to view a graphic representation of the Great Lake Elementary School Database.