User-Friendly Senior Center Database

I want a rock-solid, easy-to-use database that even our least tech-savvy volunteers can navigate without fear of breaking anything. The database will support our senior center’s membership program, storing contact details, payment dates, emergency numbers, special interests, and similar fields. A clean, guided form interface is essential so staff never see raw tables—just simple buttons and drop-downs.

I’m happy to use whichever platform delivers the simplest user experience; Microsoft Access with locked-down forms, a MySQL back-end paired with a no-code front-end, or another lightweight solution are all fine as long as the interface stays friendly.

Access control must follow three roles:
• Admin – full control to design, add fields, and run every query
• Data Entry – can add/edit member records through forms only
• Viewer – read-only access for quick look-ups and printed reports

Core functionality
• 15–20 ready-to-run queries: upcoming birthdays, renewals due this month, lapsed members, mailing labels, custom date ranges, and basic statistics (total active, new joins per quarter, etc.).
• Validated input forms with drop-downs, required-field checks, and tooltips to cut down on typos.
• Printable reports generated from the key queries for board meetings.
• A simple backup/restore routine so we never lose data.

Acceptance criteria
1. All queries return correct results against a supplied sample data set.
2. Each role sees only its permitted screens and actions.
3. No direct table editing is possible for Data Entry or Viewer roles.
4. Clear step-by-step instructions (PDF or inline help) for adding new members and running reports.

Hand-off deliverables: the completed database file(s), sample data, and the short user guide. If you have suggestions that keep things even safer or simpler, I’m all ears.