Introduction to Databases

Learn about Access XP 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. These categories—family, friend, relative, company—might appear in a second table called Contact Types.

Perhaps 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