Hi,
I am thinking about designing a database to track sickness and holiday for my department as the one we have on excel is too prone to human error. I need it to be able to calculate days renaming, bradford factor points based on sickness absence only and show calendars with employee leave dates on for managers - run reports etc.
does anyone have anything similar they are willing to share or point me in the right direction with how to set this up, so far I know I'll need an employee details table, absence reason table, data entry form, and leave days taken table or similar. I don't want to spend ages on it and find out I have done it all wrong. I am not an access expert but can execute instructions if explained well!
Any thoughts ideas appreciated.
J