Results 1 to 3 of 3
  1. #1
    djspod is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2015
    Posts
    164

    Create a holiday DB for 30 employees

    Click image for larger version. 

Name:	uploadfromtaptalk1442955943564.jpg 
Views:	25 
Size:	116.9 KB 
ID:	22123

    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 Click image for larger version. 

Name:	uploadfromtaptalk1442957129176.jpg 
Views:	25 
Size:	132.6 KB 
ID:	22125

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    This is not an easy db to build, probably one of the hardest. There is good reason why most searches for Time & Attendance database return Excel examples. Most 'timesheet' paper documents do not resemble a normalized database structure. Same for a Calendar type of database, although I have seen them.
    https://www.accessforums.net/program...dar-45047.html
    http://www.access.hookom.net/Samples.htm
    https://www.microsoftaccessexpert.co...-Database.aspx

    For a 'graphical' timeline display of absences review https://www.accessforums.net/databas...ses-18459.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    djspod is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2015
    Posts
    164
    Thanks June7, I'll have a look at the links.

    Thanks for the feedback

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

Similar Threads

  1. Adding a Holiday Table
    By Holli in forum Programming
    Replies: 9
    Last Post: 06-03-2015, 02:49 PM
  2. Weekend/Holiday Exclusion:
    By DHook in forum Modules
    Replies: 5
    Last Post: 12-10-2014, 12:52 PM
  3. Replies: 2
    Last Post: 04-16-2012, 12:56 PM
  4. Payslip Holiday Pay design
    By crxftw in forum Access
    Replies: 5
    Last Post: 07-22-2011, 11:58 AM
  5. Replies: 1
    Last Post: 11-23-2010, 09:16 PM

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