Get to know the Access 2003 contact management database in this free lesson.
The Contact Management database used in this course can be downloaded from GCFLearnFree.org and installed on your computer.
GCFLearnFree.org's Access 2003 lessons all use examples from the Contact Management database. However, if you'd rather work with another existing database, you should have little problem following our lessons.
Now that you've downloaded the Contact Management database, let's open it and become familiar with it. We will briefly discuss how it was created and look at some of its database components.
If properly downloaded, the Contact Management database will be present in the c:\My Documents folder on your computer. It is recommended that you do not move the database from this location until after you have completed the Access 2003 course.
The main Contact Management database screen appears on your computer screen:
Tables are found in the database object called Tables. The Contact Management database contains four tables: Calls, Contact Types, Contacts, and Switchboard Items.
Forms are found in the database object called Forms. The Contact Management database has seven forms that are used as both menus and data entry screens. These forms are Call Details Subform, Call Listing Subform, Calls, Contact Types, Contacts, Report Date Range, and Switchboard. You can define additional forms to meet your data entry needs.
Reports are found in the database object called Reports. The Contact Management database has two reports defined to it: Alphabetical Contact Listing and Weekly Call Summary reports. You can define additional reports in the database depending on your reporting needs.