YO19_Access_Ch02_Prepare – Putts 1.0 Project Description: The Red Bluff Golf Course & Pro Shop is sponsoring a charity tournament, Putts for Paws, to raise money for the local pet shelter. You are modifying a database for the tournament that tracks money being raised from the event. The scope of this database is limited to tracking monies. Thus, in this instance, you are not tracking whether a participant is a golfer, volunteer, or other role. Anyone can donate money in the form of hole sponsorship or another donation item. You will want to track monies derived from corporate sponsorship. You will bring in data for the event from various sources, including Excel worksheets and text files. Steps to Perform: Step Instructions Points Possible 1 Start Access. Download and open the file named Access_CH02_Prepare_Putts.accdb. Grader has automatically added your last name to the beginning of the filename. Click Enable Editing, if necessary. 0 2 Open the downloaded Excel file, Access_CH02_Prepare_PuttsGolf.xlsx, copy the contents of cells A2:I8 and paste the contents into the tblParticipants table as new records. Close Excel and close tblParticipant. 5 3 Import the records on the Corporate contacts worksheet from the downloaded Excel file, Access_CH02_Prepare_PuttsCont.xlsx, into the tblPartcipants table. 5 4 Import the records in the Volunteers named range from the downloaded Excel file, Access_CH02_Prepare_PuttsVol.xlsx, into the tblParticipants table. 5 5 Import the records from the downloaded tab delimited text file, Access_CH02_Prepare_PuttsDon.txt, into the tblParticipants table. Be sure to indicate that the first row contains field names. 5 6 Add a new record to the tblParticipants table using the following data. ParticipantID 63 LastName Gupta FirstName Sanjay StreetAddress 3544 Cornice Blvd City Las Cruces State NM ZipCode 88001 ContactPhoneNumber 5055557789 CorporatePhoneNumber (leave blank) 4 7 Delete the record for Ethan McShane, ParticpantID 3, from the tblParticipants table. 3 8 Delete the CorporatePhoneNumber field from the tblParticipants table. Close the tblParticipants table. 3 9 Create a new table in Design View with the following fields. Field Name Data Type Field Size CompanyName Short Text 50 StreetAddress Short Text 40 City Short Text 40 State Short Text 2 ZipCode Short Text 10 PhoneNumber Short Text 14 Add a description to the CompanyName field of Name of the company (no period). 6 10 Save the table as tblCorporate and close the table. 2 11 Open the tblItem table in Design View, and change the data type of the Notes field to Long Text. Save and close the table. 3 12 Create an input mask for the PhoneNumber field in the tblCorporate table. Use a mask that will show phone numbers as (555) 555-5555 with a placeholder of “_” and store the input mask symbols with the data. 4 13 Switch to Datasheet view of the tblCorporate table and add a new record to the table using the following data. CompanyName Tesuque Mirage Market StreetAddress 8 Tesuque Mirage Rd City Santa Fe State NM ZipCode 87506 PhoneNumber 5055551111 Resize the column widths so that all headings and data are visible. Save and close the table. 4 14 Open the tblOrder table in Design View. Add a new field named OrderDate with a data type of Date/Time and a description of Date order was placed (no period). 3 15 Create a short date input mask for the OrderDate field. Format the OrderDate field as Medium Date. Save the table design, and then switch to Datasheet view. 3 16 Enter the order date of 05062022 for all orders. Close the table. 3 17 Open the tblCorporate table in Design View. Insert a new field above CompanyName. Name the field CorporateID, select AutoNumber as the data type, and enter a description of Unique corporate identifier (no period). 3 18 Designate the CorporateID field as the primary key. Save and close the table. 2 19 Open the Relationships window. Add the tblParticipants table to the window. Create a relationship between tblParticipants and tblOrder and enforce referential integrity. Save and close the Relationships window. 4 20 Create a new table in Design View that will serve as a junction table for the many-to-many relationship with the following fields. Field Name Data Type Field Size ParticipantRoleID AutoNumber Long Integer CorporateID Number Long Integer ParticipantID Number Long Integer Role Short Text 40 Designate the PartipantRoleID field as the Primary Key and enter a description of Primary key for tblParticipantRoles (no period). Save the table as tblParticipantRoles. Close the table. 5 21 Open the Relationships window. Add the tblCorporate and tblParticipantRoles tables to the window. Create a relationship between the tblParticipants and tblParticipantRoles tables and enforce referential integrity. 4 22 Create a relationship between the tblCorporate and tblParticipantRoles tables and enforce referential integrity. 4 23 Create a Relationship Report, saving the report as Relationships for YO19_Access_CH02_Prepare_Putts. Save and close the Relationship window. 4 24 Open the tblParticipantRoles table in Datasheet view and enter the following records. CorporateID ParticipantID Role 1 5 Corporate Contact 1 1 Golfer 1 27 Golfer Resize the column widths so that all headings and data are visible. Save and close the table. 3 25 Use the Report Wizard to create a report. Select the LastName and FirstName fields from tblParticipants and select OrderID and AmountPaid from tblOrder. Do not apply any groupings to the report. Sort the report by OrderID in ascending order. Save the report as rptParticipantOrders. 8 26 Switch to Layout view and change the title of the report to Participants and Orders. Save and close the report. 5 27 Save and close Access_CH02_Prepare_Putts.accdb. Exit Access. Submit your files as directed. 0 Total Points 100
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.