1. ACCESS PROBLEM
2. A. Build the following 4 tables with their attributes (fields types, field size)

Customer Table customerID (number), Customer Name (text, 20), Contact Number (number)

Inventory Table ItemID(text, 5), Description (text, 15), Budget cost (currency), Budget price (currency), Warehouse Quantity (number)

Invoice Table InvoiceID (number), Shipping Date (date), customer PO# (text, 10), CustomerID (number)

InvoiceDetail table. InvoiceID (number), ItemID (text, 5), Quantity (number), Actual Price (currency)

B. Set the primary keys for the bolded items

2. Use the primary/foreign key combinations to link the tables (relationships). Use referential integrity.

Link Inventory table to InvoiceDetail table using ItemID

Link Invoice table to InvoiceDetail table using InvoiceID

Link Customer to Invoice table using CustomerID

3. Put 3 customers into the customer Table and 3 items in the Inventory Table. (do not use mine from the videos - make up your own)

4. A. Build a form with a subform. This form will use two tables; the Invoice table as the header and the InvoiceDetail as the subform. Use the form wizard for this.

B. Add a command button (such as print or add or delete)

C. Add a drop-down list