Scheduling Database

[Neil Greenough]

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.

 

[Guest]

hi,
there are no templates in access like there are in excel.
you usually have to build form the table up.
the purpose of a database is to store data so start with
the table i.e. what data am i going to store.
then a way to get data into the table(form)and a way to
get data out of the table(usually a report, sometimes a
form).
i would suggest a bound form to start but get away from
bound forms as soon as possible. they are too restrictive
in the long run. unbound forms are more versital but
usually require more code.