If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a Database for Registers
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! |
#2
|
|||
|
|||
Creating a Database for Registers
Micorsoft has a template just for this.
go to http://office.microsoft.com/en-gb/te...100801033.aspx to check it out (there are many other as the same area) Hope this helps "sdow" wrote: 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! |
#3
|
|||
|
|||
Creating a Database for Registers
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. -- Joan Wild Microsoft Access MVP sdow wrote: 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! |
#4
|
|||
|
|||
Creating a Database for Registers
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Continuous corruption of database | Keeler | General Discussion | 14 | November 1st, 2005 07:11 PM |
Creating a recordset of a table in an external database | Shadow | General Discussion | 4 | March 28th, 2005 02:11 AM |
Creating a recordset of a table in an external database | Shadow | New Users | 4 | March 28th, 2005 02:11 AM |
cannot change password | Richard | General Discussion | 13 | November 14th, 2004 10:00 PM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |