By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Scheduling Template

P: n/a
I am looking for a scheduling template or will maybe have a go at creating
the database myself.

Basically, the database will include a table listing certain volunteers,
their volunteer number (employee number) and the group they are attached to
(department.) All volunteers are split up into 8 groups and each group is
led by a supervisor.

Now what I would like is for each volunteer to be able to access the
database on the Thursday of every week and enter their planned working hours
from the coming Sunday to the following Sunday. This would include the date,
start time and finish time.

Ideally, the end result will be that individuals will be able to enter their
hours and then, from an administrative menu / form, the supervisors will be
able to choose their group and see in advance of what volunteers they have
coming in and when.

Any ideas? I am looking for either a template I can modify or any advice on
structuring my tables.
Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
TblVolunteer
VolunteerID
FirstName
MI
LastName
EmpNumIsSupervisor (Yes/No)
<<Any Other Fields Of Information About Volunteers You Need>>

TblGroup
GroupID
GroupName

TblGroupSupervisor
GroupSupervisorID
VolunteerID

TblGroupMember
GroupMemberID
VolunteerID

TblVolunteerWorkHour
VolunteerWorkHourID
VolunteerID
Workdate
StartTime
FinishTime

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Neil Greenough" <ne***********@btopenworld.com> wrote in message
news:cl**********@hercules.btinternet.com...
I am looking for a scheduling template or will maybe have a go at creating
the database myself.

Basically, the database will include a table listing certain volunteers,
their volunteer number (employee number) and the group they are attached to (department.) All volunteers are split up into 8 groups and each group is
led by a supervisor.

Now what I would like is for each volunteer to be able to access the
database on the Thursday of every week and enter their planned working hours from the coming Sunday to the following Sunday. This would include the date, start time and finish time.

Ideally, the end result will be that individuals will be able to enter their hours and then, from an administrative menu / form, the supervisors will be able to choose their group and see in advance of what volunteers they have
coming in and when.

Any ideas? I am looking for either a template I can modify or any advice on structuring my tables.

Nov 13 '05 #2

P: n/a
TblVolunteer
VolunteerID
FirstName
MI
LastName
EmpNumIsSupervisor (Yes/No)
<<Any Other Fields Of Information About Volunteers You Need>>

What does "MI" stand for?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3

P: n/a
How about Middle Initial? Just a guess
Patrick

On 18 Oct 2004 18:48:18 GMT, Neil Greenough
<ne***********@btopenworld.com> wrote:
TblVolunteer
VolunteerID
FirstName
MI
LastName
EmpNumIsSupervisor (Yes/No)
<<Any Other Fields Of Information About Volunteers You Need>>

What does "MI" stand for?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 13 '05 #4

P: n/a
Yes, that's correct!
"Patrick Fisher" <in**@psoftuk.com> wrote in message
news:9h********************************@4ax.com...
How about Middle Initial? Just a guess
Patrick

On 18 Oct 2004 18:48:18 GMT, Neil Greenough
<ne***********@btopenworld.com> wrote:
TblVolunteer
VolunteerID
FirstName
MI
LastName
EmpNumIsSupervisor (Yes/No)
<<Any Other Fields Of Information About Volunteers You Need>>

What does "MI" stand for?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #5

P: n/a
The GroupMemberID in the tblGroupMember, does that relate to the =
department if you like and that is how the Volunteer is matched up with =
their specific group? I am just looking at the relationships now in this =
database you see.....
"PC Datasheet" <no****@nospam.spam> wrote in message
news:Xg**************@newsread3.news.atl.earthlink .net...
Yes, that's correct!
"Patrick Fisher" <in**@psoftuk.com> wrote in message
news:9h********************************@4ax.com...
How about Middle Initial? Just a guess
Patrick

On 18 Oct 2004 18:48:18 GMT, Neil Greenough
<ne***********@btopenworld.com> wrote:
TblVolunteer
VolunteerID
FirstName
MI
LastName
EmpNumIsSupervisor (Yes/No)
<<Any Other Fields Of Information About Volunteers You Need>>

What does "MI" stand for?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 13 '05 #6

P: n/a
The GroupMemberID in the tblGroupMember, does that relate to the
department if you like and that is how the Volunteer is matched up with
their specific group? I am just looking at the relationships now in this
database you see.....

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #7

P: n/a
Sorry, Neil, I omitted a field ---
Should be:
TblGroupMember
GroupMemberID
GroupID
VolunteerID

GroupID identifies the specific group a member belongs to.

Steve
PC Datasheet

"Neil Greenough" <ne***********@btopenworld.com> wrote in message
news:cl**********@hercules.btinternet.com...
The GroupMemberID in the tblGroupMember, does that relate to the =
department if you like and that is how the Volunteer is matched up with =
their specific group? I am just looking at the relationships now in this =
database you see.....
"PC Datasheet" <no****@nospam.spam> wrote in message
news:Xg**************@newsread3.news.atl.earthlink .net...
Yes, that's correct!
"Patrick Fisher" <in**@psoftuk.com> wrote in message
news:9h********************************@4ax.com...
How about Middle Initial? Just a guess
Patrick

On 18 Oct 2004 18:48:18 GMT, Neil Greenough
<ne***********@btopenworld.com> wrote:

>TblVolunteer
>VolunteerID
>FirstName
>MI
>LastName
>EmpNumIsSupervisor (Yes/No)
><<Any Other Fields Of Information About Volunteers You Need>>
>
>What does "MI" stand for?
>
>
>
>
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!



Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.