Access Database Team Statistic
Budget - $ 20-100
Rugby League Database Overview
The database needs to structured in such as way as to allow the user to query the information:
By Date & Team and Produce Team Sheets Scores, scorers of tries goal & drop-goals
Produce a seasonal report on all players, appearances, tries, goals & dop-goals
How may times did \"Joe Bloggs\" [input entered name] play for Team Name.
In a full career how many times and for which clubs which positions did [input entered name] play.
List the names of the players and their dates they played, positions & teams. Have the option here to select all or select all players whose Last Name begins with A or B or C or D or E, etc.
The attached PDF quotes seasons as traditionally Rugby League was played in the winter months, so therefore spanning 2 years. Season 1979-80 refers to the season commencing 19th August 1979 and ending 16th April 1980.
ATTACHED DATA
Top Sheet of Page
Date: Date Game was played
h-a: whether the game was a home (h) match or an away (a) match.
L-C: Whether the game was a League or Cup Match.
Score: say 9-29 always Team score first
Tries: Try scorers for the Team by the player (listed)
Goals: Goal scorers for the Team by the player (listed)
Drop-Goals: Drop goals scored for the Team by the player (listed)
Note:
After 1897 all points scored were standardised to: All Tried to 3 points & All goals 2 points.
After 1974 all drop goals reduced from 2 points to 1 point.
After 1983 all tries scored increased points from 3 points to 4 points.
Keywords - Access | Database | Development
