J
Jr Barron
I need to make a database for my local pool league to keep statistics. I sat
down and went over again in my head what data I have to input and what data
I need to have on output.
INPUT:
Players (First, Last Name) (only one time when they join league)
Teams (Team Name, Venue) (only one time when they join league)
Venues (Name, Location, Phone) (only one time when they join league)
Sessions (Name, Start Date, End Date) (between each session)
Player Results (Games won, Points) (weekly)
Matches (Date, Home team, Away team, Venue) (between each session) &
(weekly)
Team-Players (TeamID, PlayerID, SessionID)
OUTPUT:
Player Standings
Team (Id, Name)
Player (First, Last name)
Win (Sum Total)
Loss (Sum Total)
Points (Sum Total)
Average (Win / Games)
Rating (Points/Games) True Rating
Handicap (+1 or -1 >< 6.5)
Match Rating (Rating + Handicap) (only needed to calculate team handicap
when inputing players into scoresheet)
Team Standings
Team (ID, Name)
Weeks (Date COUNT? from schedule)
Rounds Won (After Handicap)
Rounds Lost (After Handicap)
Points (Sum Total) (with Handicap included)
Games Won (No Handicap)
Pct % (Rounds Won / Rounds)
I know the League Operator wants to spend as little time as possible
entering data, so I sure hope the Access gurus have a few tricks up their
sleeve for me.
Thanks so much for all the help.
Jr.
down and went over again in my head what data I have to input and what data
I need to have on output.
INPUT:
Players (First, Last Name) (only one time when they join league)
Teams (Team Name, Venue) (only one time when they join league)
Venues (Name, Location, Phone) (only one time when they join league)
Sessions (Name, Start Date, End Date) (between each session)
Player Results (Games won, Points) (weekly)
Matches (Date, Home team, Away team, Venue) (between each session) &
(weekly)
Team-Players (TeamID, PlayerID, SessionID)
OUTPUT:
Player Standings
Team (Id, Name)
Player (First, Last name)
Win (Sum Total)
Loss (Sum Total)
Points (Sum Total)
Average (Win / Games)
Rating (Points/Games) True Rating
Handicap (+1 or -1 >< 6.5)
Match Rating (Rating + Handicap) (only needed to calculate team handicap
when inputing players into scoresheet)
Team Standings
Team (ID, Name)
Weeks (Date COUNT? from schedule)
Rounds Won (After Handicap)
Rounds Lost (After Handicap)
Points (Sum Total) (with Handicap included)
Games Won (No Handicap)
Pct % (Rounds Won / Rounds)
I know the League Operator wants to spend as little time as possible
entering data, so I sure hope the Access gurus have a few tricks up their
sleeve for me.
Thanks so much for all the help.
Jr.