Microsoft Access help on ch. 8

This one has a two parts to it, and the problems are found in the word doc. The word doc will guide you through what will need to be done, I’ve tried to do this one but can’t seem to grasp it, Access is a hard one for me compared to excel.
yo16_ac_ch08_grader_pc_hw_instructions.docx

pack_a04ch08_grader_pc_spa2__1_.zip

Don't use plagiarized sources. Get Your Custom Essay on
Microsoft Access help on ch. 8
Just from $13/Page
Order Essay

a04ch08_grader_pc_marketing1.zip

a04ch08_grader_pc_marketing2.zip

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions
Your Office Access Chapter 8 Prepare Case
YO16_AC_CH08_GRADER_PC_HW – The Turquoise Oasis Spa:
Understanding Action Queries
Project Description:
The Turquoise Oasis Spa generates revenue through its spa services and product sales. The spa needs updated
information in order to run its business efficiently and make decisions about the business. The Spa Manager,
Meda Rodate, and Salon Manager, Irene Kai, have asked you to automate the creation of tables and data updates
through the use of action queries. This will make data management easier and more efficient for the managers
and spa employees. Additionally, the managers will be able to track marketing campaigns such as viewing the
customers who have redeemed coupons and discounts.
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 a04ch08_grader_pc_Spa2.accdb. Save the file with
the name a04ch08_grader_pc_Spa2_LastFirst, using your last and first name. If necessary, enable
the content. Also, download and save the Access files named a04ch08_grader_pc_Marketing1.accdb and
a04ch08_grader_pc_Marketing2.accdb.
0
2
3
4
5
Create a Make Table query in the a04ch08_grader_pc_Marketing1.accdb database based on the
tblCampaign and tblMailing tables.
• The new table should include MailingID, CustomerID, and Redeemed from the tblMailing and
CampaignName, CampaignType, StartDate, EndDate, DiscountCode, Department, and Details from the
tblCampaign.
• Criteria for Department should be Turquoise Oasis Spa. Clear the Show check box.
• Name the new table tblCampaign and add the table to the a04ch08_grader_pc_Spa2_LastFirst
database.
• Run the query, and then save the query as qryMakeTable.
• Close the a04ch08_grader_pc_Marketing1 database.
In the a04ch08_grader_pc_Spa2_LastFirst, open the tblCampaign
Field
Field Properties
MailingID
Change to Primary key
Change the format to “MID”0
CustomerID
Change caption to Customer
Redeemed
Change the lookup control to a check box
CampaignName Change the caption to Campaign Name
CampaignType Change the caption to Campaign Type
StartDate
Change the caption to Start Date
EndDate
Change the caption to End Date
DiscountCode Change the caption to Discount Code
Details
table and make the following changes:
Description
The Mailing ID (primary key)
The Customer ID (foreign key)
Was the coupon redeemed?
The campaign name
The campaign type
The campaign start date
The campaign end date
The POS discount code
The details of the campaign
Create a relationship between CustomerID in the tblCampaign and CustomerID in the tblCustomer, and
then enforce referential integrity.
Create an append query that appends updated data from the marketing departments spring promotions
for Turquoise Oasis Spa. The data is stored in the a04ch08_grader_pc_Marketing2 database and needs to
be appended to the tblCampaign table in the a04ch08_grader_pc_Spa2_LastFirst database.
• The append query should include MailingID, CustomerID, and Redeemed form the tblMailing table, and
CampaignName, CampaignType, StartDate, EndDate, DiscountCode, Department, and Details from the
Updated: 12/16/2016
1
11
YO16_AC_CH08_GRADER_PC_HW_Instructions.docx
8
4
11
Office 2016 – myitlab:grader – Instructions
Step
Your Office Access Chapter 8 Prepare Case
Instructions
Points
Possible
tblCampaign in that order.
• Criteria for Department should be Turquoise Oasis Spa. Clear the Show check box.
• Criteria for StartDate should be #4/1/2018#.
• Run your query, and then save your query as qryAppendData.
• Close the query.
• Close the a04ch08_grader_pc_Marketing2 database.
Create an Update query that extends the date for all In-house promotions from 3/31/2018 to
6/30/2018 in the tblCampaign table of the a04ch08_grader_pc_Spa2_LastFirst database.
6
• The query should include MailingID, CampaignType, and EndDate from the tblCampaign table.
• Run your query, and then save your query as qryUpdateData.
• Close the query.
11
Create an Update query that changes the details for all In-house promotions in the tblCampaign table
in the a04ch08_grader_pc_Spa2_LastFirst database. The Details field will add the additional text that a
minimum purchase of $50 is required by concatenating it to the existing data.
7
8
9
10
• The query should include CampaignType and Details from the tblCampaign table in that order.
• In the Update To property row of the Details type [Details] & ” ” & “Minimum purchase of $50 is
required.”
• Run your query, and then save your query as qryUpdateDetails.
• Close the query.
Create a complex Update query that will add the Zip Codes and update the area codes in the tblCustomer
table from the tblMktgImport table.
• Create a relationship between the CustomerID fields in both tables. Do not enforce referential integrity.
• The query should include CustomerID, CustCity, CustState, CustZipCode, and CustPhone from the
tblCustomer table in that order.
• To update data from one table to another and match the fields between the two tables, type the
following in the Update To row.
Field
Update To
CustCity
[tblMktgImport]![CustCity]
CustState
[tblMktgImport]![CustState]
CustZipCode [tblMktgImport]![CustZipCode]
CustPhone
[tblMktgImport]![CustPhone]
• Run your query, and then save your query as qryComplexUpdate.
• Close the query.
Create a Delete query that deletes the two soap products from the tblProduct table. Add the
ProductDescription field to the query. Use a wildcard and the Like function.
• Run the query, and then save your query as qrySimpleDelete.
• Close the query.
Create a Delete query that deletes customers with the last names Dunn and Cleveland from the
tblCustomer table and all related data. You will need to edit the appropriate relationships to Cascade
Delete Related Records in order to do this.
• The query should include CustomerID, CustFirstName, and CustLastName from the tblCustomer table in
that order.
• Run the query, and then save your query as qryComplexDelete1.
• Close the query.
Updated: 12/16/2016
2
YO16_AC_CH08_GRADER_PC_HW_Instructions.docx
11
11
11
11
Office 2016 – myitlab:grader – Instructions
Step
Your Office Access Chapter 8 Prepare Case
Points
Possible
Instructions
Create a Delete query that deletes scheduled appointments in the spa on 1/15/2018 after 11 am due
to construction on that date.
11
• The query should include DateofAppt and TimeofAppt form the tblSchedule table in that order.
• Run the query, and then save your query as qryComplexDelete2.
• Close the query.
11
12
Close the database, exit Access, and then submit the file as directed.
0
Total Points
Updated: 12/16/2016
3
YO16_AC_CH08_GRADER_PC_HW_Instructions.docx
100

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