CLICK TO DOWNLOAD THIS ANSWER

YO19_Access_Ch01_Prepare – Putts 1.1

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.

Steps to Perform:

Step

Instructions

Points Possible

Start Access. Open the downloaded file named Access_CH01_Prepare_Putts.accdb. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.

Import the tblParticipants table from the Access_CH01_Prepare_Participants.accdb Access database.

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

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

ParticipantID	30
LastName	Harper
FirstName	Juliet
StreetAddress	1509 Las Cruces Drive
City	Las Cruces
State	NM
ZipCode	88003
ContactPhoneNumber	5055558786

CorporatePhoneNumber (leave blank)

Close the tblParticipants table.

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

Switch to Design View of qryAlbuquerque and type Albuquerque in the criteria row of the City field.

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

Save and close the query.

Create a form using the tblParticipants table and save it as frmParticipants.

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

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

ParticipantID	31
LastName	Pena
FirstName	Audrey
StreetAddress	9895 Semper Avenue
City	Belen
State	NM
ZipCode	87002
ContactPhoneNumber	5055553355

CorporatePhoneNumber (leave blank)

Close the form.

Use the Report Wizard to create a report displaying the following fields from tblParticipants (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.

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.

Save and close Access_CH01_Prepare_Putts.accdb. Exit Access. Submit your files as directed.

Total Points

100