I just have a quick question for you. I am looking to completely redo the attendance database for my department. I was wondering if anyone had any examples that I could look at. I need something that will track sick days and vacation days for each individual in the department. Any suggestions or advice you can provide would be greatly appreciated.
Question Attendance Databases
- Thread starter LadyDi
- Start date
Those kind of databases are the type you would normally pay for. I doubt you would find sample dbs on here but feel free to have a good look in the Sample Databases section, you might be in luck. 
I think you should start working on it and if you need clarification on a specific subject or need some help just post a thread.
I think you should start working on it and if you need clarification on a specific subject or need some help just post a thread.
jagstirling
Registered User.
- Local time
- Today, 23:17
- Joined
- Oct 12, 2006
- Messages
- 78
You might want to check out this link;
http://office.microsoft.com/en-us/e...to-track-employee-attendance-HA001221681.aspx
http://office.microsoft.com/en-us/e...to-track-employee-attendance-HA001221681.aspx
It seems to be an Excel solution? Non relational db springs to mind but it could be a good start.
McSwifty
Registered User.
- Local time
- Tomorrow, 10:17
- Joined
- Jan 14, 2010
- Messages
- 67
Hi LadyDi,
I hope you are still trying to work through the project.
I used the one attached here as my starting point and it helped a huge amount to give ideas and made a great starting point for me.
http://www.access-programmers.co.uk/forums/showthread.php?t=154067
HTH
I hope you are still trying to work through the project.
I used the one attached here as my starting point and it helped a huge amount to give ideas and made a great starting point for me.
http://www.access-programmers.co.uk/forums/showthread.php?t=154067
HTH
Poppa Smurf
Registered User.
- Local time
- Tomorrow, 08:17
- Joined
- Mar 21, 2008
- Messages
- 448
I created one for my department for over 600 employees. This is used as an attendance management system to monitor the number of unscheduled leave e.g. Sick leave, Carer's leave etc.
This is the work flow:
1. At the start of each shift each employee signs the attendance sheet.
2. The next day their attendance is recorded by the staffing section in a database located in our head office. If a staff member is absent then the record is flag as USL for unscheduled.
3. When an employee submits a leave application for that date the type of leave in the database is updated to show the type of leave taken for that absence.
4. Each month I download the attendance data from the central server to produce various reports showing the number of days for a selected leave type for all staff or selected staff over a rolling 6 or 12 months period.
If you require more information please contact me off list.
This is the work flow:
1. At the start of each shift each employee signs the attendance sheet.
2. The next day their attendance is recorded by the staffing section in a database located in our head office. If a staff member is absent then the record is flag as USL for unscheduled.
3. When an employee submits a leave application for that date the type of leave in the database is updated to show the type of leave taken for that absence.
4. Each month I download the attendance data from the central server to produce various reports showing the number of days for a selected leave type for all staff or selected staff over a rolling 6 or 12 months period.
If you require more information please contact me off list.
Similar threads
- Question