I need some help with data normalization. I have some years of experience with Access but this one eludes me. Basically, I am taking data from an Excel spreadsheet and converting onto an Access database. In Excel each of thirteen public schools has its own page that records that number of teacher at each grade level and by subject along with enrollment. For example. At the elemtary level I have data for the following:
Grades 1 through five = # of teachers
Grades 1 through 5 # of students enrolled
Special Subject area teachers # of
Special Subject areas # of student enrolled.
This data is organized by year. I need to eventually produce a report that compares the change in the above data from one year to the next. In other words, do I have more or less first grade teachers that the year before..
Currently I have table that identifies the school and assigns a unique id. I have a table for elementary schools that has a filed for every one of the above i.e.
Grade 1 teachers #
Grade 2 teachers # and so on
Grade 1 enrollment
Grade 2 enrollment and so on.
I have a form that open a record based on the school and a subform that collects all the above per school.
I dont know if this is normalized as well as it should be. I am also somewhat unsure about how to develop the report I am looking for. I just need a push in the right direction.