How can I earn money with StudyBay? Top writers
Order Assignment
This order has already been completed on Studybay
On Studybay you can order your academic assignment from one of our 45000 professional writers. Hire your writer directly, without overpaying for agencies and affiliates! Check price for your assignment
12 total offers received. Writer hired: chelahmilcah

Assignment 6

Please down the "DePaul Merchants" database available as part of this assignment. DePaul Merchants is a trading company that sells products to other businesses. The database is a Microsoft Access database containing several tables: Customers: Contains information for all the customers. Employees: Contains information for all the employees. Products: Contains information for all the products that are being sold. Categories: Contains information for the categories of the products. Suppliers: Contains information for all the suppliers and vendors of the products. Shippers: Contains information for the companies that DePaul Merchants uses for shipping products to the customers. Orders: Contains information for the orders placed by the customers. Order Details: Contains information for the details of each order that contains the various products purchased in each order. In this assignment, you will be creating queries using the Access database. Design and test query based on each questions below. Save each query and name it for each question i.e., for question #1, name the query as "Q1". Here are the questions for which you would need to create queries: 1.) List all customers sorted by company name in ascending order. 2.) List the country and count of customers in each country sorted in descending order. 3.) List the orders placed by each customer and which employee placed the order on what date? 4.) List the total order price for each order placed by the customer. List the customer name and the (sum of UnitPrice * Quantity) for each order. 5.) List which shipping company was used the most for shipping products to the customers? 6.) List each supplier and the total count of products each supplier supplies to DePaul Merchants. 7.) List all non-discontinued products. 8.) List all non-discontinued products which needs to be reordered (hint: where reorder level < (units in stock + units on order)) 9.) List each category and the count of products for each category. 10.) List all customers whose contact name begins with "Ma"
Please down the "DePaul Merchants" database available as part of this assignment. DePaul Merchants is a trading company that sells products to other businesses. The database is a Microsoft Access database containing several tables: Customers: Contains information for all the customers. Employees: Contains information for all the employees.
Related Materials
Assignment ID
59632
Discipline
Type
CREATED ON
November 8, 2016
COMPLETED ON
November 9, 2016
Price
$30
This order has already been completed on Studybay
On Studybay you can order your academic assignment from one of our 45000 professional writers. Hire your writer directly, without overpaying for agencies and affiliates!
Check price for your Reports
Latest reviews for chelahmilcah
andrewbradbury271
December 7, 2016
andrewbradbury271
A- paper.... wished it would of focused more on the prompt though
Bentleynana1
November 30, 2016
Bentleynana1
thanks
within beauty
November 22, 2016
within beauty
great work !!!