5-a-side football tournament

Tony McNally
Tony McNally used Ask the Experts™
on
Hi,

I am planning a 5 a-side tournament and would like a simple database of players, teams and matches up to the final and some forms.

I have simple sql experience in tables, relationships and sql and would like to be able to extract relative data from the database.

I would like to use the Microsoft Access database as I have it.

Do you know where i can get something like this?

Thanks,
Tony
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014

Commented:
I don't know of any free templates that would do this. The Players, Teams, and Matches would be fairly straight forward, but the "bracketing" could get tricky depending on the rules required.

tblPlayers
--------------------
PlayerID
PlayerName
etc

tblTeams
TeamID
TeamName
etc

tblPlayers_Teams
PlayerTeamID
TeamID
PlayerID

tblMatches
MatchID
MatchDate
Team1
Team2
etc etc

That would allow you the basics to store Players, Teams, and Matches.

Author

Commented:
Thanks for the reply. I haven't started anything yet. I'm looking to having a try real soon

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start Today