Requirements: 1. A. Build the following 4 tables with their attributes (field 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 - InvoiceIN (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 InysiseDetail table using InvoiceID Link Customer to Invoice table using Customer ID 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 5. Use your form to process five sales to update Sales/Invoice Table and the Inxoise Detail Table. 6. Make an invoice report. (this requires doing a query first and then a report) A. First use queries to bring the information together. You will need InvoiceID. Invoice Date, Customer PO#, customer# from the invoice table: Customer Name from the customer table; ItemID. Quantity, and Actual Price from the InvoiceDetail table; and Item Description from the Inventory table. Add the formula to calculate extended sales. Extended Sales: [Actual Price]*[Quantity] B. Make a report using the wizard. Group by Customer. Group by Inxoiseln, and sort by Item and include totals. Requirements: 1. A. Build the following 4 tables with their attributes (field 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 - InvoiceIN (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 InysiseDetail table using InvoiceID Link Customer to Invoice table using Customer ID 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 5. Use your form to process five sales to update Sales/Invoice Table and the Inxoise Detail Table. 6. Make an invoice report. (this requires doing a query first and then a report) A. First use queries to bring the information together. You will need InvoiceID. Invoice Date, Customer PO#, customer# from the invoice table: Customer Name from the customer table; ItemID. Quantity, and Actual Price from the InvoiceDetail table; and Item Description from the Inventory table. Add the formula to calculate extended sales. Extended Sales: [Actual Price]*[Quantity] B. Make a report using the wizard. Group by Customer. Group by Inxoiseln, and sort by Item and include totals
