Creating a Database for Registers

S

sdow

Hi,
I've been asked to help with Registers that the Nursery staff keep.
Currently they keep them in word files and have a different file for each
day AM and Day PM, eg Monday AM, Monday PM, Tues AM, Tues PM etc.
So they have 10 files to update manually every day, as the children aren't
in at the same time each day.

I suggested they use a Database, but after looking at the files I don't
really know how to go about it. I know Relationships will probably have to be
used. But not sure what to put in the tables?
What are the 'rules' for creating a database?

Each word file contains the following tables: Childrens Name, D.O.B, AYR/TT,
Session, Arrive, Home.
Childs name, DOB and AYR/TT don't change, however sessions, Arrive and Home
change all the time.

What they want is to just type in the data for say, Monday AM and have that
data automatically change on Tues, Wed, Thur, Fri.

Is this possible, if so could someone explain what I need to do?
Thanks!
 
J

Joan Wild

Scheduling database can be very complicated, particularly managing the
conflicts.

I've done a scheduling database for homecare workers/clients. My approach
was to set up a schedule for the workers with set time slots. Then assign
clients into those timeslots. It was easy then to find an open slot in a
worker's schedule.

Since the schedule remained somewhat static on a 2 week cycle, I set up a 4
week schedule. We would just roll the scedule forward two weeks, and they
would make the necessary changes for the current two-week period. If there
was a permanent change to the schedule, they'd make that change for the full
4 weeks, so that the next roll forward would include that change.

You would need tables for:

Children - ChildName, DOB, etc
Nurses - NurseName, etc
Schedule - linking table between the above two containing the start
date/time and end date/time.
 
S

sdow

Thank You both for your replies. I'll check out that link.
The example given, hasn't really helped, I just get confused with all the
different tables! Thanks for replying though.
 
Top