Lesson 5: Getting to Know the Contact Management Database

/en/accessxp/database-tables/content/

Introduction

By the end of this lesson, you should be able to:

  • Download a database from the Web
  • Open a database in Microsoft Access XP
  • Understand the tables, forms, and reports in the contact management database

Download the contact management database

The contact management database used in this tutorial can be downloaded from GCFLearnFree.org and installed on your computer.

GCFLearnFree.org's Access 2002 (XP) lessons all use examples from the contact management database. However, if you'd rather work with another existing database, you should still be able to follow along through the lessons.

To download the contact management database:

  • Download the database

    You must have an open connection to the Internet to download the database.
  • The following dialog box appears:

    File Download Dialog Box
  • Click the Save button.
  • You are prompted to save the database to your computer. Save the database in the c:\My Documents folder.

    The Save As Dialog Box
  • Click the Save button to download the database.

Open the contact management database

Now that you've downloaded the contact management database, it's time to open and become familiar with it. We will briefly discuss how it was created and look at some of its 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 tutorial.

To open the contact management database:

  • Open Microsoft Access by selecting its associated icon on the Windows desktop.
  • Choose FileOpen from the menu bar.

    File Menu
  • The Look In box in Microsoft Access XP defaults to the c:\My Documents when the application is first opened.

    If the My Documents folder does not appear in the Look In box, click in the Look In drop-down box and locate and select the My Documents folder.
  • Select the Contact Management.mdb file.

    Open Dialog Box
  • Click the Open button to open the contact management database.

The main contact management database screen appears on your computer screen.

Main Switchboard Form

Reviewing the contact management tables

Tables are found in the database object called tables. The contact management database contains four tables: calls, contact types, contacts, and switchboard items.

Access Database Window

Reviewing the contact management forms

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.

Forms Object and Switchboard Form

Reviewing the contact management reports

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.

Create Report in Design View

Challenge!

  • If you haven't already done so, download the Contact Management database. You must have an open connection to the Internet to download the database.
  • Open the contact management database and view each of the following:
  • Tables object
  • Queries object
  • Forms object
  • Reports object

    /en/accessxp/using-a-wizard-to-create-the-contact-management-database/content/