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.
  
  
• 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.
  
  
• Click to select on the contact management icon.
• Click OK to launch the wizard.
  
  
• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.