What's New - Support - Download - E-mail

Year End/Start Routines:

The first thing you will want to do is copy the database from the previous year. If the new school year is 2000-2001 then I would recommend naming it 00-01.mdb

Save the original database name as 99-00.mdb.

Now you should have two databases that are exactly the same (except for the name).

Open the newly copied database.

The database will have these tables:

FallData

used by the program to keep track of the Fall scores. Delete all the files in this table to start a new year - AFTER YOU HAVE A BACKUP!!

SpringData

used by the program to keep track of the Spring scores Delete all the files in this table to start a new school year - AFTER YOU HAVE A BACKUP!!

Students

 This table is used by the program to get to know the kids. It had birthdate, teacher and stuff like that Teachers - This table is used by the program to get info about the teacher.

raw_data_students

This is the data that I imported from SASI - delete all the contents before you start a new year.

raw_data_teachers

 This is the teacher data as imported from SASI - delete all these to begin a new year

And these queries:

append_students_table

after the Student data is imported from SASI and put into the empty raw_data_students table, run this query to add the students to the Students table. The main function of this is to convert that butt ugly birthdate - 19950301 to a real date used by access. Run this one after the append_teacher_table query.

append_teachers_table

Basically takes the data from SASI teacher number, first and last name and combines the first and last name. Sticks it all in the Teachers table. Run this before the append_students_table. (The raw data from SASI was only getting the teacher number, and here we associate the two).

dupe awards

The program uses this

qryNPFA

The program uses this

qryPPFA

The program uses this