Introduction to Databases

Learn about Access 2003 databases and understand how they work in this free lesson.

What is a relational database?

A database maintains order and structure in our lives. It is easy to maintain. It manages information and then shares it with other tables and databases.

Many entries in your address book will undoubtedly contain identical information—name, address, city, state, zip code, and phone number. This information might be written into a table called the Contacts table.

You may want to structure your address book so family members are separated from companies called during an employment search, for example. These categories—family, friend, relative, company—might appear in a second table called Contact Types.

Maybe you want write notes for certain calls. This is useful during an employment search. Information pertaining to a telephone call—date, time, and notes, for example—might be saved to a third table called Calls.

Database Components