Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Leading Strategic Change In An Era Of Healthcare Transformation

Authors: Jim Austin ,Judith Bentkover ,Laurence Chait

1st Edition

3319808826, 978-3319808826

More Books

Students also viewed these General Management questions

Question

Define the term CHAMPERTY

Answered: 1 week ago