Hi,
I would like some help or guidance on a DB table structure for a holiday database.
Ideally I would like the end user to have visual but restricted view of what weeks and days are available.
Team Manager to be able to book the holiday and update the employees file record, taken holidays and remaining.
Incorporating Days in lieu, acrued dates and taken for each employee.
A printable report for their hard copy file to store with their holiday request forms.
Functionality for a Team Manager to view and plan a rota from what staff are in or on holiday by choosing a week commencing date.
I currently have a DB with all the staff in, Shift patterns, Shift Rotation and the functionality to pull a report off any week to display who is on shift.
I would now like to do away with Excel altogether and alginate all items into one DB.
I have attached a Access report and an excel spreadsheet form we currently use to print off.
I can attach the current DB if requested
Thanks in advance