GCFLearnFree.org

Wish I had found you before I spent $100 to take a class. Thanks!”

Online Learner

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

Access 2003

Single page view print copy

Database Tables

Datasheet basics

The core component of a database is a table. Data is defined and stored in a table. Multiple tables—each consisting of different types of data—can be created in a database.

Datasheet Basics

Each row in the database is called a record. The entry for John Smith is called a record. The entry for Martha Tompkins is also a record. Each row or record is made up of columns or fields—L.Name, F.Name, Phone, Address, City, State, and Zip—which contain a particular piece of information.

L.Name F.Name Phone Address City State Zip
Smith John 919.555.6320 100 Paramount Parkway Morrisville NC 27560
Tompkins Martha 919.555.6427 97 Hummingbird Court Cary NC 27513

In a Contact Management database, a list of names—those contacts to whom you have sent resumes or have met through your personal network—might be maintained in a table, along with addresses, phone numbers, and other personal information.

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

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