Vacation Scheduling DB 
Author Message
 Vacation Scheduling DB

I've been tasked with creating a database to allow supervisors to
schedule vacation time for their employees.  The supervisors have been
using cumbersome Excel spreadsheets to date and are unfamiliar with
Access.  Hence, I must create a very user-friendly interface that can
produce equally friendly reports. No problem, right?

I see some potential challenges:
--The database must count actual vacation time used between two given
dates adjusted for shift schedules and holidays.  We operate four
twelve-hour shifts (1-4) and three 8-hour shifts (a-c).  The twelve
hour shifts pose a challenge in that they don't follow a five-day work
week.
--The databse must also alert the supervisor if the total persons on
vacation on any day for a given shift exceeds 10% for some months and
15% for other months

I've been thinking of creating a table with the year's workdays for
each shift to act as a reference for counting actual days off between
two given date/times.

I'm sure many of you have probably dealt with this or a similar
challange before.  I welcome any suggestions you may have to offer.

Thanks in advance,
Michael Curry

Sent via Deja.com http://www.*-*-*.com/
Before you buy.



Tue, 20 May 2003 03:00:00 GMT  
 Vacation Scheduling DB
Check the following link: http://www.mvps.org/access/ for the Date/Time
routines. I believe that there is sample code that should come close to what
you need.

Steve

Quote:
> I've been tasked with creating a database to allow supervisors to
> schedule vacation time for their employees.  The supervisors have been
> using cumbersome Excel spreadsheets to date and are unfamiliar with
> Access.  Hence, I must create a very user-friendly interface that can
> produce equally friendly reports. No problem, right?

> I see some potential challenges:
> --The database must count actual vacation time used between two given
> dates adjusted for shift schedules and holidays.  We operate four
> twelve-hour shifts (1-4) and three 8-hour shifts (a-c).  The twelve
> hour shifts pose a challenge in that they don't follow a five-day work
> week.
> --The databse must also alert the supervisor if the total persons on
> vacation on any day for a given shift exceeds 10% for some months and
> 15% for other months

> I've been thinking of creating a table with the year's workdays for
> each shift to act as a reference for counting actual days off between
> two given date/times.

> I'm sure many of you have probably dealt with this or a similar
> challange before.  I welcome any suggestions you may have to offer.

> Thanks in advance,
> Michael Curry

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Wed, 21 May 2003 03:00:00 GMT  
 Vacation Scheduling DB
Thanks, Steve.  I believe that gets me in the neighborhood.  It seems
to me if I list all off-days as holidays and omit the weekend feature,
it just may work.  Now I have the challenge of dealing with partial
days of vacation.  Any suggestions?

--Mike

Sent via Deja.com http://www.deja.com/
Before you buy.



Fri, 23 May 2003 03:00:00 GMT  
 Vacation Scheduling DB
Perhaps you can use fractional business days? For example, I was asked to
calculate the number of business days it took to resolve an issue. The
business day was defined as an 8 to 5 PM (9 hour work day), M-F excluding
weekends and holidays. Once I was able to determine number of hours, it was
a matter of dividing by 9 (hours or 1 business day).

Hoping this helps you with your situation <g>

Steve

Quote:
> Thanks, Steve.  I believe that gets me in the neighborhood.  It seems
> to me if I list all off-days as holidays and omit the weekend feature,
> it just may work.  Now I have the challenge of dealing with partial
> days of vacation.  Any suggestions?

> --Mike

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Sat, 24 May 2003 03:00:00 GMT  
 Vacation Scheduling DB
Thanks Steve, I think I may do the whole process in hours and then
convert back to days if necessary.

--Michael Curry

Sent via Deja.com http://www.deja.com/
Before you buy.



Sat, 24 May 2003 03:00:00 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Need Help creating calendar type form to schedule vacations

2. Vacation Schedule

3. vacation schedules for large groups

4. Central vacation request/schedule for a group ?

5. Scheduling DB??

6. scheduling a report on a DB w/ password???

7. Normalizing--Db with scheduling functionality

8. scheduling a report on a DB w/ password???

9. Reject date entry if Holiday in scheduling db.

10. Help in creating Offline DB client - DB Configurator with Jet DB Technology


 
Powered by phpBB® Forum Software © phpBB Group