Membership Database 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.
Tags: Database Design, Membership, Not-for-Profit, Small Office, Software