Is Access a practical solution for an HR database?

  • Thread starter Thread starter Guest
  • Start date Start date
Yes, Access can be used quite nicely for an HR database. I did a google
search, and found there are many companies that are willing to sell you the
rights to use their HR database software. I did not see anything resembling
a sample program. This is probably because HR is a complicated field, and it
takes a lot of effort to put together a decent database for a specialized
application like that.

No matter what you use for an HR database, you should put the computer(s)
that run the database behind a hefty firewall, or better yet, not have them
connected to the outside world at all. HR information is very sensitive, and
should be protected. Just putting passwords on a server share, or on the
database, is not enough.
 
How about Time Tracking for the hours worked in a pay period...do you have
anything on that?
 
Thanks Bob. I appreciate your answer and work and your willingness to share
your table designs. I am definitely interested. I am working against a time
constraint and while endeavoring not to recreate the wheel. I was hoping
that there is a downloadable sample(s) on the web, but there are none that I
could find. In that regard, I would like to see if your table designs fit
the parameters of the departmental database that we're trying to create.
There is a corporate database, but it is too extensive for our
inter-departmental needs.

Within the department we want to track: basic employee data, performance
review/evaluations, disciplinary actions/improvement program, reminders,
emergency info, and notes.

If you have any tables that fit these categories, I am grateful to you for
sharing it with me. I will also email you at the address you provided.
Thanks again Bob!
 
Back
Top