Posted: January 4th, 2016

Manage athletes details more effectively by eliminating duplications and time wasting, and reducing the possibility for errors

PART A – Group Work (50 marks)

A Race Results system can help athletics/sports organisations to bring together their athletes, races and results details in one system to help them increase motivation, track performance and manage club operations. Collecting results from the competitions for each athlete has always been difficult to achieve due to the disparate systems used by the organising parties and bodies involved with athletics.

To date Athletics Club has been recording athlete information and race results in an Excel file (see document provided). When the organisation first started operating the Excel spreadsheet was adequate for their needs. However, as they continued growing the Excel file has become difficult to manage. It also does not allow the organisation to maintain records of race results in an effective and efficient manner.

Therefore, you are required to design a Race Results system using Microsoft Access 2010 which will:

• Manage athletes details more effectively by eliminating duplications and time wasting, and reducing the possibility for errors
• Provide all athlete and competition information in one place that is easily accessible and easy to use
• Find information about athletes’ performances/results through various queries/reports
• Ensure that athletes’ level of motivation is high by publishing race results