Question: Please help and clearly explain step by step using access Create the following queries using the correct tables: a . List the names of places

Please help and clearly explain step by step using access
Create the following queries using the correct tables:
a. List the names of places from which the company sells. Show all columns in the table. Name this query Q1-SELLING-LOCATIONS.
b. 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)
c. 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.
 Please help and clearly explain step by step using access Create

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!