Share via

Access Database

Anonymous
2016-02-21T19:40:04+00:00

I am looking for an Access database that I can use to track Employee Leave of Absence such as:

Annual Leave, Sick Leave, Stat Holidays, Lieu Time Off, Time Off Earned at Time @ 1/2 and Time off earned at regular time.

I also want to track Sick leave that is earned at 12hrs a month.

The database must be able to calculate the ongoing balance in each category.

Does Microsoft have a sample database of this type ready to go. 

I have designed one in Excel and it works great.  I would love to have one in Access. This would allow a number of valuable report to be created form the stats.

Hope you can help

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

ScottGem 68,830 Reputation points Volunteer Moderator
2016-02-21T22:31:30+00:00

While Access templates are good illustrations, they are not meant as turnkey applications. You will almost definitely have to modify anything that exists. Personally I prefer to build from scratch. 

You will need an employees table, a Leaves table and Leave types table. as a starting point.

Was this answer helpful?

2 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-02-26T15:08:24+00:00

    Thank you for your response.  It was indeed helpful.

    I appreciate you taking the time to reply.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments