Design help

[marix]

Hi,

I have my first ever database project and need some advice before I start. Here are some details:

In the past we have used a simple word document to hold some details on incidents with students. For example:

Date name group time details
01/02/07 joe blogs 10G 13:20 joe set off the fire alarm
==============================================
10/02/07 jon doe 11F 08:30 Jon spat at a teacher
==============================================


There are now over 200 pages and this is becoming hard to maintain and find records as names are often spelt incorrectly and in no order, etc

I am trying to work out how best to set out my tables. Do I put it all into one or do i split up the tables. Do I have a user table and a main table?
If I have a user table I want the primary key to be the student's admission number so this will match up with our school management system if I need to put a name to a face. I was thinking of a separate user table because once a student is added I could use a list box to select a student when i need to add another incident rather than type his/her name.



hope this makes sense!

Cheers,

Marix

[acehowell]

It all depends on how many fields you are needing, if all you are needing is five i would just use 1 table, and 1 form. This should be a rather easy setup.