Annual Leave Application.

[mqayyum]

Hi Everybody,

I have recently given a task to develop an application in ms access 2007 to keep record of employee vacation for fiscal year starting from Jan 01 to Dec 31.

I have collected the information based on current setup and developed the following tables:

1) Department
DepartID (AutoNumber)
DepartName
2) Nationaity
NationID (AutoNumber)
Nationality
3) Region
RegionID (AutoNumber) \\\\\Basically we have only three regions: Western/Eastern/Central
RegionDesc
4) Employee
EmpID (Primary Key with Manual Entry of 5 Numaric Code)
EmpPic
First/Middle/Last
Title
Department
Nationality
Region
JoiningDate
VacEntitled \\\\\ In our company all employees are getting 22 days if it is less than 5 years
from the date of joining and 30 days for 5 years or more.

Now I want to add more tables in a way that I should have two forms for vacation. One form when an employee apply for vacation. This form will validate the vacation plan based on available days.

Second form is for when an employee come back from vacation where we will enter actual return date.

I also need following reports:

1. List of employees by Department/Nationalities/Region
2. Employee history of vacation
3. And some more……

Please help me....I have only this week to finalize it. I appreciate your quick response and any better idea for implement this.

Best regards, Qayyum

 

[carl024]

you send more detail and law of your company

 

[mqayyum]

Dear carl024,

Thanks a lot for your response.

we have about 100 employees on Contract basis (1 year standard contract term) with single shift from 8am to 5pm and each employee is entitled for 22 or 30 days annual leave paid/unpaid. vacation days depend on the length of the job i.e. 22 days for 0 to <5 year job length and 30 days for =>5.

Annual leave can be availed in one shot or intermittent for i.e. I can take 30 days vacation twice or thrice but we are not allowed to carry forward to next year. Any remaining vacation will become zero next year.

Each employee is entitled for number of air tickets depending on status and position i.e.
Single Status = 1 Ticket (Economy Class)
Family Status Engineer = 3 or 4 Tickets (Economy Class)
Family Status Manager = 3 or 4 Tickets (Business Class)
General Manager = 6 Tickets (First Class)

Medical/any other leave is handled separately.

 

[The_Doc_Man]

That sounds like a useful system you're building! If you're looking for a quick way to calculate entitlements and validate leave balances, annualleavecaclulator.com might help. It simplifies leave calculations, especially when dealing with different policies like yours. Have you considered integrating external leave tracking tools with your Access database?

Your suggestion was for a 12-year-old thread. Check the top line above the main frame of each post to see the date of issuance.