Results 1 to 2 of 2
Thread: Students Database (2000/All)
2007-02-15, 20:28 #1
- Join Date
- Jan 2001
- Brisbane, Australia
- Thanked 0 Times in 0 Posts
Students Database (2000/All)
I have a database of primary students (years 1-7) and the grade (1A, 1B....7B,7C) that they are in for that year (separate tables).
The teachers can record student details (eg reading levels, etc.) and these details are given in a printed format to the next year's teacher as a guide to the student's performance.
Now some teachers want to compare a student's performance with previous years. My problem is that each year is a separate database and I am not sure how to enable my database so that teachers can record details about individual students for different years as the student moves to the next grade.
Any suggestions please? Oh, and the database is still in 2000 format if that is critical to design.
2007-02-15, 20:36 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Students Database (2000/All)
You can link to tables in another database, so you could create links in the database for the current year to tables in the database for the previous year. You can then create queries based on data for more than one year.
Another option, requiring significant restructuring, would be to add a SchoolYear field to all the tables, populate it with the relevant year in each database, then merge the tables for different years into one table.