Help on access assignment

Need some help with these questions for access assignment as I am stuck on this chapter. The problems are found on the word doc that will need to be implemented and done on the access sheet.
pack_a03ch06_grader_a1_vegastours.zip

yo16_ac_ch06_grader_ps2_as_instructions__2_.docx

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

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions
Your Office Access Chapter 6 Problem Solve 2
YO16_AC_CH06_GRADER_PS2_AS – Vegas Tours Souvenir Shop
Database
Project Description:
The Vegas Tours Souvenir Shop is where Las Vegas bus tours start and end, seven days a week. The shop sells a
variety of Vegas souvenirs to customers who take the tour and to those who simply want to purchase souvenirs.
Management has been using an Access database to keep track of customers, products, and transactions. You
have been given some sample sales data from February 2018. Management has asked you to create some
queries to begin the process of analyzing the data that has been collected.
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 a03ch06_grader_a1_VegasTours.accdb.
Save the file with the name a03ch06_grader_a1_VegasTours_LastFirst, replacing
LastFirst with your name. Enable the content, if necessary.
0
2
Create a query based on the tblProduct table that will display the ProductID,
ProductDescription, QuantityInStock, Cost, Size, and Color, in that order, for any product with
shirt in the ProductDescription field.
10
3
Sort the results in Descending order by Cost. Only display the products with the top 25% of
cost. Save the query as qryShirtInventory and then close the query.
7
4
Create a query using the tblCustomer table. Display CustomerID, FirstName, LastName, and a
new calculated field named Coupon?, in that order. In the Coupon? field, use the IIf and Like
functions to display No Coupon if the customer did not take the tour and Send 10% off
next visit if the customer did take the tour.
12
5
Sort the results in Ascending order by LastName. Save the query as qryCouponList and then
close the query.
5
6
Create a query based on the tblProduct table that will display the ProductID,
ProductDescription, Category, QuantityInStock, Cost, Size, Color, and a new calculated field
named Retail Price, in that order. In the Retail Price field, use the Round function to display
the price that the store needs to sell its products. The retail price is two times the cost.
12
7
Format the retail price field as Currency. Save the query as qryRetailPrice and then close
the query.
5
8
Create a query based on the tblCustomer table that will display the FirstName, LastName,
Address, City, State, and ZipCode, in that order. In the LastName field, use a wildcard and the
Like function to include customers whose last names begin with letters M through Z.
12
Updated: 09/02/2016
1
YO16_AC_CH06_GRADER_PS2_AS_Instructions.docx
Office 2016 – myitlab:grader – Instructions
Step
Your Office Access Chapter 6 Problem Solve 2
Points
Possible
Instructions
9
Sort the results in Ascending order by LastName. Save your query as qryMZCustomers and
then close the query.
5
10
Create a query based on the tblCustomer and tblPurchase tables that will concatenate the
member’s first and last names (separated by a space) followed by the date they made a
purchase. Name the concatenated field Purchase Details. Use a comma to separate the full
name and date, in that order. Save your query as qryPurchaseDetails and then close the
query.
12
11
Create a query based on the tblPurchase and tblPurchaseLine tables that will display the
PurchaseID, PurchaseDate, PurchaseLine, ProductID, and Quantity in that order to view all
transactions that fall within a specific date range.
12
12
Add a parameter that allows you to enter a start and end date, using Enter start date and
Enter end date as the prompts. Use 2/5/2018 as the start date and 2/8/2018 as the end
date to test your query. Save your query as qryDateRange and then close the query.
8
13
Close all database objects. Close the database and then exit Access. Submit the database as
directed.
0
Total Points
Updated: 09/02/2016
2
100
YO16_AC_CH06_GRADER_PS2_AS_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