Membership data - suggestions?

[oxist258]

Hopefully this is in the right section - all advice will be gratefully received!

I have received taken over as a membership secretary for a small sporting charity (approx 150 members at the moment), and I'm looking for software that will allow me to keep track of membership details. Aside from the obvious need to store member contact details/information, I'd like to be able to identify mailing lists based on role in the organisation (ie, athlete/volunteer/official) or the club that people are involved in. Also, as individual membership will run from different dates, it would be useful to have an alert when each membership is due for renewal (ie, that I could set for two weeks in advance and give myself time to post out a new form and collect in membership fees).

Any suggestions/advice would be much appreciated - thanks in advance.

Cat

 

[londonbairn]

Since it's small, I would probably end up doing it in Access with simple forms (the default form could be a dashboard which would flag up who needs to renew) and forms for reporting and editing. Reporting would allow you to generate letters quite easily if needed or ad-hoc lists. Keep the data stored on a share and the front end on the PC(s).

Would need a good grasp of VBA to make it effective I would say however.

Alternatively, a cruder way is to track it in Excel, you could manage most of it using Excel formulae, and generation of letters using Word Mail merge, but I would do it in Access.