B
Bryan Gwynne
I'm no expert in Access, not by any stretch of the
imagination. However, I have been set a task that I think
is just too complicated for me.
My boss wants a database that will plan our departmental--
15 members of staff--annual leave. The database must
satisfy the following conditions / criteria:
1. Each staff members annual leave year runs from the
month of their birthday, to the month before their
birthday the following year;
2. Each staff member has a different number of hours
Annual Laeave, depending on their length of service;
3. Each staff member can carry forward a maximum of 5 days
Annual Leave from one year to the next;
4. If an employee enters Annual Leave against the current
year, then only their current years leave total is debited;
5. If they record leave against the next leave year, this
would not debit the current years total, but would reflect
in the total hours left for the following leave year;
6. A maximum of five staff members are allowed off on any
day;
7. This information should be easily viewed, so that my
boss can see at a glance who is off on a particular day,
and whether someone can get a days Annual Leave request
granted;
I don't know what the best way to enter / view the
information would be. I'm guessing a calendar type
display, but as I say, I'm no expert at Access and don't
know how this would look / work far less how to code it!!
I'm not looking for someone to write it for me--although
that would certainly reduce the hassle--as I would learn
nothing from it. But, perhaps if someone could give me a
pointer to an existing database that could be used for
reference, or some hints / tips on how to set up my
tables, forms, queries etc.
I really would appreciate any help that anyone can provide
me with this.
My many thanks and kindest regards
Bryan
imagination. However, I have been set a task that I think
is just too complicated for me.
My boss wants a database that will plan our departmental--
15 members of staff--annual leave. The database must
satisfy the following conditions / criteria:
1. Each staff members annual leave year runs from the
month of their birthday, to the month before their
birthday the following year;
2. Each staff member has a different number of hours
Annual Laeave, depending on their length of service;
3. Each staff member can carry forward a maximum of 5 days
Annual Leave from one year to the next;
4. If an employee enters Annual Leave against the current
year, then only their current years leave total is debited;
5. If they record leave against the next leave year, this
would not debit the current years total, but would reflect
in the total hours left for the following leave year;
6. A maximum of five staff members are allowed off on any
day;
7. This information should be easily viewed, so that my
boss can see at a glance who is off on a particular day,
and whether someone can get a days Annual Leave request
granted;
I don't know what the best way to enter / view the
information would be. I'm guessing a calendar type
display, but as I say, I'm no expert at Access and don't
know how this would look / work far less how to code it!!
I'm not looking for someone to write it for me--although
that would certainly reduce the hassle--as I would learn
nothing from it. But, perhaps if someone could give me a
pointer to an existing database that could be used for
reference, or some hints / tips on how to set up my
tables, forms, queries etc.
I really would appreciate any help that anyone can provide
me with this.
My many thanks and kindest regards
Bryan