A member-supported not-for-profit organization whose mission is to to inspire and assist residents of their county in creating, strengthening, and preserving a healthy environment had been relying on an application developed in¬† Microsoft Access for managing their membership. We made changes to the database to facilitate an improved membership renewal process. We also included changes to track both a member’s renewal date and also the date that they first became a member. We enhanced the user interface to minimize errors and streamline the reporting features.

The organization grew its membership by 60% in less than one year through the process improvements made possible with these software enhancements.

A not-for-profit environmental education center developed an application using Microsoft Access for managing membership. The database had some problems with referential integrity and needed some design changes. The queries for renewals, forms for data entry, and reports also needed some improvements.

We looked at their processes and procedures and made enhancements to the system to support their operations. We also cleaned up the data and put controls in place to improve the ease-of-use.

We learned that Microsoft Access can be very useful in small office settings but the support of skilled IT Professionals can increase an organization’s return on their technology investement. It also makes more sense to spend some time designing a database correctly from the beginning than to repair it due to a faulty design after it contains vital data.