This project is to be done primarily in microsoft access using VBA for the little bits and bobs.
The most notable part of VBA will for you to create a composite primary key.
Each person at kent sports club is put into one of six guilds inside this sports club. Each guild participates in regular events throughout the year. The guilds compete against each other in these events and are placed 1-6 in each event. The guilds earn points for their place in each event and the guild with the most points at the end of the year wins the guild prize, there are also various other prizes each guild can win for individual events.
The system needs to keep track of each place each guild was placed in every event, use a sample of guild names and a sample of events (min 10). The system needs to add up all the guild points and produce a report of which guilds won what event and what prize they recieve for this event. All basic functions are also needed (further detail will be given as project progresses) like searching etc.
As well as the administration of the guild events, the guild master also has to keep track of each person who participate in these events. The people in each giuld also earn points according to how well they do in each event, 5 points is given for good effort and 10 points are given for good effort and achievement. These points for each event are added up and if 30 points are earned, a person wins a sports club badge, however if 60 points are earned outstanding sports badge is earned. If a person earns more then 12 points the cycle restarts and badges can be re-awarded.
A much more detailed spec will be given once winning bidder is chosen.
USA, English & English speaking preferred.