Tournament Database

[Navyguy]

I have started to tackle another volunteer project/idea that I thought may be interesting; a tournament database.

I have on paper at least, think I have a good grip on table structure, queries, etc. In idea that I am thinking that may be a problem is the bye system in a report format.

I would be interested in hearing suggestions on how to approach this or even if you think that perhaps that this is one of those things that are best left to human effort.

Some of my considerations were/are:

What if everybody doesn't showup (ie sick/injured/late);
Last minute/late entries;
Types of tournaments (round robin, single elimination, double elimination, etc);
Making it multipurpose (darts, tennis, martial arts, hockey, etc);
Team vs individual based.

Navyguy

 

[Parker]

What if everybody doesn't showup (ie sick/injured/late);
Last minute/late entries;
Types of tournaments (round robin, single elimination, double elimination, etc);
Making it multipurpose (darts, tennis, martial arts, hockey, etc);
Team vs individual based.

Navyguy

Seems doable to me. You appear to have already overcome the first hurdle.... analysing the whole problem in order to break it down into smaller problems.

Take the quote above. You could make the last three Tables that way you could pick from the tables and design your tournament in a form.

What if everybody dosn't show up,etc.? ...... A double registration process.

• 1) each entrant to register entrance as either an individual contestant ar as a member of a team.
  2)Each registered entrant to register attendance

That way you can have Access process the information and produce a list of competition both in advance and modified on the day to take into account attendance, late entries etc.