somebody help... plzzzz

[marco]

I ma doing a database project using ms access 2003 which later will be
converted in access 97 format.
I am making a scoring form (or report) of a student subjected to more than 1
courses and classes. (1 student can take more than 1 classes and more than 1
courses)

the scoring system will be based on good - average - bad - really bad
(checkbox/something else) and each scoring will be grouped in option group
example of scoring: good (checked) then the score is 1
bad (checked) then the score is 3
later I have to show that 1 student get how
many 1 score, and so on

I am really pleased to thank somebody that can help me.
if you don't mind I need the table and/querydesign also instead of the form

thank you very much.. if this forum is not enough you can email me at
(e-mail address removed) or (e-mail address removed)
and for those who has the same problem with me, you can email me and i will
give you the solution if I have been given by someone else.

thx nce again

 

[Tim Ferguson]

I am making a scoring form (or report) of a student subjected to more
than 1 courses and classes. (1 student can take more than 1 classes
and more than 1 courses)

Lots of assumptions required here.. please correct me if any of these are
wrong:

Students sign up for one or more Courses
Each Course has one or more Students

Courses consist of one or more Classes
Each Class related to exactly one Course

Grades are allocated to Students for performance on each Course
that they signed up for.

You may want information on Students' attendance at individual
Classes

If all that is true, then you have a scenario a bit like this:

Students -< SignedUpFor >- Courses -< Classes

SignedUpFor -< Attended >- Classes

The AllocatedGrade would be stored in the SignedUpFor table. The reason
for relating the Attended table to the SignedUpFor table is to prevent a
row recording a Student attending a Class he is not signed up for.

Questions:
Can a Student re-sign up for a Course he or she has previously attended?
Would there be any special treatment in such a case? Would you give
credits for Students who attend Classes outside their signed-up Classes?

I ma doing a database project using ms access 2003 which later will be
converted in access 97 format.

Very much Not Recommended. There is no easy translation from 2000 back to
97. If you want to end up using Access 97 (are you sure??), then start
the whole thing in that version.

Hope that helps


Tim F

 

[marco]

thanks Tim.

I already got the answer after trying a lot. It is much more like your idea.
Thank you for spending your time answering my question ^^

I hope I can convert it to Access 97, coz Im working in Germany and the OS
and the whole things are in German language. I am afraid that I can not catch
the deadline if Im using accces 97. I work using my own notebook which use
English.

thank once again. I really appreciate your answer

 

[Tim Ferguson]

I hope I can convert it to Access 97, coz Im working in Germany and
the OS and the whole things are in German language

Be very careful about this one: you could end up spending a sigficant time
in recoding...

Best wishes


Tim F