Please help and clearly explain step by step using accessCreate the following queries using the correct tables:List the names of places from which the company sells. Show all columns in the table. Name this query Q1-SELLING-LOCATIONS.What is the total sales by location for May 2008, sorted in descending order? Name this query Q2-SALES-MAY2008. (Hint: “Where” clause may be useful)The company has been informed that the tax has been increased to 17.5%. Calculate how much additional tax (i.e., the difference) the store would have collected by year. Name this query Q3 – ADDED-TAX.Hints: For queries, when using the totals options, consider the “where” and “expression” clauses.

Q1-SELLING-LOCATIONS:Open "Query Design" from the "Create" tab.Add the table with selling…

Answered: Please help and clearly explain step by…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Please help and clearly explain step by step using access

Create the following queries using the correct tables:

List the names of places from which the company sells. Show all columns in the table. Name this query Q1-SELLING-LOCATIONS.
What is the total sales by location for May 2008, sorted in descending order? Name this query Q2-SALES-MAY2008. (Hint: “Where” clause may be useful)
The company has been informed that the tax has been increased to 17.5%. Calculate how much additional tax (i.e., the difference) the store would have collected by year. Name this query Q3 – ADDED-TAX.

Hints: For queries, when using the totals options, consider the “where” and “expression” clauses.

Expert Solution