Re: Template or HELP wRelationships

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

"John W. Vinson" wrote:

On Mon, 18 Feb 2008 18:19:01 -0800, Maj <Maj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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.
--
John W. Vinson [MVP]

.

Relevant Pages

  • Re: Template or HELP wRelationships
    ... reports to (another EmpID), ... ... PositionID, Job Title, Reports to another PositionID code... ... TRANSACTIONS: Event Date, New Salary, Reason for Change (for tracking new ... the transactions table clearly pertains to an employee... ...
    (microsoft.public.access.gettingstarted)
  • Re: Still Struggling...
    ... means "Find the first record in the RecordsetClone in which EmpID is the ... Each employee can only have 1 classification (Admin., ... tblClassifications 1:M tblEmployees, ... tblTitles M:M tblTitlesEmps ...
    (microsoft.public.access.gettingstarted)
  • Re: Extract Outlook Address book properties into Excel
    ... Michael Bauer - MVP Outlook ... I think since the Employee names & Emp Code belongs to a Global Address ... Custom-defined type like EmpID. ... Dim xl as Excel.Application ...
    (microsoft.public.outlook.program_vba)
  • Re: Multiple fields using to search
    ... Hey John! ... This command button was simply created with the 'Open Form' wizard HOWEVER in ... Does your table contain the actual employee and city NAMES? ... to both the lst boxes in a new form called frmSearchResult. ...
    (microsoft.public.access.forms)
  • Re: Strange Fields in Access
    ... John, I started this db in 1999 when I started to work for my present ... They had no computer related way of tracking employee information ... "John W. Vinson" wrote: ... and look in the Lookup tab of the field properties on ...
    (microsoft.public.access.tablesdbdesign)