We are looking for a solution to our administrative nightmare of managing schedules and paid time off. I have no knowledge of Access, but was wondering about the capabilities to see if we could build something to suit our needs.
Currently we use Staff Files, When to Work, paper slips, and a few excel spreadsheets to manage schedules and time off, but it's not very accurate and very time consuming. We have approximately 25 employees that are in 4 different categories, accrue time at 4 different levels and all have different schedules. What we'd like to do is find some way to manage accruals, enter requests, get status by date, balances, convert days to hours, and have this all linked to a calendar to show who's on at what time. It's a very complicate scenario, and I can go into more detail if needed. I just know nothing about Access and was curious to see if this might be a viable solution. Any help or suggestions would be very much appreciated! Thanks for your time.