02 Jul Help With Access Home Work
Question Description
Help with two home work questions
the instructions at here in the work
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
1
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.