How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Scott Your Own Question
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3040
Experience:  MIT Graduate (Math, Programming, Science, and Music)
Type Your Homework Question Here...
Scott is online now
A new question is answered every 9 seconds

Are you available?

Customer Question

hi, are you available?
Submitted: 8 months ago.
Category: Homework
Expert:  LogicPro replied 8 months ago.



provide the details

Customer: replied 8 months ago.
InstructionsPlease 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"Submission: Submit the updated "DePaulMerchants.accdb" database that contains all the queries you developed.
Customer: replied 8 months ago.
can you help do this homework ?
it is due at 6.
we have almost four hours
Expert:  LogicPro replied 8 months ago.

Can provide in 8 hrs. Let me know

Customer: replied 8 months ago.
I will send an access file in a minute
Customer: replied 8 months ago.
it has to be submitted at 6.
Customer: replied 8 months ago.
Customer: replied 8 months ago.
it's not complicated bro.
you can finish it within one hour
Expert:  LogicPro replied 8 months ago.

Sorry friend. I am not on my computer

Customer: replied 8 months ago.
I have a trip
Customer: replied 8 months ago.
Customer: replied 8 months ago.
I already paid money
Expert:  LogicPro replied 8 months ago.

I am opting out for other experts to answer.wait and See if you can get reply

Customer: replied 8 months ago.
thank you
Expert:  LogicPro replied 8 months ago.

Do you still need this?

Related Homework Questions