Small scale database solution for managing cohort of 40/50 relationships?

Sending
User Review
0 (0 votes)

Hiya. I work at an arts nonprofit as a relationship liaison for our Trustees, which requires me to manage a lot of information. Most of it is biographical information (names, addresses, spouses, children, Alma maters, hobbies, life histories, headshots, etc), but it becomes quite cumbersome as there are 45+ trustees involved.

Currently all the information I’m working with lives in a really dense excel document. What I am hoping to move to is something a little more functional, with the ability to easily create new fields of information but in standardized formats and notation styles (think phone numbers all being recorded in same style, or birthdates following same articulation).

We do already have a CRM, Tessitura, which I have a lot of experience with, but in my opinion it’s actually overpowered for what I need — it’s geared far more towards sales, ticketing, and philanthropy/fundraising at scale. I don’t think it could easily support the level of detail I need without it being a massive headache on the backend.

Anybody have a recommendation? I’ve briefly researched Microsoft Access, but that seems to be desktop only. In order for it to have real institutional value I’d think it would need to be in cloud or another shared venue.

Thanks!

submitted by /u/dpx302
[link] [comments]