Database Concepts

Learn about Access 2003 database concepts in this free lesson.

What is a table?

Data is stored in one or more tables. Separate tables are usually created for specific topics, such as products or suppliers. Tables can be related to one another to access different types of information. Because data is stored only once—you probably would not save the same information in two different tables—your database becomes more efficient.

The columns and rows in an Access table resemble an Excel spreadsheet. Tables organize data into columns (called fields) and rows (called records). A record is comprised of one or more fields, depending on the number of fields defined to the table.

Table Grid

Individual fields in an address book table might consist of name, street address, city, state, zip code, and phone number. A single record is an entry that uses all of these fields, such as your brother's or sister's contact information.