Ctr41

MS Access Exercise 2

Start with the database file from Exercise 1 which contains CUSTOMERS table and

New Customers form.

Create table: Products

Create the field names and their properties as you need them to store your specific data for

products. You will have at least 10 products with their information included in your table.

Products Table Field Names:

ProductID (Primary Key: PID)

ProductName (PNAME)

UnitsInStock (INSTOCK)

UnitsOnOrder (ONORDER)

Weigth (WEIGHT)

UnitPrice (PRICE)

Create form: New Products

Create a form for the Products table. Include all fields in the form. Use the Form Wizard to

create a form.

Create table: ORDERS

Create the field names and their properties as you need them to store your specific data for orders.

Orders Table Field Name(s)

OID (Order ID) (Primary Key)

ODATE (Date of Order)

CID (Customer ID) (FK)

Then relate the tables into a one -to-many relationship between CUSTOMERS and

ORDERS.

Create table: SHIPMENTS

Create the field names and their properties as you need them to store your specific data for orders.

Shipments Table Field Name(s)

SID (Shipment ID) (Primary Key)

SDATE (Date of Shipment)

OID (FK)

Then relate the tables into a one -to-one relationship between SHIPMENTS and ORDERS.

Using the New Customers form (Exercise 1), enter two additional customers:

C0007 Belinda Williams New Paltz NY 1 $53.00 April 15, 2016

C0008 Kenny Edwards Pittsburgh PA 1 $270.00 April 17, 2016

Create form: New Orders

Create a form for the Orders table. Include all fields in the form. Use the Form Wizard to create a form. Using the New Orders form, enter two orders:

O2525 March 20, 2010 C0007

O2424 March 19, 2010 C0008