Greetings,
I am by my TL to develop an Recruitment Tool in Access. I tried to make tables and other stuff. But, am not able to find a proper data model. Can any one suggest me a good data model or if any working recruitment sample if possible.
Here are some basic needs:
* When a Candidate Sends his/her resume, our HR will store all the required information in the table let's say "Candidates"
* Once an Interview over, the HR will input their comments and change the status whether selected or not. let's say table : Interview Details
* Others tables should be Interviewers table (as we have more than 10 interviewers from different teams), Team Table, Sub Team Table, Current Opening Jobs.
I am struck in relating all the tables. Please some one guide me.
Thank you in advance,
Regards,
I am by my TL to develop an Recruitment Tool in Access. I tried to make tables and other stuff. But, am not able to find a proper data model. Can any one suggest me a good data model or if any working recruitment sample if possible.
Here are some basic needs:
* When a Candidate Sends his/her resume, our HR will store all the required information in the table let's say "Candidates"
* Once an Interview over, the HR will input their comments and change the status whether selected or not. let's say table : Interview Details
* Others tables should be Interviewers table (as we have more than 10 interviewers from different teams), Team Table, Sub Team Table, Current Opening Jobs.
I am struck in relating all the tables. Please some one guide me.
Thank you in advance,
Regards,