By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,066 Members | 616 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,066 IT Pros & Developers. It's quick & easy.

League Table Access 2003

P: 2
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
May 24 '07 #1
Share this Question
Share on Google+
3 Replies

nico5038
Expert 2.5K+
P: 3,072
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)
Jun 2 '07 #2

P: 2
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
Jun 4 '07 #3

nico5038
Expert 2.5K+
P: 3,072
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:
Expand|Select|Wrap|Line Numbers
  1. select ExamID, Max(Score) as MaxOfScore from tblDtudentExam 
  2. Group By ExamID
  3.  
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)
Jun 4 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.