Help on This project

Hi there, I’ve am stuck on this one too with the problems that need to be done. The word doc shows the problems that will need to be completed on the access doc.
pack_a04ch07_grader_h1.zip

yo16_ac_ch07_grader_ps1_hw_instructions.docx

Don't use plagiarized sources. Get Your Custom Essay on
Help on This project
Just from $13/Page
Order Essay

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions
Your Office Access Chapter 7 Problem Solve 1
YO16_AC_CH07_GRADER_PS1_HW – Advanced Queries
Project Description:
Management at the Golf Pro Shop has been collecting and storing their sales data in an Access database and
need your help to create some queries to help them to begin to make sound business decisions based on data.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Instructions
Points
Possible
1
Start Access. Open the downloaded Access file named a04ch07_grader_h1.accdb. Save the file
with the name a04ch07_grader_h1_LastFirst using your last and first name. If necessary,
enable the content.
0
2
Create a query based on tblTransactions and tblProducts that will calculate the total revenue
earned for each ProductType. Add ProductType and a calculated field called Revenue to the
Query design grid. The Revenue field should multiply Quantity and UnitPrice.
8
3
Group the results by ProductType, sum the Revenue calculation, format the Revenue field as
Currency, and then sort the results in Descending order by Revenue. Name the query
qryRevenueByProductType.
8
4
Create a query based on tblCustomers and tblTransactions that will display the FirstName,
LastName, StreetAddress, City, State, Zip, and Phone for any resort member who has made a
purchase at the Pro Shop during the fourth quarter of 2018. Be sure that each customer is
listed only once.
14
5
Sort in Ascending order by LastName. Save the query as qry4thQuarterCustomers. Close
the query.
6
6
Create a query based on tblTransactions and tblProducts that calculates total sales volume for
each ProductType during the first quarter of 2018. The query should calculate the total
quantity of items sold by applying the Sum aggregate function to the Quantity field. Rename
this field Q1SalesVolumeByType. Group the results by ProductType.
10
7
Save the query as qryQ1SalesVolumeByType. Close the query.
6
8
Create a query based on tblTransactions that calculates gross sales volume during the first
quarter of 2018. The query should calculate the total quantity of items sold by applying the
Sum aggregate function to the Quantity field. Rename this field TotalQ1SalesVolume.
10
9
Save the query as qryTotalQ1SalesVolume. Close the query.
4
Updated: 08/26/2016
1
YO16_AC_CH07_GRADER_PS1_HW_Instructions.docx
Office 2016 – myitlab:grader – Instructions
Step
Your Office Access Chapter 7 Problem Solve 1
Points
Possible
Instructions
10
Create a query based on qryQ1SalesVolumeByType and qryTotalQ1SalesVolume that
calculates the percentage of quarter 1 sales volume for each ProductType. Your subquery
should include the ProductType field and a calculated field named
%OfQ1SalesVolumeByType that divides Q1SalesVolumeByType by TotalQ1SalesVolume.
10
11
Format the calculated field as Percent with 2 decimal places. Sort the results in Descending
order by %OfQ1SalesVolumeByType.
6
12
Save the query as qryQ1PercentByTypeSalesVolume. Close the query.
4
13
Create a query using SQL based on tblTransactions and tblProducts that calculates total sales
volume for each ProductType. Use the INNER JOIN clause to connect the two tables. Use the
AS clause to rename the calculated field that totals the Quantity field as HighSalesVolume.
Group the results by ProductType. Use the HAVING clause to ensure that only products with a
total quarter 1 sales volume of at least 200 are returned. Use the ORDER BY clause to sort the
results in descending order by the calculated field.
10
14
Save the query as qryHighSalesVolumeByType.
4
15
Exit Access, and then submit your file as directed.
0
Total Points
Updated: 08/26/2016
2
100
YO16_AC_CH07_GRADER_PS1_HW_Instructions.docx

Purchase answer to see full
attachment

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 15% with the discount code ESSAYHELP