Link to home
Start Free TrialLog in
Avatar of Tony McNally
Tony McNally

asked on

5-a-side football tournament

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
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

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.
Avatar of Tony McNally
Tony McNally

ASKER

Thanks for the reply. I haven't started anything yet. I'm looking to having a try real soon
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.