I am new to Microsoft Access and need to develop a database to track positions within my company. To elaborate in more detail, I need to be able to identify all active positions within the company as well as inactive (vacant) positions. Then, I need to show which employee within my company currently holds that position as well as the movement when an employee vacates the position and either moves into another position or separates from the company altogether. This information would be used to calculate the vacancy and turnover ratio for each department and company-wide.
I guess I am a little puzzled as to what type of tables I need to setup and the content that should be contained in each. Currently I have a table set up for Employees, Jobs, Department, and Location. But, I'm not quite sure how to track the effective dates of when a position is vacated and when it is filled.
Any assistance that can at least get me started would be helpful.