Assignment #2 - Due April 23

CM560 - Spring 2002

Click on the help link to get additional online helpful information.

"Your organization wants to build a database that tracks all of the suppliers that are assigned to your various projects.

The organization owns a copy of MS Office Professional. Can you help out?"

  1. Create a blank database using Access. (Unleashed p 556)
  2. Create the following tables using the Table Wizard (Unleashed pp 570-577) When creating the table within the Wizard, chose to automatically create an input form from the table.

Projects

Suppliers
Project ID - key field Supplier ID
Project Name Supplier Name
Project Description Address
  City
  State
  Zip Code
  Phone
  Fax
  Email
  1. Create the following table using the Table Design View (Unleashed pp 579-584)

Purchase Order

  
PO Number Auto Number
Project ID Lookup Wizard (browse to the keyfield in the Project table)
Supplier ID Lookup Wizard (browse to the keyfield in the Supplier table)
PO Date Date/Time
Amount Currency
  1. Save the database as "<your username>Assign2.mdb" and email the entire database to me as a file attachment. ?

EXTRA CREDIT

  1. Create an input form for the Purchase order table using the Forms Wizard. (Unleashed pp 627-631)

 

[Return to CM560]