Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    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.

    Regards, Leigh

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •