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
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
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 TRIALMembers 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.
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.