Write a time tracking program for vacation, sick hours, etc..

Completed Posted Mar 27, 2013 Paid on delivery
Completed Paid on delivery

I am looking for an Access database to track time off. I need to be able to enter general Information about an employee. Then enter their start date and the date we add time off for them. For instance if they are eligible for 2.5 days off starting six months from now, it needs to flag us when to add those days. It then needs to keep track of the next add date and notify us when that day arrives. Also we need to put in the date and hours of any time off used. It needs to keep vacation, sick days, and flexible time off, and a few others. I will need a monthly report to show who used how much of each category and a screen with the employee summary of available time on it.

More info. Something simple to track the number of hours (not Days) that an employee uses, has left, and accrues. The hours will be added on certain dates. For example an employee is hired. We to add that employe record with hire date.. We also need a reminder that he gets 40 hours of sick leave added in 90 days, and 40 hours of vacation time added in 6 months. When 90 days are up a reminder comes up when the program opens to add the 40 hours of sick time. 40 Hours are added and a new reminder is added toadd more hours next year. The next pay period he takes 8 hours of sick leave. On payday the clerk goes in and enters everyone's exception time - sick hours, vacation, personal, etc... Whenever the boss needs it she can print a report showing each employee and the number of hours used in a date range and the number of hours left to use. This also needs to track tardies. So when the clerk is putting in exception hours they can also log a record to note he was late three hours on a particular date. All this does is track hours in and out, keep some reminders, and print a report. It would also be nice to be able to look an employee up and view the records for that employee in a list so the clerk can show that person their balances and see when time was used.

Microsoft Access

Project ID: #4374494

About the project

2 proposals Remote project Active Mar 27, 2013

Awarded to:

kulhanekd

I have 15 years exp in access design and creation. I have build hundreds over the last 15 years. I would like to bid. I can start today. Thanks Donna

$175 USD in 3 days
(31 Reviews)
5.7

2 freelancers are bidding on average $173 for this job

praveen2121

Ready to take this project. Please check PMB.

$170 USD in 3 days
(0 Reviews)
0.0