In terms of the number of rows it doesn't matter, but by putting the heading in a different table, they only have to fill a heading once and they can...

Hi Gail,

A small problem we have with your design is, say for an instance a teacher teaches a subject for hundred kids and she has to fill in the same...

Thanks Gail, this will be a perfect design for our system. Thanks again to everyone.

Comments is one per teacher/student/subject/period, but you have many assessments as you like per teacher/student/subject/period. So when a report is created at the end, you have all the assesment a...

sorry for any confusions that I have caused regarding column names.

One more problem that I have with Gail's design is some of the report-data such as 'comments' is one per...

Thank you all guys, you have been very helpful and I am very grateful for everyone who contributed to this topic. I thought more or less same way as Gail’s...

These data comes from an assessment, a grade awarded for a task; there may be around 10 tasks in a term and these need to saved each term. people should...

Actually they are assessment data of students, such as grades, assessment of a task, comments etc, they are quite varying data which cannot be generated automatically, they are recorded by...

Thanks Gail for your input on this topic, they were really clear and ontarget; I thought Steve said data being mangled up...I may have misunderstood..

WHat do you think I...

Steve, you may be right about Access using the timestamp column; unless I find another way to create reports, I would have to leave that column alone.

I can’t understand why...

First of all forgive me for cross posting.

Sorry I didn't mean to confuse things by changing the names; I thought the names are irrelevant in this context, data types need...

Thank you all for all your responses, it has been very helpful.

Awp

Thanks for the replies, it was really helpful, however what I can't understand is when I define the fields with fixed lengths, which is less than 8000-that is the maximum,...

I have done the installation exactly as above and everything so far working fine, many thanks for your input on this.

Do I have to run 'sp_createstats' as well? if so in what order please?