Results 1 to 4 of 4
  1. #1
    moneypennie21 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    41

    Holiday & Sickness tracker

    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

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Info on Bradford Factor.
    You may find some design help/approaches in the Similar Threads at bottom of the page.
    Good luck.

  3. #3
    moneypennie21 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    41
    HI Orange,

    I did have a look at the links and couldn't find what I was looking for other than the consensus that this is complicated! I think I have found an off the shelf solution for excel that might give me what I need so will pursue that unless anyone comes up woth anything on here. I know how to calculate bradford factor just don't know how to make it work in excel doing what I need it to do.

    thanks

    J

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Good luck.
    You had a concern
    the one we have on excel is too prone to human error.
    Make sure the proposed replacement addresses all your current (and envisioned) concerns.

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

Similar Threads

  1. Create a holiday DB for 30 employees
    By djspod in forum Database Design
    Replies: 2
    Last Post: 09-22-2015, 03:51 PM
  2. Adding a Holiday Table
    By Holli in forum Programming
    Replies: 9
    Last Post: 06-03-2015, 02:49 PM
  3. Replies: 5
    Last Post: 03-16-2015, 10:17 PM
  4. Replies: 1
    Last Post: 04-01-2014, 10:54 AM
  5. function for national holiday
    By barkarlo in forum Access
    Replies: 0
    Last Post: 12-18-2006, 03:39 PM

Tags for this Thread

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