I'm going to be helping a non-profit youth organisation to modernise their IT systems, which includes moving their current 50,000-entry membership database (names/addresses/emails) from an old Access database into something that will simplify administration and enable concurrent use, etc, simplify mail merges and e-mail blasts etc. There are 150 staff, but whilst most of these will not need access to the member databases, I think we're still looking at around 25 staff who will, including the 4 IT staff.
Something that might help here is that they've recently been moved over to Office 365 (not sure which licence). There is an educational theme throughout the organisation's work, but I'm not sure whether they qualify for Education licenses. I will learn this at our first meeting.
The above does involve the personal details of children, so this will need to be a consideration.
Before the meeting, I just want to research a few options that might be available to them, therefore I would appreciate if you could suggest some options for what format their new database might take. The way I see it, here are some possible options...
# Putting them all as contacts in Office 365 (cut-down option for zero cost)
# Outlook Customer Manager (if they have Office 365 Business Premium)
# Getting something built in Microsoft Dynamic 365
# Buying an Azure SQL instance, and writing some sort of web-based front-end for it
# Buying a fully-featured cloud solution like yourmembership.com
What are your thoughts on the above? And are there any other options?
I realise that a lot of the above depends on what else they have in their domain that can be utilised, but until the first meeting I'm not sure. But for argument's sake, let's just say that they have very little in terms of current infrastructure. Of course I'm not asking for you to spec a solution, I'm just asking what are the good/popular solutions for this sort of thing currently, as I have limited experience in this specific area.