tables for attendance

[ferhanz]

I am making a small HR system in ms access 2003, i am stuck in making the tables for calculating the leaves of employees, what kind of logical tables will there be i need

e.g. we have 22 Annual leaves, 9 Sick leaves and 3 special leaves. i want to manage the leaves and i want to display when were the leaves taken

thankyou



Farhan

 

[Guus2005]

what's a leave?

you have 22 annual leaves? That's like holidays to me. But here i am a little puzzled: you have 9 sick leaves? What's that?

 

[Mr. B]

Farhan,

Several questions come to mind with this issue.

I am assuming that these "leaves" are like days off. Do the ones you list include specific holidays? Are these leaves to be taken within a calendar year of a fiscal year? What happens to days which are not taken?

Until these questions are answered it may be a tough call to define just how to best structure your data. My first thought is that you would need a table to hold the records of the leaves taken by each person. You may also want some "leaves_types" table somewere to hold information like you described with the "22 annual", 9 sick, and 3 special" for the types of leaves available. By creating this data in a table you can provide your users with the ability to change the count of the different types of "leaves" when necessary and still not affect your application.

HTH