Learn about common Access 2000 database terms in this free lesson.
Table: A table is made up of several records. A table contains data that describes one thing or individual. In a table, data is 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 teacher ID, name, and room number.
Record: A record is made up of several fields. A record includes all of the data for a specific item or individual.
Example: All of the data for a particular teacher is a record.
Fields: A field, located at the intersection of a row and column, is a space allocated for a particular piece of information.
Example: Mrs. Brown's name is Brown. Brown is contained in a field.
Go to the next page to view a graphic representation of the Great Lake Elementary School database.