By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,160 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

keeping record of employee work history

P: 2
Hi Guys,
I am tasked to keep records of our employees which we are required to refer to time and again.
for example;
Bob currently works in a warehouse in organisation x
Bob has worked in the register
Bob has also worked in a customer service centre within the same organization x.
i want my access to display bob and other employees current work.
i also want to be able to refer to Bobs work history i.e all the places he has worked.
How can i achieve this in access. I'll be grateful for your assistance.
Nov 22 '16 #1
Share this Question
Share on Google+
2 Replies


PhilOfWalton
Expert 100+
P: 1,430
You need 4 tables
Expand|Select|Wrap|Line Numbers
  1. TblEmployees
  2.     EmployeeID         Autonumber
  3.     EmployeeSurName    Text
  4.     EmployeeFistName   Text
  5.     etc.
  6.     .....
  7.  
  8. TblJobs
  9.    JobID               AutoNumber
  10.    JobDescription      Text  (No Duplicates)
  11.    etc.
  12.    ....
  13.  
  14. TblOrganisations
  15.    OrganisationID     AutoNumber
  16.    Organisation       Text  No Duplicates
  17.    etc.
  18.    ....
  19.  
  20.  
  21. TblJoinEmployeeJob
  22.    EmployeeID         Long   Joint Key
  23.    JobID              Long   Joint Key
  24.    OrganisationID     Long   Joint Key
  25.    FromDate           Date   Joint Key
  26.    ToDate             Date
  27.  
That way any employee can be linked to any job with start dates & end dates and which organisation he is working for.

Yo will probably need additional checks that the person not doing more than 1 job on a particular date

Phil
Nov 22 '16 #2

P: 2
Thanks Phil. let me try this one and revert
Nov 22 '16 #3

Post your reply

Sign in to post your reply or Sign up for a free account.