Cashback Offer from 5th to 10th October 2021. Get Flat 10% Cashback credited to your account for a minimum transaction of $80. Post Your Question Today!

Question DetailsNormal
$ 30.00

YO16_AC_CH01_GRADER_PC_HW - Red Bluff Golf Course Putts for Paws Charity

Question posted by
Online Tutor Profile
request

YO16_AC_CH01_GRADER_PC_HW - Red Bluff Golf Course Putts for Paws Charity Tournament

 

Project Description:

The Red Bluff Golf Course and Pro Shop is sponsoring a charity tournament, Putts for Paws, to raise money for the Santa Fe Animal Center. An intern created a database to help run the tournament but did not finish it before leaving. You have been asked to finish the database to track the participants who enter the tournament, the orders they have placed, and the items they have purchased.

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 file named a01ch01_grader_pc_Putts.accdb. Save the file with the name a01ch01_grader_pc_Putts_LastFirst, using your last and first name. If necessary, enable the content.

0

2

Import the tblParticipant table from the a01ch01Participant.accdb Access database.

15

3

Edit the first record in the tblParticipant table so that the LastName field is Student and the FirstName field is Access.

7

4

Add a new record to the append row of the tblParticipant table using the following data.

ParticipantID 30

LastName Fox

FirstName Jeff

StreetAddress 1509 Las Cruces Drive

City Las Cruces

State NM

ZipCode 88003

ContactPhoneNumber 5055558786

CorporatePhoneNumber (leave blank)

Close the tblParticipant table.

10

5

Use the Query Wizard to select the following fields from tblParticipant (in this order): LastName, Firstname, and City. Save the query as qryParticipantSantaFe.

7

6

Switch to Design View of qryParticipantSantaFe and type Santa Fe in the criteria row of the City field.

6

7

Sort the results of the query by LastName in ascending order and then by FirstName in ascending order. Run the query.

7

8

Create a form using the tblParticipant table and save it as frmParticipant.

10

9

Edit the title to be Participant Form and then save the form.

8

10

Add a new record to tblPartcipant using the form and the following data.

ParticipantID 31

LastName Silva

FirstName Jackson

StreetAddress 1509 Main Street

City Santa Ana Pueblo

State NM

ZipCode 87044

ContactPhoneNumber 5055553355

CorporatePhoneNumber (leave blank)

Close the form.

10

11

Use the Report Wizard to create a report displaying the following fields from tblParticipant (in this order): LastName, FirstName, City, and ContactPhoneNumber. Group the participants by City, sort the participants by LastName and then by FirstName in ascending order. Display the report with a stepped layout and portrait orientation. Save the report as rptParticipantsByCity.

15

12

In Layout view, drag the left border of the ContactPhoneNumber heading to the left until the entire column heading is visible. Edit the title of the report to be Tournament Participants By City.

Save and close the report.

5

13

Close the database, exit Access, and then submit your file as directed by your instructor.

0

Total Points

Available Answer
$ 30.00

[Solved] YO16_AC_CH01_GRADER_PC_HW - Red Bluff Golf Course Putts for Paws Charity

  • This solution is not purchased yet.
  • Submitted On 07 Sep, 2021 02:22:27
Answer posted by
Online Tutor Profile
solution
YO16_AC_CH01_GRADER_PC_HW - Red Bluff Golf Course Putts for Paws Charity Tournament Project Description: The Red Bluff Golf Course and Pro Shop is sponsoring a charity tournament, Putts for Paws, to raise money for the Santa Fe Animal Center. An intern created a database to help run the tournament but did not finish it before leaving. You have been asked to finish the database to track the participants who enter the tournament, the orders they have placed, and the items they have purchased. 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 file named a01ch01_grader_pc_Putts.accdb. Save the file with the name a01ch01_grade...
Buy now to view the complete solution
Other Similar Questions
User Profile
Acade...

YO16_AC_CH01_GRADER_PC_HW - Red Bluff Golf Course Putts for Paws Charity

YO16_AC_CH01_GRADER_PC_HW - Red Bluff Golf Course Putts for Paws Charity Tournament Project Description: The Red Bluff Golf Course and Pro Shop is sponsoring a charity tournament, Putts for Paws, to raise money for th...

The benefits of buying study notes from CourseMerit

homeworkhelptime
Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
tutoring
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
tutorsupport
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton

$ 629.35