Hello. Good Evening.
I need to have a database that help to track employees holidays /vacations request and it's status.
We will have a predetermined staff we can allow to go on leave.
And managing it through excel is too messy. I wonder if there is a template anyone can help to share me? Thanks in advance.
Best answered by searching yourself.I wonder if there is a template...
It shouldn't be, if you use flat table for data entry. There's plenty of samples out there (If you search for "Employee attendance tracker", it's vacation/attendance tracking template provided by Microsoft).And managing it through excel is too messy.
But then, if you have multiple people managing the file, Excel isn't the ideal tool for this.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Still looking for some guidance to create this database..
Lots of models at this site. You might find the one you need. http://www.databaseanswers.org/data_models/
If that doesn't work for you, then maybe this:
http://lmgtfy.com/?q=MS+Access+Emplo...ation+Tracking
Last edited by alansidman; 06-28-2017 at 11:50 PM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks