[mso] Creating/fixing High school DB in Access

I am trying to figure out what would be the best way to create (high school)
class schedules to A) know who is where and B) potentially be able to track
attendance for both Teachers and Students and grades.

Ok, I have a master list  (table) of:
  1.. all classes (not by period, just available)
  2.. Teachers
  3.. Students
Should I create first a table for each teacher with every class/room/period
or One table for each period with teacher name and room then do the same for
students? (One table for each period with student/class)?  What about the
difference with classes that are 2 semesters long (the entire school year)
and the ones that are only 1 semester long.

From there, thinking a head, (I don't know if this would be a table or
form-subform working on the tables above) how would I do attendance
(absent - excused, absent - unexcused, tardy - excused, tardy - unexcused,
in-school-suspended,off-campus-suspended, etc) say for students in Ms.
Smith's 2nd period class, how would I do grades??  How would I do
attendance/per period for teachers?


Ok, the other problem that I have is on the registration tables for the
students (Right now, in the already poorly designed DB - there is one table
with like 30+ columns that I am trying to break down.  Think about it, they
took the entire registration form that is filled out upon entering the
school and created ONE table for all of it.  And yes, they did the same
thing for the teachers employment application!)

There is a place (need) for the student's home address, mailing address (may
or may not be the home), Legal Guardian's address/contact info, Mother's
address/contact info, and Father's address/contact info.  Now obviously this
could all be the exact same address for each of the 5 contact info, or it
could potentially be 5 different addresses.  How do I set this up with the
least amount of redundancy?? (Note: Contact info is name,relation, and all
phone numbers) Oh and I forgot, there is also a separate place for emergency
info (who to call, relationship, address, phones).

Anybody that has experience with creating (re-creating/fixing) this type of
DB, that may know of anything else that might need to be included, thought
about, that I have not thought of yet, PLEASE let me know.

Thanks for your help.  Also, when you reply to the group, please also cc me
at arpace@xxxxxxxxxxxxxxxxx

April





*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: