Creating Tables   «Prev  Next»

Creating a New Table with a Wizard - Exercise

Create a table using the Table Wizard

Objective: Create a table using the table wizard.

Exercise Scoring


You will receive 5 points for this exercise. The exercise is auto-scored, which means all you need to do to receive full credit for the exercise is click the Submit button.

Instructions

  1. Open your Consulting Database. If you didn't create the Consulting database in the last module, you can download and open Consulting_04.mdb from the resources page.
  2. Use the Table Wizard to create a table to hold the following information about your clients:
    1. Customer
    2. First Name
    3. Last Name
    4. Address
    5. City
    6. State Zip

    You may need to change the name of some fields.
  3. Name the table Clients and allow Access to create a primary key for you.