Microsoft Excel/Access Activity

User Generated

znqqvr20s

Business Finance

Description

This Microsoft Excel/Access activity contains a set of instructions and an Excel worksheet to transfer those instructions to, as well as an Access database. Please be sure to make all edits on the documents that I provide you with. It is hard to grade if you try to make your own document. Thank you.

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions Excel Project YO_Excel16_Ch09_PS1_v2 Project Description: Joe Nelson has a small sports equipment store that has a growing list of customers. The different supervisors have been saving customer information in different formats. Joe would like to have all the data in an Excel spreadsheet. He has asked you to take on the task of getting the data together and putting them in the formats he would like for his planned marketing effort. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Points Possible Instructions 1 Start Excel. Open the downloaded workbook named e05ch09_grader_h1_start.xlsx. Save the file with the name e05ch09_grader_h1_LastFirst, using your last and first name. If necessary, enable content. 0 2 Import the data from the query qryCustomer in the e05ch09SportsCustomers.accdb database into the CustomerDatabase worksheet in cell A2. 15 3 In cells C2:I2, type the following column headings: Clean Name, First Name, Last Name, Street Address, City, State, Full Name. 8 4 In cell C3, use the CLEAN and TRIM functions to remove any nonprintable characters and extra spaces from the name in column A. Resize the column as needed to fit the contents 10 5 In cell D3, use the RIGHT, LEN, and FIND functions to extract the first name from column C. Use the PROPER function to ensure that all first names are in the appropriate case. Resize the column as needed to fit the contents. 12 6 In cell E3, use the LEFT and FIND function to extract the last name from column C. Use the PROPER function to ensure that all last names are in the appropriate case. Resize the column as needed to fit the contents. 12 7 In cell F3, use the LEFT and FIND function to extract the street address from column B. Use the PROPER function to ensure that all street names are in the appropriate case. Resize the column as needed to fit the contents. 12 8 In cell G3, use the MID, LEN, and FIND functions to extract the city name from the address in column B. Resize the column as needed to fit the contents. 15 9 In cell H3, use the RIGHT function to extract the state from the address in column B. Resize the column as needed to fit the contents. 8 In cell I3, use concatenation to put the customer first name and last name together with a space in between. Resize the column as needed to fit the contents. 8 10 Updated: 05/23/2018 1 Current_Instruction.docx Office 2016 – myitlab:grader – Instructions Step 11 Excel Project Points Possible Instructions Save the workbook. Close the workbook. Exit Excel. Submit the workbook as directed. 0 Total Points Updated: 05/23/2018 2 100 Current_Instruction.docx Joe's Sports Equipment Supply 20180616152139e05ch09_grader_h1_fernandezcynthia.xlsx 20180616152139e05ch09_grader_h1_fernandezcynthia.xlsx
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

The solution is in the attached zipped file.There are so many ways...


Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags