Expert answer:Ch8 grader pj h1 Access

Expert answer:Taking a course program that is in Microsoft Access, I am needing help with Ch.8 Lately haven’t been able to grasp the formulas and ways to go about doing some of these. I would like help on this one, the problems are found in the word doc.
yo16_ac_ch08_grader_ps1_hw_instructions__1_.docx

pack_a04ws08_grader_h1.zip

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions
Your Office Access Chapter 8 Homework 1
YO16_AC_CH08_GRADER_PS1_HW – Managing Data in the Putts for
Paws Database
Project Description:
Putts for Paws is a charity event that raises money for a local animal shelter and is hosted by the Red Bluff Golf
Course. The details of the event, such as corporate sponsors, participants, and orders, are tracked using an
Access database. You have been asked to update the database so the Putts for Paws director has an easier time
managing the data from year to year. You have been given a sample database to assist the organization by
creating action queries that will allow them to maintain accurate data.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
1
2
3
4
Instructions
Start Access. Open the downloaded Access file named a04ws08_grader_h1.accdb. Save the
file with the name a04ws08_grader_h1_Putts_LastFirst, replacing LastFirst with your
name. Enable content, if necessary.
Create a Make Table query based on tblParticipant and tblOrder of all participants who have
placed an order with the Putts for Paws Charity. Include ParticipantID, FirstName, LastName,
and ContactPhoneNumber from tblParticipant, and AmountPaid and OrderDate from tblOrder,
in that order. Name the table the query will create tblParticipantOrders. Run the query,
and then save your query as qryParticipantOrderTable. Close the query.
Open tblParticipantOrders in Design view. Move the first field, ParticipantID, to be the last field
in the table. Create a new first field named PartOrderID with a data type of AutoNumber
and make it the primary key. Add the following custom format: “PO0″0 (that’s “POzero”zero)
to PartOrderID. Enter Participant Order ID (primary key) as the description. For the
FirstName field, add First Name as the caption. Enter Participant first name as the
description. For the LastName field, add Last Name as the caption. Enter Participant last
name as the description.
Continue making the following changes to the tblParticipantOrders table. For the
ContactPhoneNumber field, add the default Phone Number format Input Mask. Add Phone as
the caption. Enter Contact phone number as the description. For the AmountPaid field, add
Amount Paid as the caption. Enter Amount paid as the description. For the OrderDate field,
add the Short Date format Input Mask. Add Order Date as the caption. Enter Order date as
the description. For the ParticipantID field, enter Participant ID (foreign key) as the
description. Save and close the table.
Points
Possible
0
9
10
9
5
Create a relationship between ParticipantID in tblParticipant and ParticipantID in
tblParticipantOrders. Enforce referential integrity. Save and close the Relationships window.
10
6
Create an Append query that will append the participants in the tblNewParticipants table to
the tblParticipant table. Include all fields in their existing order. Run the query, and then save
it as qryAppendNewParticipants. Close the query.
8
7
Create an Update query that will update all address fields and the contact phone for the
participants in the tblParticipant table from the data that is in the tblUpdatedParticipantInfo
table where the ParticipantID fields match. Maintain the existing order of the added fields. Run
the query, and then save it as qryUpdateParticipantInfo. Close the query.
8
Updated: 09/03/2016
1
YO16_AC_CH08_GRADER_PS1_HW_Instructions.docx
Office 2016 – myitlab:grader – Instructions
Your Office Access Chapter 8 Homework 1
Step
Instructions
Points
Possible
8
Participant Ian McShane, ParticipantID 3, had notified Putts for Paws that he has to withdraw
himself from the event. You have been asked to remove him from the tables in the database.
Update the relationship between tblParticipant and tblOrder to cascade delete related records.
Update the relationship between tblParticipant and tblParticipantOrders to cascade delete
related records. Create a Delete query that will remove ParticipantID 3 from the tblParticipant
table. Run the query, and then save it as qryDeleteParticipant. Close the query.
10
9
Create an outer join query that lists all participants and participant orders, even if a participant
does not have an order. Include ParticipantID, FirstName, and LastName, in that order, from
tblParticipant, and then include AmountPaid and OrderDate from tblParticipantOrders. Run the
query, and then save your query as qryParticipantOrders. Close the query.
10
10
Create an outer join query that lists all participants and participant roles, even if a participant
does not have a role. Include ParticipantID, FirstName, and LastName, in that order, from
tblParticipant, and then include CorporateID and Role, in that order, from tblParticipantRole.
Run the query, and then save your query as qryParticipantRoles. Close the query.
10
11
Create a Find Unmatched query that displays all the participants who do not have an order.
Use tblParticipant as the table you want to see in your results, and tblParticipantOrders as the
table that contains the related records. Include ParticipantID, FirstName, and LastName, in
that order. Save the query as qryUnmatchedPartOrders. Close the query.
8
12
Create an inner join query that includes Company Name from tblCorporate and Role from
tblParticipantRole. Run the query, and then save it as qryCompanyRoles. 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/03/2016
2
100
YO16_AC_CH08_GRADER_PS1_HW_Instructions.docx
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades