New to Database creation and need advice on structure.

[Mossyb]

This is my first Database and I've got a few questions to ask before I spend hours wasting my time, So I hope you can help.



I'm creating a database of schools and their contacts.

It will have a field for the Local Education Authority, School Name and contact details for office, Head, Deputy, and SENCo (Special Education Needs Co-ordinator)

Do I create a field for each of the the schools contacts details or do I create a field for the job Title so that each school will have multiple contacts but each individual will have their own record instead of the school as a whole having one record with lots of data?

Basically this is the data that I wish to capture.

LEA, School, Telephone, Fax, Email, Address, Address1, Address 2, Address3, Post Code, Sector (Primary, Secondary, Special ED), HEAD Teacher, HT Telephone, HT Email, Deputy Head Teacher, DHT Telephone, DHT Email, SENCo, SENCo Telephone, SENCo Email, School Manager, SM Telephone, SM Email. Last Visited, Last Telephoned, Last Placement, Notes.

With each of the contacts I need a tick box or Yes/No field to signify if they are the point of contact for supply staff. There may be more than one within a school.

Please give me some advise on how to structure this database as I will need to view all the contacts on one page when I pull the school details up in a form.

Thanks in advance for any help.

[June7]

I suggest you use the approach of a Title field. Need at least two tables.

tblSchools
SchoolID
SchoolName
Address

tblSchoolContacts
ContactID
SchoolID
etc.

Maybe this will be helpful http://www.rogersaccesslibrary.com/