Results 1 to 2 of 2
  1. #1
    KimNolan is offline Novice
    Windows 7 32bit Access 2016
    Join Date
    Aug 2016
    Posts
    1

    Managing schedules and paid time off. Can Access do something like this?

    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.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Yes, access can do this. I HAVE done this. But this may a bit daunting for a beginner.
    it would be a great project to learn tho. Building the db to your needs will teach you a lot.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 07-09-2015, 02:15 PM
  2. Calendar to show employee schedules
    By Astron2012 in forum Access
    Replies: 1
    Last Post: 03-28-2012, 03:29 PM
  3. Paid time off database
    By roger556 in forum Access
    Replies: 84
    Last Post: 01-03-2012, 01:20 PM
  4. Managing Point in Time
    By Stressed in forum Database Design
    Replies: 1
    Last Post: 03-09-2010, 07:55 AM
  5. Managing Point in Time
    By Stressed in forum Programming
    Replies: 0
    Last Post: 03-01-2010, 08:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums