Tennis League

[iankerry]

Hi All

I have been reading up on access and have done a little programming though it was a while ago.

I need to manage a small tennis league, 3 divisions, men women mixed, etc. When results come in from a tennis match i want to type them in and for the database to produce league tables.

I have made a few starts with varying success, but I wanted to check out some basics with someone who understands more than I.

I started with a

table called TEAMS with teamname, divisionnumber, menwoman, etc. and a
table called FIXTURES with date, team1 (taken from TEAMS) team1score, team2 (taken from TEAMS) teams2score.

However I am not convinced this is the best way to start? for instance how can I relate the two tables? I would want to use teamname but as this appears twice in the FIXTURES table how can i relate them?

Any early advise really appreciated.

Ian

 

[iankerry]

Have found enough info on the site to keep me going - searched on Fixture and found some good posts.
thanks.

 

[The_Doc_Man]

Required reading (or at least it should be): Look up articles on DATABASE NORMALIZATION using Access Help, Wikipedia (.org), and Google searches. For the latter, limit yourself to .EDU sites with reasonable reputations.

Then in Access, look up things such as relationships (one-many and many-one), forms (parent/child), and JOIN queries.

Queries are your friends. Base reports on them. Forms, on the other hand, may sometimes need to be based on the raw underlying tables and just let the form/sub-form relationship keep the tables straight. There are some authorities who would disagree with basing forms on tables. To me it is a matter of pragmatism. Nobody would disagree with basing reports on queries, though.

 

[iankerry]

Thanks very much - I'll do some research. One of the downloads proved really interesting in showing me hows things work. great site.

Ian

 

[FilipeT]

tennis league help

Dear Ian:

I'm also starting a very simple database to manage a tennis tournement (round robin style) in my company. I'd apreciate your advices in searching samples that could help me, since i'm just starting with access db and the tournament is expected to go live in october

Bye for now

Thanks very much - I'll do some research. One of the downloads proved really interesting in showing me hows things work. great site.

Ian