Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Make a new table that contains the products that are discontinued. Name the new table Discontinued Products. Delete the discontinued products from the Products

1. Make a new table that contains the products that are discontinued. Name the new table Discontinued Products. Delete the discontinued products from the Products table. (8 points) 2. Create a query to find out customers that have not placed any orders. Name the query Customers without any Orders. (4 points) 3. Create a form using the Customers table. Delete the Orders subform. Name the form frm_Customers. (3 points) 4. Create a new table with the following fields from the Orders table: a. OrderID b. CustomerID c. EmployeeID d. Freight e. ShipCountry Name the table Orders by Country. (3 points) 5. Create a new report rpt_OrdersbyCountry using the table Orders by Country. Make sure that the report is grouped by Ship Country. Calculate the total sum for freight for each country. (6 points) 6. Create a parameter query that displays a list of products by company name. The user should be able to enter the company name in the query and a list of products supplied by that company should be displayed. (6 points)

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_2

Step: 3

blur-text-image_3

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

Auditing

Authors: Alan H. Millichamp

8th Edition

082645500X, 9780826455000

More Books

Students also viewed these Accounting questions

Question

I still dont get trend analysis. How does it help me find risks?

Answered: 1 week ago