Charity Membership Database (GL/SB NAC 2005-2012)
| This Microsoft Access database improved access to and management of member and contact details, including a diary-based record of activity. The client had a series of Microsoft Access 2000 databases which had been developed internally and enhanced gradually over some time. The primary function of these databases was to store and report on their members and contacts and the data was largely used via various queries as a mail-merge source for Microsoft Word. There were in the region of 800 members of differing statuses.
vtl worked with the existing data to consolidate these files and make general improvements, including splitting the application in to a two-tier system and introduction of user-level security and the development of a diary facility for contact with members.
To enable the client to retain control over future enhancements and in the light of other related proposed developments within their IT strategy, Microsoft Access was retained as the development tool following discussion about the facts that although Access is not recommended by Microsoft as a multi-user database, there would be a maximum of 8 users, with only 3 inputting. It was deemed highly unlikely that they were attempting to access the same parts of the database simultaneously. To find out how we could make a project like this help your business, call +44 (0)1949 21 21 21 (show full list)
| 12 | Access | (A,M) |