Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started