Employee Database Structure Including Historical Data

I plan on creating a datuabase and I know the most important step is the
design. Currently, my staff uses the fields below in Excel and repeats the
data on additional worksheets for different views (alpha, seniority report,
grandfather report, etc. and updates each sheet with new data. I'd like to
use access - I think you would agree. (Fringe Hours are hours expected to
work - some people work 2 hrs, some 3.5, etc.) Below are the current fields:

Last Name, First Name, Emp #,Birth Date,Hire Date,Term. Date,Social Security
#,Telephone #,Address, City, State, Zip, Cell Phone #, Last Name, First Name,
Class 7-1-07, Rate 7-1-07, School 7-01-07, Fringe Hours 07-01-07, Class
7-1-08, Rate 7-1-08, School 7-01-08, Fringe Hours 07-01-08, Class 7-01-09,
Rate 7-01-09, School 7-1-09, Fringe Hours 07-01-09.

Staff may start out as a substitute and change jobs at any time or change
Fringe at any time if a position with more hours opens up. Employees make
one pay scale for the first 4 years and become grandfathers the 5th year to a
different pay scale (25% more). Managers start at 90% of their Salary 1st
year, 95% 2nd year, 100% 3rd year.

Also the following data is kept on an actual index card (along with name,
address, phone, id#, start date:
Date School Fringe Hours Class Rate Note
11/28/05 Substitute Sub 9.00/hr
7/1/05 MP 3.5 F1 10.50/hr
9/22/05 MP 3.5 F1 11.06/hr
7/1/06 MP 3 F4 11.74/hr
3/18/06 MP 3 F4 15.66/hr
Grandfathered
7/1/07 MP 3.5 F4 16.69/hr
8/27/07 Buc/Mil 6.5 Mgr 25,425/yr
90%
7/1/08 Buc/Mil 6.5 Mgr 27,727/yr
95%
7/1/09 Buc/Mil/Evt 7.5 Mgr 31,585/yr 100%

I'm not certain how many tables I need or how the historical data would work
for reporting purposes.

Thanks for your help,
Marie

Check out this discussion forum site for tutorials (the 'sticky' threads at
the top):
http://forums.aspfree.com/microsoft-access-help-18/
Attempt a design then post for analysis.

Marie Wallace wrote:
I plan on creating a datuabase and I know the most important step is the
design. Currently, my staff uses the fields below in Excel and repeats the
data on additional worksheets for different views (alpha, seniority report,
grandfather report, etc. and updates each sheet with new data. I'd like to
use access - I think you would agree. (Fringe Hours are hours expected to
work - some people work 2 hrs, some 3.5, etc.) Below are the current fields:

Last Name, First Name, Emp #,Birth Date,Hire Date,Term. Date,Social Security
#,Telephone #,Address, City, State, Zip, Cell Phone #, Last Name, First Name,
Class 7-1-07, Rate 7-1-07, School 7-01-07, Fringe Hours 07-01-07, Class
7-1-08, Rate 7-1-08, School 7-01-08, Fringe Hours 07-01-08, Class 7-01-09,
Rate 7-01-09, School 7-1-09, Fringe Hours 07-01-09.

Staff may start out as a substitute and change jobs at any time or change
Fringe at any time if a position with more hours opens up. Employees make
one pay scale for the first 4 years and become grandfathers the 5th year to a
different pay scale (25% more). Managers start at 90% of their Salary 1st
year, 95% 2nd year, 100% 3rd year.

Also the following data is kept on an actual index card (along with name,
address, phone, id#, start date:
Date School Fringe Hours Class Rate Note
11/28/05 Substitute Sub 9.00/hr
7/1/05 MP 3.5 F1 10.50/hr
9/22/05 MP 3.5 F1 11.06/hr
7/1/06 MP 3 F4 11.74/hr
3/18/06 MP 3 F4 15.66/hr
Grandfathered
7/1/07 MP 3.5 F4 16.69/hr
8/27/07 Buc/Mil 6.5 Mgr 25,425/yr
90%
7/1/08 Buc/Mil 6.5 Mgr 27,727/yr
95%
7/1/09 Buc/Mil/Evt 7.5 Mgr 31,585/yr 100%

I'm not certain how many tables I need or how the historical data would work
for reporting purposes.

Thanks for your help,
Marie

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200908/1