How to track monthly enrollment

[Alison]

Four teacher's aides and I provide Basic Skills Instruction in Reading,
Language and Math to over 100 K to 6 children in the BSI program. The BSI
program is funded by government grants and as such is burden by monthly
reporting of how many children are in the proram each month. At any time
during the school year, a child may be added to the program in one or more
areas, dropped from one or more areas and agained added to one or more
areas. I need advice on how to set up database tables to know each month who
the students are in each of the instructional programs. I have the Students
table with StudentID, Teacher table with TeacherID and InstructionalProgram
table with InstructionalProgramID. Is this the way to record students in
each program on a monthly basis:
TblStudentEnrolledInBSI
SchoolYear
SchoolMonth
InstructionalProgramID
StudentID
and at the beginning of each month, enter a new record for each student who
is still enrolled?

Thanks!

Alison

[Pieter Linden]

"Alison" <an****@earthlink.net> wrote in message news:<UR*****************@newsread2.news.atl.earth link.net>...

Four teacher's aides and I provide Basic Skills Instruction in Reading,
Language and Math to over 100 K to 6 children in the BSI program. The BSI
program is funded by government grants and as such is burden by monthly
reporting of how many children are in the proram each month. At any time
during the school year, a child may be added to the program in one or more
areas, dropped from one or more areas and agained added to one or more
areas. I need advice on how to set up database tables to know each month who
the students are in each of the instructional programs. I have the Students
table with StudentID, Teacher table with TeacherID and InstructionalProgram
table with InstructionalProgramID. Is this the way to record students in
each program on a monthly basis:
TblStudentEnrolledInBSI
SchoolYear
SchoolMonth
InstructionalProgramID
StudentID
and at the beginning of each month, enter a new record for each student who
is still enrolled?

Thanks!

Alison

Since each student can be added to multiple programs multiple times per year...

StudentID
EntryDate
ExitDate
ProgramID

Then you can do math on the dates to find out who is enrolled when.