This is a follow-up project from the assigned Access projects using PrattLast As

Question

This is a follow-up project from the assigned Access projects using PrattLast Associates (the same company used in the Access exercises) Assignment The Account Manager with the lowest compensation (as defined by Salary plus Bonus Rate) has left the organization. The replacement Account Manager has been hired and her information is listed below: Account Manager Number: 64 Last Name: White First Name: Betty Street: 123 Main Street City: Oakland State: CA Postal Code: 94609 Start Date: 5/5/2017 Salary: $41,000.00 Bonus Rate: 0.12 You have been assigned to transfer Accounts from the Account Manager who is leaving to Betty White You must produce the following outputs 1. An Excel workbook that shows the original Account Table spreadsheet in the first tab and the revised Account Table spreadsheet with the Accounts reassigned to Betty White in the second tab. 2. A letter to all the Account Managers announcing the departure of one Account Manager (include that person's name in your letter) and welcoming Betty White to the team. The letter should be written in Word and in a business format. 3. A PowerPoint slide presentation that has the following: a. Title slide b. One slide for each Account Manager listing their Accounts c. A slide listing "Questions & Answers in the center of the slide d. A slide listing "The End" in the center of the slide 4. An Access program update that adds "Betty White" as the new Account Manager and the appropriate Accounts assigned to her.

Explanation / Answer

The assignment asks you to do 4 things -

1. The account manager with lowest compensation has left the company.
Being an account manager, he was handling the some of the accounts of the company.

The task is to assign those accounts from this person to Betty White.

To do this, you need to provide a Excel Workbook. The sheet 1 of this workbook
will have Original Account table.
This account table "may have" details of Account Manager and there accounts details.

The second sheet should have the revised account table with updated Account Manager details.

2. Send out a letter to the team.

3. prepare PPT as said in the question.

4. Once you have updated Excel sheet, you need to update the Access which has all the
database for the company.
So, a program should be written to add Betty White as a new Account Manager replacing the
person who left.

  

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.