Remove duplicate employee ids from the employee extract

Assignment Help Database Management System

Reference no: EM131600955

1. Using the "Employee Extract" tab as your primary working sheet, bring in the "earliest retirement date" field and the "division" field into the tab.

2.Remove duplicate Employee ID's from the "Employee Extract" tab.

3. In the "Employee Extract" tab "retirement bracket column" assign retirement brackets based on the retirement dates provided(i.e. within 1 year, etc...). The determination of each bracket is up to you. NOTE: Think about brackets that would be useful on a report for an executive summary.

4. Using the "Employee Extract" tab and your new retirement brackets, create a pivot table to summarize retirement brackets by division and headcount. Please ensure your pivot table is on a new tab named "Pivot Table"

5. Using the results from the pivot table, please put together a few slides in powerpoint summarizing your findings. Feel free to incorporate tables/charts into your summary.

Attachment:- table.rar

Reference no: EM131600955

Questions Cloud

Problem related to the coin tossed straight up into the air : A coin which is tossed straight up into the air. After it is released it moves upward, reaches its highest point and falls back down again.

Calculate equilibrium output market price of wood : Assuming that each small firm acts as a price taker and that collectively they act as a "competitive fringe "(CF). Determine the (aggregate) supply curve.

Analysis offers over traditional ratio analysis : What is an advantage that the Du-Pont system of analysis offers over traditional ratio analysis?

Discuss general and specific guidelines of probation : As the result of a plea deal offered by the prosecutor, Smith will plead guilty to Criminal Trespass and Public Intoxication

Remove duplicate employee ids from the employee extract : Using the "Employee Extract" tab as your primary working sheet, bring in the "earliest retirement date" field and the "division" field into the tab.

What monthly payments must he make : John owes $20,000; the credit card company charges him 1.5% per month on this debt. what monthly payments must he make?

Indicative of more complicated ones : Consider a proportional sales tax and a progressive sales tax. How do the tax revenues, and quantities produced compare in these various cases?

How much did darryl have in his account at first : Darryl has $7700 in his investment acoount after a year. He earned 10% of it as interest. How much did he have in his account at first?

Firm sending when it decides to advertise : What signals are a firm sending when it decides to advertise? What promises is the firm implicitly making to the audience for the advertising?

User Account

All Pages