I work for a local church and our parish database is no longer fit for purpose. Any ideas on software that would keep records of parishioners with different groups (readers, musicians, cleaners, ministers) and so on.
I was cornered one day and ended up running one of the Curling Clubs that I play in. The Membership List had been "hand written" every year, so I planned something along the same lines as you.
Create an Up-to-date database that could be handed from Secretary to Secretary. I used M$ Access and congratulated myself that I could turn out all sorts of details at the drop of a hat. The next Secretary, but one, did not have M$ Office and the Database died.
Had I used a Free, or cheaper, Database, such as Open Office. That problem might not have arisen.