Objective IT Create SQL Database to Systemise Membership Renewals and Payments for the Confederation of Roofing Contractors
CORCs previous Access database had served the team well since the company established in 1985, but with the system quickly approaching 700 members, a number of issues began to arise.
These issues included having to manually create letters and invoices, inability to pre-populate like fields and being unable to upload documents.
Objective have since created a new and updated system to allow the company to record membership statuses: pending/current/ceased and the ability to efficiently add new members. The new and improved system also makes it easier to process renewed memberships without rekeying information in.
Membership renewals and invoicing are now an integral element of the database. Payments by instalment can be tracked and renewal dates are automatically updated once payment has been received.
A new document uploading facility to securely store documents and invoices was also created as part of the project, which is accessible to the whole team as a single member view.
Karen Harding, Project Manager at Objective, said: CORC now has a future-proof web-database that has integrated the way membership renewals and payments are processed.
*With a single member view, the team can easily track and communicate with new and renewed members.
Objective IT is a leading software development company based in Chelmsford, Essex and serving clients throughout the UK. Specialising in building forward-thinking bespoke software, cross-platform mobile and tablet apps, Objective has remained a respected Microsoft Partner since 1992.
The company also offers data analytics services.
For further information on how Objectives data scientists can benefit your business please contact the team today.
Contact: Karen Harding, Marketing Manager
Telephone: 01245 330360