GCFLearnFree.org

This class was exactly what I needed for my job.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access 2003
  • Database Concepts

Access 2003

Single page view print copy

Database Concepts

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.

previous next
previous 1 2 3 4 5 6 7 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.