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

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