he North Carolina Arboretum maintains an Access database that contains a Friends table of…

he North Carolina Arboretum maintains an Access database that contains a Friends table of individuals who have donated cash, gifts, volunteer service, and “in-kind” gifts. In addition, the database contains a query that selects friends who have greater than 0 hours for volunteer work. As the assistant to the manager, you want to manage the data in an Excel workbook where you can control case. In addition, the person who originally created the database table violated good database design by combining the city, state, and zip codes in one field in the query. You want to separate those in the Excel workbook.

a. Use Windows Explorer to create a copy of e09m1arbor database. Rename the copied file e09m1arbor_LastnameFirstname.

b. Start a new Excel workbook, and then save it as e09m1arbor_LastnameFirstname. Import the Access database e09m1arbor_LastnameFirstname, and then select the Volunteer Invitations query as the data source. Import the data so that it is linked to the original database query.

c. Rename Sheet1 Original, and then rename Sheet2 Update. Delete Sheet3. Type the following column labels in row 1 of the Update sheet: Names, Addresses, City, State, Zip. Bold and center the column labels.

d. Insert a nested function in the first column of the Update worksheet to display the title, first name, middle name (if applicable), and last name in one cell for each person, such as Mrs. Dale W. Holbrook. The nested IF function should not have extra space between the first and last names if a middle name is empty. The nested functions should reference cells in the Original sheet.

e. Insert a function in the second column of the Update worksheet to echo the addresses from the Original sheet but to display the text where the first letter of each word is capitalized.

f. Copy the CityStateZip data from the Original worksheet, and then use Paste Special to paste the data as values in the third column of the Update worksheet. (Although this approach does not update from the first sheet, it does enable you to practice separating data in the next step.)

g. Convert the copied CityStateZip data into three separate columns in the Update worksheet. Select the appropriate delimiter. The Update worksheet should have five columns. Adjust column widths appropriately.

h. Save and close the Excel workbook. Open e09m1arbor_LastnameFirstname.accdb in Access, and then run the Volunteer Invitations query. Find last names in all capital letters and replace them with initial capital letters in the query’s Datasheet view. For only the people who were missing titles, enter titles in the query’s Datasheet view. Close the Access database.

i. Open the e09m1arbor_LastnameFirstname workbook, and refresh the data connection. (This will fill in the missing titles and display all last names in initial capital letters.)

j. Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side.

k. Save and close the workbook, and submit based on your instructor’s directions.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyhomeworkGeeks
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Classic English Literature
It was my first time using such a service. Essay was good and nicely formatted.
Customer 452441, February 16th, 2022
Education
Very fast response and did a excellent job.
Customer 453201, May 31st, 2022
Human Resources Management (HRM)
My son and I have been sick for two weeks, of course at the end of my semester. I am so grateful that myhomeworkgeeks were able to help! Both papers got A's and I couldn't be more thrilled! Thank you so much and don't forget to tip your writer!
Customer 453077, February 22nd, 2022
Social Work and Human Services
Great work I would love to continue working with this writer thought out the 11 week course.
Customer 452667, May 30th, 2021
Health Care
awesome work
Customer 452777, October 14th, 2021
Nursing
Usually, references need to be within the past 5 years. Thank you :)
Customer 452547, July 16th, 2021
Economics
Nice work
Customer 453185, May 21st, 2022
Nursing
I just need some minor alterations. Thanks.
Customer 452547, February 10th, 2021
Business Studies
Thank you very much for a good job done and a quick turn around time.
Customer 452615, March 31st, 2021
English 101
great summery in terms of the time given. it lacks a bit of clarity but otherwise perfect.
Customer 452747, June 9th, 2021
Nursing
It was a very long paper, but she followed all the instructions, and she even finished the paper 5 days before the due date. Will write an essay with her again, thanks!
Customer 452967, November 27th, 2021
Criminal Justice
This has been the greatest help while I am recovering from an illness. Thank your team so much.
Customer 452671, May 2nd, 2021
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Live ChatWhatsApp

Are You Looking For Assignment Help? We Can Certainly Assist You