Need help with this project on access that combines excel

Anonymous
timer Asked: Nov 2nd, 2017
account_balance_wallet $35

Question Description

I have tried to figure out how to do this assignment but to no prevail. I am a bit stuck and would love some help on the transferring of information and following the necessary steps in order to do the project. I have attached all the docs which are needed for the project. The est time they said should only take 1-2hours.

Unformatted Attachment Preview

ParticipantID 50 51 52 53 54 55 56 57 LastName Druplet Maestas Marquardt Nelson Nelson Romero Thomas Thomas FirstName Brenda Marcus Keith Kris Rodney Maria Joe Lois StreetAddress 1522 Watson Ln 83 Vuelta Rancho 228 E Alejo Rd 915 Somerset Ln 915 Somerset Ln 819 Calle Don Roberto 4355 Celsior St 4355 Celsior St City Las Cruces Santa Fe Palm Springs Las Cruces Las Cruces Santa Fe Brougham Brougham State NM NM CA NM NM NM CA CA ZipCode 88001 87508 92262 88018 88018 87502 92267 92267 ContactPhoneN umber (505) 555-1835 (505) 555-2525 (760) 555-4836 (505) 555-4103 (505) 555-3237 (505) 555-3242 (209) 555-3227 (209) 555-3227 CorporatePhoneNu mber (505) 555-1800 (505) 555-1800 Office 2016 – myitlab:grader – Instructions Your Office - Access Chapter 2: Prepare Case YO16_AC_CH02_GRADER_PC_HW - Red Bluff Golf Course Putts for Paws Charity Tournament 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. 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 a01ch02_grader_pc_Putts.accdb. Save the file with the name a01ch02_grader_pc_Putts_LastFirst, using your last and first name. If necessary, enable the content. 0 2 Open the downloaded Excel file, a01ch02_grader_pc_PuttsGolf, copy the contents of cells A1:I9 and paste the contents into the tblParticipant table as new records. Close Excel and close tblParticipant. 5 3 Import the records on the Corporate contacts worksheet from the downloaded Excel file, a01ch02_grader_pc_PuttsCont, into the tblPartcipant table. 5 4 Import the records in the Volunteers named range from the downloaded Excel file, a01ch02_grader_pc_PuttsVol, into the tblParticipant table. 5 5 Import the records from the downloaded tab delimited text file, a01ch02_grader_pc_PuttsDon, into the tblParticipant table. Be sure to indicate that the first row contains field names. 5 Add a new record to the tblParticipant table using the following data. 6 ParticipantID 62 LastName Gupta FirstName Sanjay StreetAddress 3544 Cornice Blvd City Las Cruces State NM ZipCode 88001 ContactPhoneNumber 5055557789 CorporatePhoneNumber (leave blank) 4 Close the tblParticipant table. Updated: 05/26/2016 1 YO16_AC_CH02_GRADER_PC_HW_Instructions.docx Office 2016 – myitlab:grader – Instructions Your Office - Access Chapter 2: Prepare Case Step Points Possible Instructions 7 Delete the record for Kate Neidhart, ParticpantID 11, from the tblParticipant table. 3 8 Delete the CorporatePhoneNumber field from the tblParticipant table. Close the tblParticipant table. 3 Create a new table in Design View with the following fields. 9 Field Name CompanyName StreetAddress City State ZipCode PhoneNumber Data Type Short Text Short Text Short Text Short Text Short Text Short Text Field Size 50 40 40 2 10 14 6 Add a description to the CompanyName field of Name of the company (no period). 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 Switch to Datasheet view of the tblCorporate table and add a new record to the table using the following data. 13 CompanyName StreetAddress City State ZipCode PhoneNumber Tesuque Mirage Market 8 Tesuque Mirage Rd Santa Fe NM 87506 5055551111 4 Resize the column widths so that all headings and data are visible. Save and close the table. 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). Updated: 05/26/2016 2 3 YO16_AC_CH02_GRADER_PC_HW_Instructions.docx Office 2016 – myitlab:grader – Instructions Your Office - Access Chapter 2: Prepare Case Step Instructions Points Possible 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 05042018 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 tblParticipant table to the window. Create a relationship between tblParticipant and tblOrder and enforce referential integrity. Save and close the Relationships window. 4 Create a new table in Design View that will serve as a junction table for the many-to-many relationship with the following fields. 20 Field Name ParticipantRoleID CorporateID ParticipantID Role Data Type AutoNumber Number Number Short Text Field Size Long Integer Long Integer Long Integer 40 5 Designate the PartipantRoleID field as the Primary Key and enter a description of Primary key for tblParticipantRole (no period). Save the table as tblParticipantRole. Close the table. 21 Open the Relationships window. Add the tblCorporate and tblParticipantRole tables to the window. Create a relationship between the tblParticipant and tblParticipantRole tables and enforce referential integrity. 4 22 Create a relationship between the tblCorporate and tblParticipantRole tables and enforce referential integrity. 4 23 Create a Relationship Report, accepting the default name. Save and close the Relationship window. 4 Open the tblParticipantRole table in Datasheet view and enter the following records. 24 CorporateID 1 Updated: 05/26/2016 ParticipantID 5 Role Corporate Contact 3 3 YO16_AC_CH02_GRADER_PC_HW_Instructions.docx Office 2016 – myitlab:grader – Instructions Step Your Office - Access Chapter 2: Prepare Case Points Possible Instructions 1 1 1 26 Golfer Golfer Resize the column widths so that all headings and data are visible. Save and close the table. 25 Use the Report Wizard to create a report. Select the LastName and FirstName fields from tblParticipant 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 Close the database, and then exit Access. Submit the database as directed. 0 Total Points Updated: 05/26/2016 4 100 YO16_AC_CH02_GRADER_PC_HW_Instructions.docx ParticipantID 40 41 42 LastName Levant Dearman Reed FirstName Ronald Seth Thomas CorporatePhoneNumber (505) 555-1200 (505) 555-1000 (505) 555-2000 StreetAddress 672 N Mesquite St 1717 Junior Hills Rd 743 Windstone Dr. City Las Cruces Santa Ana Pueblo Albuquerque State NM NM NM ZipCode 88001 87044 87105 ContactPhoneNumber (505) 555-3878 (505) 555-9217 (505) 555-7943 ParticipantID LastName FirstName ContactPhoneNumber 32 Ortiz Luis 1801 Brilliant Sky Dr 33 Ramirez Alice 124 Nana Lou St. 34 Victor Lisa 988 Elguitarra Rd StreetAddress City Santa Fe Avondale Santa Fe 87508 (505) 555-1722 81022 (719) 555-9247 87507 (505) 555-2757 NM CO NM State ZipCode ...
Purchase answer to see full attachment

Tutor Answer

Ace_Tutor
School: Carnegie Mellon University

hi, I am done with my answer and attached

1. The name of the MS Access file is changed to a01ch02_grader_pc_Putts_LastFirst.

2. The contents of cells A1:I9 and paste the contents into the tblParticipant table as new records,
and the screen shot is shown below:

3. The records on the Corporate contacts worksheet from the downloaded Excel file are
inputted into Access, and the screenshot is shown below:

4. The records in the Volunteers named range from the downloaded Excel file are inputted into
Access, and the screenshot is shown below:

5. The records from the downloaded tab delimited text file are inputted into the into the
tblParticipant tabl...

flag Report DMCA
Review

Anonymous
awesome work thanks

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors