MARKS

(Microsoft Access Rugby Keeping System)

 

 

 

 FREE INSTALLATION AND DEMONSTRATION TRIAL OFFER

Please EMAIL davidbohl@virginmedia.com 

 

1. Introduction

 

Welcome to MARKS, a screen based database system for the efficient running of a Rugby Club.

Utilising the very latest of computer software, the Microsoft ACCESS database and Windows operating system will look after your Membership, Fixtures, Results, Player History, Team Selection, Annual Subscriptions and Function Room Hire.

ACCESS is fully portable to any PC or Laptop, data being easily transferred to and from other products such as Microsoft WORD, Microsoft EXCEL.

The system supports a complete Reporting and Listing facility and pays particular attention to security, system backup/ restore, Database auditing and Year End processing.

 

 

2. System Features

 

2.1 Menus

2.2 Screen Forms

2.3 Reporting

2.4 System Administration

2.5 Input Documents

 

 

2.1 Menus

 

2.1.0 MEMB - Membership Maintenance

2.1.1 CLUB - Rugby Club Addresses

2.1.2 SEL - Team Selection

2.1.3 MATCH - Match Results

2.1.4 PLAY - Player History

2.1.5 FIXT - Fixture List Maintenance

2.1.6 RES - Results Table Maintenance

2.1.8 FUNC - Function Room Hire

2.1.9 ACT - Action Lists

2.1.10 TRN - Financial Transactions

2.1.11 RPT - Report Generation

2.1.12 CTRL - Control Table Maintenance

2.1.15 YRE - Year End Processing

 

 

This is the Main Menu of the system and allows the user to request the relevant sub-menu by clicking the mouse on the associated button.

 

 

2.1.0 MEMB - Membership Maintenance

This sub-menu allows the user to set up the Membership Type table, e.g. Life Members, Senior, Social. Following on from this members data may be inserted, changed, deleted and listed, a profile screen shows brief personal data, player history, financial transactions and any outstanding action lists. At year end annual subscriptions may be re-set ready for the new season.

 

 

2.1.1 CLUB - Rugby Club Addresses

This sub-menu allows the user to access the Rugby Clubs Table, and enquire, change, delete and list the information regarding telephone numbers, addresses, Committee members of other clubs.

 

 

 2.1.2 SEL - Team Selection

This sub-menu allows the user to initiate the Team Selection process. For each team up to 19 players may be selected, a unique fixture number is generated and fixture details such as the opposition, fixture date and venue.

 

 

2.1.3 MATCH - Match Results

This sub-menu allows the user to post results information onto the Team Selection details. All try, conversion, penalty goal and drop goal data is transferred to the Results and Player History tables. Playing position and Team number is posted to the Members table.

 

2.1.6 RES - Results Table Maintenance

This sub-menu allows the user to access the Results table. In normal circumstances this table is automatically maintained from the Match Results table, however entries may be added, changed, deleted and listed.

 

 

2.1.4 PLAY - Player History

This sub-menu allows the user to access the Player History table, insert new history, change existing details, delete and list. In normal circumstances this table is maintained automatically from the Match Results screen.

 

 

 2.1.5 FIXT - Fixture List Maintenance

This sub-menu allows the user to access the Fixture Table and add new fixture information, change existing details, delete old entries and list. Fixture Information is usually input via the Team Selection menu which allocates a fixture number automatically. A calendar screen maps out fixtures for a requested month.

 

 

2.1.8 FUNC - Function Room Hire

This sub-menu allows the user to access the Club Function Hire Table and add new bookings, change existing details, list bookings, remove old entries. A calendar screen maps out the bookings for a requested month.

 

 

2.1.9 ACT - Action Lists

This sub-menu allows the user to enquire onto the Action List Table, post new items, alter existing entries and delete information that has become obsolete.

 

 

2.1.10 TRN - Financial Transactions

This sub-menu allows the user to set up the Transaction Types table e.g. Membership Fee, Petty cash, Disco hire. Once set up Financial transactions may be viewed, inserted and deleted. Changing details is not recommended, a reversal of the entry is the usual practice.

 

 

2.1.11 RPT - Report Generation

This sub-menu allows the user to request reports and lists. Once initiated a parameter screen appears to which the user tells the system where to send the print, either to the screen, to a file or to a printer. Also the number of copies to print.

 

 

2.1.12 CTRL - Control Table Maintenance

This sub-menu is for the attention of the System Administrator only. It enables the S/A to set the Header information displayed on the screens and set the points values of tries and penalties should the RFU change them.

 

 

2.1.15 YRE - Year End Processing

This sub-menu is for the attention of the System Administrator only. When all year end reports have been run off and the data suitably archived, the old Fixture, Results, and Player History information may be deleted.

 

 

 

2.2 Screen Forms

 

2.2.1 memb_enq - Member Table Enquiry

2.2.2 memb_updt - Member Table Update

2.2.3 memb_lis - Member Table List

2.2.4 memt_updt - Membership Type Update

2.2.5 memb_prof - Members Profile

2.2.7 clubs_enq - Rugby Clubs Enquiry

2.2.8 clubs_updt - Rugby Clubs Update

2.2.9 clubs_lis - Rugby Clubs List

2.2.10 sel_enq - Team Selection Enquiry

2.2.11 sel_updt - Team Selection Update

2.2.12 club_cal - Monthly Calendar

2.2.13 match_enq - Match Results Enquiry

2.2.14 match_updt - Match Results Update

2.2.15 play_enq - Player History Enquiry

2.2.16 play_updt - Player History Update

2.2.17 play_lis - Player History List

2.2.18 fixt_enq - Fixture Table Enquiry

2.2.19 fixt_updt - Fixture Table Update

2.2.20 fixt_lis - Fixture Table List

2.2.22 res_enq - Results Table Enquiry

2.2.23 res_updt - Results Table Update

2.2.24 res_lis - Results Table List 

2.2.27 func_enq - Function Table Enquiry

2.2.28 func_updt - Function Table Update

2.2.29 func_lis - Function Table List

2.2.32 action_enq - Action List Enquiry

2.2.33 action_updt - Action List Update

2.2.34 actd_updt - Action List Tidy

2.2.35 trans_updt - Transaction Update

2.2.36 trant_updt - Transaction Description Table Update

2.2.37 trand_updt - Transaction Tidy

2.2.38 cont_enq - Control File Enquiry

2.2.39 cont_updt - Control File Update

2.2.40 endyr_updt - Delete last years information

2.2.41 hist_try_graph - Top Point Scorers Graph

2.2.42 hist_graph - Player History Graph

2.2.43 memt_graph - Membership Types Graph

2.2.44 posn_graph - Tries by Position Graph

2.2.45 res_graph - Results by Team Graph

2.2.46 teamres_graph - Results Pie Graph

2.2.47 resum_graph - Results Summary Graph

2.2.48 winloss_graph - Win/Loss by Team Graph

 

 

  

 

 

2.2.1 Member Table Enquiry

2.2.2 Member Table Update

 

 

2.2.3 Member Table List

 

 

2.2.4 Membership Type Update

 

 

 2.2.5 Members Profile

 

 

 

 

 

2.2.7 Rugby Clubs Enquiry

2.2.8 Rugby Clubs Update

 

 

 

2.2.9 Rugby Clubs List

 

 

2.2.10 Team Selection Enquiry

2.2.11 Team Selection Update

 

 

2.2.13 Match Results Enquiry

2.2.14 Match Results Update

 

 

 

2.2.15 Player History Enquiry

2.2.16 Player History Update

 

 

2.2.17 Player History List

 

 

2.2.18 Fixture Table Enquiry

2.2.19 Fixture Table Update

 

 

2.2.20 Fixture Table List

 

 

 

2.2.22 Results Table Enquiry

2.2.23 Results Table Update

 

 

2.2.24 Results Table List

 

 

 

2.2.27 Function Table Enquiry

2.2.28 Function Table Update

 

 

2.2.29 Function Table List

 

 

2.2.31 Monthly Calendar

 

 

2.2.32 Action List Enquiry

2.2.33 Action List Update

 

 

2.2.34 Action List List

 

 

2.2.35 Transaction Update

 

 

 

 

2.2.36 Transaction Description Table Update

 

 

2.2.38 Control File Enquiry

2.2.39 Control file Update

 

 

2.2.41 Top Point Scorers Graph

 

 

2.2.42 Player History Graph

 

 

 

2.2.43 Membership Types Graph

 

 

 2.2.44 Tries by Position Graph

 

 

 2.2.45 Results by Team Graph

 

 

2.2.46 Results Pie Graph

 

 

 

2.2.47 Results Summary Graph

 

 

2.2.48 Win/Loss by Team Graph

 

 

 

 

 

2.3 Reporting

 

 

2.3.1 SF03 Membership List - Full

2.3.2 SF04 Membership List - Selective

2.3.3 SF01 Membership Report - Full

2.3.4 SF02 Membership Report - Selective

2.3.5 SF05 Committee List

2.3.6 SF06 Players List - Full

2.3.7 SF07 Players List - Selective

2.3.8 SF10 Players List - By Playing Position

2.3.8a SF11 Players List - Registered with League

2.3.9 SF30 Fixture List - Full

2.3.10 SF31 Fixture List - Selective

2.3.11 SF40 Team Selection - Full

2.3.12 SF41 Team Selection - By Date

2.3.13 SF50 Team Match Results - Full

2.3.14 SF51 Team Match Results - By Date

2.3.15 SF52 Results List - Full

2.3.16 SF53 Results List - Selective

2.3.17 SF54 Results Summary - Full

2.3.17a SF55 Fly Half/Full Back Analysis - By Team

2.3.18 SF60 Player History Report - Full

2.3.19 SF61 Player History Report - By Member No.

2.3.20 SF62 Player History Report - By Team No.

2.3.21 SF63 Player History List - Scorers

2.3.22 SF64 Player History List - Scorers by Team No.

2.3.23 SF65 Player History List - Top Point Scorers

2.3.24 SF90 Rugby Clubs Report - Full

2.3.24a SF92 Rugby Clubs Report - Selective

2.3.25 SF91 Rugby Clubs List - Full

2.3.26 SF23 Functions List - Full

2.3.27 SF24 Functions List - Open

2.3.28 SF20 Functions Report - Full

2.3.29 SF21 Functions Report - Open

2.3.30 SF70 Action List - Full

2.3.31 SF71 Action List - By Status

2.3.32 SF72 Action List - By Member

2.3.33 SF80 Financial Transactions - Full List

2.3.34 SF81 Financial Transactions - By Type

2.3.35 SF82 Financial Transactions - By Date

2.3.36 SF83 Financial Transactions - By Date and Type

2.3.37 SF84 Financial Transactions - Type Descriptions

2.3.38 SF09 Members List - Subs Not Paid

2.3.39 SF08 Members List - Subs Paid

2.3.40 GR01 Top Points Scorers Graph

2.3.41 GR02 Player History Graph

2.3.42 GR03 Membership Types Graph

2.3.43 GR04 Tries by Position Graph

2.3.44 GR05 Team Results Graph

2.3.45 GR06 Results Summary Graph

2.3.46 GR07 Team Win/Loss Graph

 

 

2.3.1 Membership List - Full

 

 

 2.3.2 Membership List - Selective by Member Type

 

 

 

 

 

2.3.3 Membership Report - Full

2.3.4 Membership Report - Selective by type

 

 

 2.3.5 Committee List

 

 

 

2.3.6 Players List - Full

2.3.7 Players List - Selective by Team No.

 

 

2.3.8 Players List - By playing position

 

 

 

 

 2.3.9 Fixture List - Full

2.3.10 Fixture List - Selective by Team

 

 

2.3.30 Action List - Full

2.3.31 Action List - by Status

2.3.32 Action List - by Member

 

 

2.3.11 Team Selection - Full

2.3.12 Team Selection - Selective by Date

 

 

2.3.13 Team Match Results - Full

2.3.14 Team Match Results - By Date

 

 

2.3.15 Results List - Full

 

 

2.3.16 Results List - Selective

 

 

 

 

2.3.17 Results Summary - Full

 

 

2.3.18 Player History Report - By Member No.

 

 

 

 

 

2.3.23 Player History List - Top Point Scorers

 

 

2.3.22 Player History List - Scorers by Team No

 

 

 

 

 

2.3.25 Rugby Clubs List - Full

 

 

2.3.24 Rugby Clubs Report - Full

2.3.24a Rugby Clubs Report - Selective

 

 

2.3.26 Functions List - Full

2.3.27 Functions List - Open

 

 

2.3.28 Functions Report - Full

2.3.29 Functions Report - Selective

 

 

2.3.33 Financial Transactions - Full

2.3.34 Financial Transactions - By Type

2.3.35 Financial Transactions - By Date

2.3.36 Financial Transactions - By Date and Type

 

 

2.3.37 Financial Transactions - Type Descriptions

 

 

2.3.38 Members List - Subs Not Paid

 

 

2.3.39 Members List - Subs Paid

 

 

 

2.3.17a Fly Half/Full Back Analysis - By Team

 

 

2.3.40 Top Points Scorers Graph

 

 

2.3.41 Player History Graph

 

 

2.3.42 Membership Types Graph

 

 

2.3.43 Tries by Position Graph

 

 

2.3.44 Team Results Graph

 

 

2.3.45 Results Summary Graph

 

 

2.3.46 Team Win/Loss Graph

 

 

 

 

2.4 System Administration

 

2.4.1 Database Security - The system is protected by a two tier security system.

Each user is assigned a logon identifier to which they add their own personal password.

The System Administrator then assigns the user certain privileges such as enquiry only (no updating allowed), edit (changes may be made) or a mixture of both

All or parts of the Database may be accessed accordingly.

 

2.4.2 Year End Processing - After the season finishes it is necessary to clear out the old information ready for the coming new season. Fixtures, Results, Player History is removed via menu YRE, this option is only allowed by the System Administrator.

 

2.4.3 Database Auditing - Every 'Change' operation on the Database is automatically logged in a Audit File. The System Administrator may then monitor the Transactions made upon the Database. Items recorded are :-

 

User

Date and Time

The Table

Transaction Type (Add, Change, Delete)

A Reference No. (Usually the Record Key)

 

 

 

 

2.5 Input Documents

 

 

2.5.1 Membership Details

2.5.2 Team Selection and Match Results

2.5.3 Function Room Hire

2.5.4 Financial Transactions

2.5.5 Action List input

 

 

 

2.5.1 Membership Details

 

 

2.5.2 Team Selection and Match Results

 

 

 

2.5.3 Function Room Hire

Copyright Notice

MARKS. Copyright © 1994, David Bohl Computer Services Ltd.

All rights reserved.

 FREE INSTALLATION AND DEMONSTRATION TRIAL OFFER

Please email davidbohl@virginmedia.com

The software described in this document is furnished under license and may be used or copied only in accordance with the terms of such license. Items marked TM or ® are Trade Marks or Registered Trade Marks of their respective companies and/or products.