Oxford Sailing Club
Oxford Sailing Club needed a full re-write of their membership system.
The brief
The database structure for the old membership system no longer reflected current practice. The whole system needed to be redesigned so that it met current business needs. The old data had to be migrated to the new database. Flexibility in reporting was important, e.g. the ability to email family members who had a particular type of boat.
What we did
We had a number of meetings with individuals from the sailing club to understand their requirements. From this we produced a detailed specification. Once this was accepted we built the new database. We populated it with test data and tested it. When OSC was happy with this we migrated the old data so that they were without their database for the minimum of time.
Features
The application allows an administrator to process membership renewals and keep track of the usage of lockers, windsurfing vests and boats in the dinghy park. The system is totally menu-driven. There are screens to manipulate the meta-data which allows the club to add more lockers, say, as needed.
Technical notes
The whole application was written in Microsoft Access. There was no need for multi-user capability. The ability to export data to a spreadsheet or for an emailshot was particularly useful.