A. Create the following tables:
Use this page as a guide for you field names.
Include at least four fields in each table, use proper naming structures and data types. Make sure you normalize your table structure.
B. Create a form to enter data into each of your tables:
Enter at least 10 entries into each of your tables.
C. Create appropriate relationships between your tables:
D. Create and save a Query that will report the current inventory (numInStock) of each of our Products for which we have less than 10 items left and thus must reorder. Name this query qryReorder.
(You may need to go back and add a field to the products table to store this information, remember to recreate your form for this new field)
E. Use the Employees and Sales tables to create a report of the best salesman. (List all sales by employee) Include a calculated field that figures each salesman's commission (5% of total sales)
F. Create a flyer in Word for a sale on two of our products. Use a mail merge to personalize the flyer to three of our customers (hint create a query that will sort out 3 customers and then merge to this query). Add the company logo to the top of the page. The flyer should have at least 3 merged fields in the document.
G. Also use Word to create envelopes to each of our customers. Include the company logo in the envelope return address area.
H. Create return address lables for your company include the company logo.
I. Create a spreadsheet in Excel that will display an amortization schedule for our customers to see what their payments will be and how much will go to interest and how much to reduce the principle. Include bar graphs of each that include interactivity so they can change numbers and see the resulting changes in the graph. (example)
(This Chart must be viewed in Internet Explorer to function correctly)