mdooley wrote:
I am currently trying to build an employee db of 150+ employees where, for
the most part, all HR information will be kept. Information as simple as
name, address, phone to retirement info, insurance premium changes and
tracking salary increases, etc. My first dilemma - to build one or more
tables. If I build only one table it will be very large. If I build more
than one it seems to me that there would be only one to one relationships?
The second dilemma - how I go about tracking for example pay increases. And
in the form (which I hope to be able to input all the info) how can I add the
new pay amount (in case of a raise) without overriding the previous pay
amount - so that I can track it over time. Any help is appreciated...I am
relatively new at this.


While this can be done in Access sometimes it's much more economical to
buy an off the shelf program designed specifically for your needs. If
you're just wanting to learn Access this could be a very in depth
project. OTH if you're need this right away I would look for a software
package designed for HR. One that I looked at was Softime the link is
below. It's not real expensive. You might want to take a look.

Standard disclaimer: I don't work for or am I associated with yada yada

http://www.softwaretech.com/


gls858