Pro5 is a Bristol based 5aside football league based at The Beeches in Brislington - database and excel project.
Member rating: No Rating | Words: | Submitted: Fri Jan 28 2005
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
Pro5 Database and Excel Project Contents Page No. Title Page 1 Contents Page 2 Background 3 Identification of Users 4 Interview 4 User Needs 4 Limitations 5 Justification For Possible Solution 5 Objectives Of New System 5 Data-Flow Diagram (Existing System) 6 Entity Relationship Diagram 6 Data-Flow Diagram (Proposed System) 6 Design Overall System Design: 7 Database Design 8 Definition Of Data Requirements 8 Design Of Input Forms 9 Report Design 10 Mail Merge 10 Queries 11 Menu Design 11 Systems Flowchart 11 Mail Merge Design 12 Security 13 Test Strategy 13 Testing 13 Testing 14 Testing 15 System Maintenance System Overview 15 Tables and Relationships 15 Forms 16 Queries 19 Reports 19 Mail Merge 19 Formulas 19 Discussion Of Test Results 20 User Documentation Attached as Appendix 3 Appraisal 20 Users Appraisal 21 Extended Project 21 Final Thought 21 Appendix 1 (Testing Information) Appendix 2 (Pre-Database Form Designs) Appendix 3 (User Documentation) Background Pro5 is a Bristol based 5aside football league based at The Beeches in Brislington. It provides leagues and 5aside football courts for the public use. The problem with Pro5's current system is it is paper-based. The documents are stored in filing cabinets. Players who wish to register with Pro5 must complete a registration form, which is then filed into the appropriate team. The appropriate team is then placed in a league, with the fixtures and results worked out by hand. The system is very inefficient, creates a large amount of...


