database that can track employee insurance benef

[Julie Censke]

I am looking for suggestions on how to track employee health insurance
benefits. I'm not sure whether Access or Excel would work better. any
suggestions?

 

[John W. Vinson]

On Tue, 3 Feb 2009 07:36:01 -0800, Julie Censke <Julie

I am looking for suggestions on how to track employee health insurance
benefits. I'm not sure whether Access or Excel would work better. any
suggestions?

That's an awfully vague question! Employee health benefits is a very complex
area, and would be a totally different kettle of fish for a five-employee
storefront in Texas than for a 24,000 employee international corporation.

I suspect Access would be the better choice, but you're not going to be able
to download a template and start using it; it'll be a very substantial
programming task. Or, you may be able to purchase a "canned" third party
application for the purpose.

 

[Larry Linson]

I am looking for suggestions on how to track employee
health insurance benefits. I'm not sure whether Access or
Excel would work better. any suggestions?

Some years ago, I worked on an Access application to track employee
insurance, which had previously been done on a spreadsheet. The reason they
were doing this was that their spreadsheet approach had become very
cumbersome as the number of employees increased. It had, apparently, worked
well enough when there were only a "hanfull" of employees.

John is correct that it is not a trivial application, and that it would
differ greatly due to circumstances. I spent substantial time interviewing
the agents who provided employee insurance to companies as to what they
wanted/needed, and they had many years of experience to know the business
requirements.

The database was, as you might expect, proprietary to that client (having
that level of automation would give them a competitive advantage over other
agencies which did not have it), so I couldn't post or provide it. But, as a
matter of fact, at the conclusion of the contract, I turned all my material:
database, documentation, notes, and data over to the prime contractor,
anyway.

Larry Linson
Microsoft Office Access MVP

 

[Larry Linson]

I am looking for suggestions on how to track employee
health insurance benefits. I'm not sure whether Access or
Excel would work better. any suggestions?

Some years ago, I worked on an Access application to track employee
insurance, which had previously been done on a spreadsheet. The reason they
were doing this was that their spreadsheet approach had become very
cumbersome as the number of employees increased. It had, apparently, worked
well enough when there were only a "hanfull" of employees.

John is correct that it is not a trivial application, and that it would
differ greatly due to circumstances. I spent substantial time interviewing
the agents who provided employee insurance to companies as to what they
wanted/needed, and they had many years of experience to know the business
requirements.

The database was, as you might expect, proprietary to that client (having
that level of automation would give them a competitive advantage over other
agencies which did not have it), so I couldn't post or provide it. But, as a
matter of fact, at the conclusion of the contract, I turned all my material:
database, documentation, notes, and data over to the prime contractor,
anyway.

Larry Linson
Microsoft Office Access MVP