League Table Access 2003

[stephenf33]

Hi All

I was wondering if anyone knew how to or has developed an access database that could record exam scores and then copy information onto another form as a league table, showing the highest results

Any help would be greatly appriciated

Many Thanks

Stephen

[nico5038]

Hi Stephen,

It's a very general question you've posted. I've created many databases, even a questionair, but it's always different depending on the requirements.

As I read your requirement, you need a table for the scores and a query to show the top scorers. When you supply some more information we could help you with the design.

Nic;o)

[stephenf33]

Hi Nic

Thankyou for your reply, what i would like to do is

There is a list of people and these people do exams, i would like to record each result for each exam taken by a person and for each exam
display the scores in the highest order.

Hopefully it is ok to understand, its quite difficult for me to put in words

Many Thanks

Stephen

[nico5038]

OK, then I guess you have a table like:
tblStudentExam
StudentID
ExamID
Score
(optionaly a date the exam was taken could be added, etc.)

This table is effectively a relation between a table tblStudent and a table tblExam.

For reporting the Max Sore(s) you can now use a "Group By" query like:

select ExamID, Max(Score) as MaxOfScore from tblDtudentExam 
Group By ExamID
 

You can construct this query using the graphical query editor. Just select the table, the fields ExamID and Score and press the "E" looking GroupBy button.
The press the datasheet button to see the result.

Nic;o)