Question: Lab Exercise: Database Entry, Queries and Reports This document contains 5 pages. Use the Coke database to perform the following steps: 1. Enter the

Lab Exercise: Database Entry, Queries and Reports This document contains 5 pages.

Lab Exercise: Database Entry, Queries and Reports This document contains 5 pages. Use the Coke database to perform the following steps: 1. Enter the data in the tables in the specified order (SEE PAGE 2 FOR DATA): I a. Customer b. Distributor C. Category d. Product e. Order f. OrderLine 2. Create a query with fields Customers name and phone whose orders were supplied by the distributor Van Distributors. 3. Create a query to show the number of orders that contains Coca-Cola. 4. Create a query to show the total amount of items ordered by category (Note: you would want to use the category name instead of the Categoryld). 5. Create a query to show the distributor that distributed the most orders. 6. 7. Create a report to show the total fee due to each distributor. 8. Create a query to show the customer, his order and the total quantity of products in each order. Create a report to show the daily invoice for each customer (prices for products and their totals). PLEASE SEE PAGE 2 FOR THE DATA

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!