Template or HELP wRelationships

[Maj]

In search for an Access template to create an EMPLOYEE DATABASE
EMPLOYEE TABLE: EmpID, date of birth, status, category, positionID, date of
hire... reports to (another EmpID), ...
POSITIONS TABLE: PositionID, Job Title, Reports to another PositionID code...
TRANSACTIONS: Event Date, New Salary, Reason for Change (for tracking new
job titles, wage increases...)
BENEFITS: Effective Date, Medical Plan, Medical Coverage, Dental...
Vision... Life...

(Relationships are a mystery!) Any direction and guidance -- greatly
appreciated!
or if you can help please email me at marie dot johnson at argonmedical dot
com

 

[John W. Vinson]

In search for an Access template to create an EMPLOYEE DATABASE
EMPLOYEE TABLE: EmpID, date of birth, status, category, positionID, date of
hire... reports to (another EmpID), ...
POSITIONS TABLE: PositionID, Job Title, Reports to another PositionID code...
TRANSACTIONS: Event Date, New Salary, Reason for Change (for tracking new
job titles, wage increases...)
BENEFITS: Effective Date, Medical Plan, Medical Coverage, Dental...
Vision... Life...

(Relationships are a mystery!) Any direction and guidance -- greatly
appreciated!
or if you can help please email me at marie dot johnson at argonmedical dot
com

Check out the tutorials at

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

In a nutshell, you need "Foreign Keys" to link the tables. A Transaction in
the transactions table clearly pertains to an employee... right? Therefore you
need an EmpID in the Transactions table as a pointer to the Employee table to
indicate whose salary is changing. The same would apply to Benefits.

You'll want several forms with subforms to manage the data.

Note that there are LOTS of commercial human-resources databases out there; it
may be false economy to reinvent the wheel by developing your own. On the
other hand, if you do you'll get one that fits your business model better.

 

[Daoud Fakhry]

Dear Marie,
I have the same problem. I developed one database which is very basic. My
one will be a little bit different. I am using this for my company in
Afghanistan and the tax calculation method is quite different.

You can send you database to my personal ID (e-mail address removed) I will have a
look at it, I may help you in this regard.

Thanks
Daoud Fakhry

 

[Maj]

Thank you, John, I will follow your instructions; words of wisdom and
guidance are much appreciated.

 

[Maj]

Daoud, thank you for your kind offer! If it's okay, I will get back with iyou
in two weeks with a clearer understanding, after I've gone through the
resources and tutorials that John suggested. Thank you for your assistance;
it's much appreciated!