Help with a Vacation Calendar

[Lisa]

Here is the concept.. wondering if access would be viable for this idea. I
want to create a calendar that tracks each persons vacation time so we know
who is in the office and who is out. So this would be a scheduler. It would
also show track how much time each person has and how much time they have
left...

Also, I know when you go to alot of sites there is a calendar picker where
you just pick the day off the calendar can that technology be added to Access?

 

[Allen Browne]

Yes, there are lots of sites where you can get a popup calendar. Some are
simple little Access forms that work without any other references, like
this:
http://allenbrowne.com/ser-51.html

But your main question was about how to design and query such a database. At
the simplest, you will need these 2 tables:
- A table of employees, with fields:
EmployeeID primary key
Surname text
...

- A table of vacation dates:
EmployeeID Number relates to Employee.EmployeeID
StartDate date/time first date the person will be away.
EndDate date/time last date the person will be away.

You may need more than that if you are trying to track how many dates leave
were actually taken, since some dates in that range could be weekends or
public holidays.

 

[jahoobob via AccessMonster.com]

If the StartDate and EndDate in Allen's tables are always entered as the
beginning and end of actual time taken and don't include the holidays and
weekends, there is no need to add anything to compensate for holidays and
weekends. A person taking a two week vacation would have two entries, the
Monday thru Friday of both weeks. All you would need to do is use a
continuous subform for the date entries.

Yes, there are lots of sites where you can get a popup calendar. Some are
simple little Access forms that work without any other references, like
this:
http://allenbrowne.com/ser-51.html

But your main question was about how to design and query such a database. At
the simplest, you will need these 2 tables:
- A table of employees, with fields:
EmployeeID primary key
Surname text
...

- A table of vacation dates:
EmployeeID Number relates to Employee.EmployeeID
StartDate date/time first date the person will be away.
EndDate date/time last date the person will be away.

You may need more than that if you are trying to track how many dates leave
were actually taken, since some dates in that range could be weekends or
public holidays.

Here is the concept.. wondering if access would be viable for this idea.
I

[quoted text clipped - 8 lines]

you just pick the day off the calendar can that technology be added to
Access?