Scholarship database setup

[Love to Compute]

My boss is chairman of a committee that awards scholarships to college
students. This organization's members are different companies around the
states. I am trying to put together a database that will help us keep track
of applicants. The information I'd like to keep is applicant info, including
GPA's & test scores, rankings, application checklist (application complete,
transcript copy, picture, essay), scoring on essay and application questions
and whether awarded or declined. Eventually, I'd like to chart what companies
have the most recipients and total amounts awarded per student. I've got the
basic tables such as applicant info (name, address, etc), chapter chairman
info, and I've made a table listing the awards (2006 scholarship, 2007
scholarship, etc).
I'm using access 2003 and have read the how-to's on Microsoft. Having a
great and just hoping I'm going in the right direction.
Has anyone ever attempted something like this? I'm doing okay I think for a
relative newbie. I'm having trouble calculating rank though. I have an entry
for rank and one for class size and I'd like a percent calculated (ex. 10th
out of 100 = 10%).
I'm using Access 2003
Thanks in advance

 

[Allen Browne]

Hopefully you have set up lots of one-to-many relationships, e.g.:
- one organization can have many members
- one applicant can sent many applications (over the years)?
- one application can have many components (scores)
and so on.

Ranking is not a simple thing. It requires you to count the number of people
who beat the individual in the set you are examining. For details, see:
Ranking or numbering records
at:
http://allenbrowne.com/ranking.html

 

[Love to Compute]

I do have lots of relationships. One of my tables has a list of scholarships
(2006, 2007, 2008) while another has a list of applicant info. To record the
scholarship recipients, I have a form with two combo-boxes, one with the
applicant and one with the scholarship. I'm not really happy with this
arrangement. How can I set up a form with the student's name and checkboxes
for each year's scholarship? I think this would make it easier to pull up a
list of those who received scholarships this year for the first time. They
can renew for up to four years and we send out reminders only after the first
year. Eventually, I'll have charts/reports showing the distribution between
companies and the precentage of re-applications.
I'm loving this program. I have learned so much since I've started playing
with it.
Thanks - Ro

 

[Allen Browne]

You can use a crosstab query to generate the output you want.
However, crosstabs are read-only (not for entering data).