Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help with # 3 & # 4 . You are given a database - MGMT 2 0 0 6 _ 2 0 2 3
Please help with # & #
You are given a database MGMTSBoutique Inc Student File.accdb,
containing Currencies, Sales, and Locations tables to provide some results for MGMT Boutique
INC. That is your CC will provide you with the database You should:
Append two new customers, two old customers and two new POS transactions. Be
sure to include sales for your two new customers.
Create the following queries:
a List the names of places from which the company sells. Show all columns in the table.
Name this query QSELLINGLOCATIONS.
b What is the total sales by location for May sorted in descending order? Name
this query QSALESMAYHint: Where clause may be useful
c The company has been informed that the tax has been increased to Calculate
how much additional tax ie the difference the store would have collected by year.
Name this query Q ADDEDTAX.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started