[mso] Re: Creating/fixing High school DB in Access

Any suggestions on how to deal with the addresses problem... see original
message for explanation.

April
-----------------------
If you get stuck on something please feel free to drop us a note in the
group and we will see what we can do to help.

James La Borde
South Western Federal Credit Union

-----Original Message-----

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
*************************************************************
*************************************************************
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
*************************************************************

*************************************************************
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: