Lesson 6: Using a Wizard to Create the Contact Management Database

/en/accessxp/getting-to-know-the-contact-management-database/content/

Introduction

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

  • Launch the database wizard
  • Create a database using the database wizard tool

Launching the database wizard

The contact management database was created using the Access database wizard. We will briefly review the steps involved in creating this database.

Microsoft Access XP is equipped with a database wizard that can be used to create any of 10 simple databases: asset tracking, contact management, event management, expenses, inventory control, ledger, order entry, resource scheduling, service call management, and time and billing.

In this lesson, we will briefly review the steps involved in creating the contact management database.

How the contact management database was created using the database wizard:

  • Choose FileNew from the menu bar.
  • Click the Databases tab near the top of the New window.

    New Database Templates
  • If the templates window does not appear, you may need to select On my computer from the task pane on the right side of your screen.

    Access XP task pane
  • Click to select on the contact management icon.
  • Click OK to launch the wizard.

    File New Database Dialog Box
  • Specify the location where the database will be saved.

Verifying the intent of the contact management database

The first screen of the wizard verifies the type of information that will be stored in the contact management database: contact information and call information.

Database Wizard - Screen 1

  • Click Next to continue.

Selecting tables and felds to be included in the database

The second screen of the wizard identifies the tables to be created. Three tables were created: Contact information, Call information, and Contact Types.

Click any table to display the fields contained to it in the Fields in the table column. Click a different table, and other fields used by that table will replace the ones displayed for the table selected.

Database Wizard - Screen 2

  • Accept all other default field selections by leaving these check boxes marked.
  • Click Next to continue.

Defining the format of the screen display

The third screen asks the question, What style would you like for screen displays? Access provides 10 screen displays for your use. A thumbnail picture is also provided for each format listed.

Database Wizard - Screen 3

  • Click through the different format options displayed on the screen—Blends, Blueprint, Expedition, etc.—to display a picture of each format on the left side of the wizard screen. Highlight the desired format—the contact management database uses the Standard format—to be used.
  • Click Next to continue.

Defining the format of the report display

The third screen asks the question, What style would you like for printed reports? Access provides six report displays for your use. A thumbnail picture is also provided for each format listed.

Database Wizard - Screen 4

  • Click through the different format options displayed on the screen—Bold, Casual, Compact, etc.—to display a picture of each format on the left side of the wizard screen. Highlight the desired format—the contact management database uses the Corporate format—to be used.
  • Click Next to continue.

Naming the database

The next step is to assign a name to the database.

Database Wizard - Screen 5

  • Assign a name to the database by typing a file name in the What would you like the title of the database to be? field.
  • Click Next to continue.

Finishing the wizard

The final step asks whether the database being created is to be opened after it is built by the wizard. It has no bearing on the actual building of the database. If you don't want to open the new database at this point, you can always return to it later and open it in Access.

Database Wizard - Screen 6

  • Leave or remove the check mark that appears in the check box associated with the Yes, start the database prompt.
  • Click Finish to initiate the database build.

    Database Wizard Dialog Box

Challenge!

Review the database wizard screens shown in this lesson—the same screens that were used to create the contact management database—and answer the following questions:

  • True or False: The database wizard begins by selecting a template database.
  • The Contact Management database stores which of the following:
  1. Contact information only
  2. Diary entries only
  3. Call information only
  4. Both 1 and 2
  5. Both 1 and 3
  • Identify the three tables contained in the contact management database.
  • Identify the nine fields contained in the Contact_Information table of the contact management database.
  • The database wizard lets you define the following:
  1. Screen presentation
  2. Report presentation
  3. Both 1 and 2
  4. None of the above
  • True or False: The wizard lets you define where the database is saved but does not let you assign a database name.

/en/accessxp/opening-a-table-and-learning-to-navigate-records/content/