Lost! And no one else has this need!

[Guest]

I am trying to get a concept /template for an employee database to store
basic employee information and then track employee insurance benefits - for
example they have plan # 1 Employee + Spouse and the cost is 0.00.
I have medical insurance, vision, dental, life, std, aflac etc etc...
And then i have Employee only Employee + Spouse.. I am wondering how should
I setup so that I could run reports based on the the payroll deductions for
each employee.. or show just employees wtih medical insurance or I have no
idea!! Any one out there a genius???

 

[Guest]

Sorry, you got no genius here but I'm just a little ahead of you in setting
up a database. What has helped me most, aside from the generosity of
strangers in this forum has been the training section of the Access (2003-for
me) area. probably the table section would be most helpful to you along with
indexing. Anything you can index, you can easily report. You can let Access
assign id numbers or assign them yoursef and it's supposed to be the primary
key. Index your employees and the various types of coverage (in separate
tables) and you've got sorting and grouping strength on your side.
Something Like:
EmployeeID Name
(or you may already have employee #s assigned)
EMP1 Larry
EMP2 Moe
EMP3 Curly

InsID Coverage Type (pick better field names than here)
Cov1 MedEmpOnly
Cov2 MedEmpSpouse
Cov3 MedEmpFam
Cov4 DentEmpOnly
Cov5 DentempSpouse .....and so on

Check out those training sessions and start at the beginning. If it's
something you already know thoroughly, just skim it. A little refresher will
clear the brain.

Ferry Mary




Check out the training pages and good luck.