Creating a Database for Registers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sdow - 08 Feb 2006 09:21 GMT

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!

Reply to this Message

Wayne-in-Manchester - 08 Feb 2006 15:55 GMT

Micorsoft has a template just for this.

go to http://office.microsoft.com/en-gb/templates/CT062100801033.aspx

to check it out (there are many other as the same area)

Hope this helps

> Hi,
> I've been asked to help with Registers that the Nursery staff keep.
[quoted text clipped - 18 lines]
> Is this possible, if so could someone explain what I need to do?
> Thanks!

Reply to this Message

Joan Wild - 08 Feb 2006 17:23 GMT

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.

Signature

Joan Wild
Microsoft Access MVP

> Hi,
> I've been asked to help with Registers that the Nursery staff keep.
[quoted text clipped - 18 lines]
> Is this possible, if so could someone explain what I need to do?
> Thanks!

Reply to this Message

sdow - 09 Feb 2006 09:12 GMT

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.

Reply to this Message