Expert guide
Church Membership Database in Microsoft Access
Know your people: households, attendance, groups, volunteers and giving in one place
Call us at +1 (385) 386-3860
Short answer: structure the database around People linked to Households, with separate tables for Attendance (per person per service or group meeting), Groups and memberships, Volunteer roles and rotas, Pastoral care (restricted access) and Giving. Reports then give attendance trends, people who have stopped attending, volunteer schedules, and year-end giving statements. We build these as custom Access databases for churches and community organisations.
Many churches keep members in one spreadsheet, the rota in another, attendance on paper and giving in the treasurer's workbook. Nobody can easily answer "who used to come every week and has not been seen for a month?" or "which families have children in the youth group and are not on the newsletter list?". A single Access database answers those questions while respecting that some information, particularly pastoral care notes, must stay private.
The Tables
| Table | Key fields | Notes |
|---|---|---|
| tblHouseholds | HouseholdID, MailingName, Address, Phone | One per family or address |
| tblPeople | PersonID, HouseholdID, Name, Role in household, DOB, Email, Mobile, MemberStatus, JoinedOn | One per individual |
| tblServices | ServiceID, Date, Type (Sunday AM, Midweek, Youth, Event) | Each gathering |
| tblAttendance | ServiceID, PersonID | One row per person present |
| tblGroups / tblGroupMembers | Group, Leader, MeetingDay; PersonID, Role, JoinedOn | Small groups, choirs, ministries |
| tblVolunteerRoles / tblRota | Role; Date, Role, PersonID | Who serves when |
| tblPastoral | PersonID, Date, Type, Note, RecordedBy | Restricted access |
| tblGifts | PersonID or HouseholdID, Date, Amount, Fund, Method | Treasurer access |
Fast Attendance Entry
A check-in form listing regular attenders with tick boxes, filtered by service type.
A search box to add visitors, creating a new person and household in one step.
Headcount-only option for large services, with named attendance for groups and children's ministry.
Children's check-in with guardian and allergy notes visible to leaders only.
The Most Useful Report: Who Has Drifted?
qryRegularsNotSeen:
SELECT p.PersonID, p.Name, p.Mobile, Max(s.ServiceDate) AS LastSeen,
Count(a.ServiceID) AS VisitsLast6Months
FROM (tblPeople AS p
INNER JOIN tblAttendance AS a ON p.PersonID = a.PersonID)
INNER JOIN tblServices AS s ON a.ServiceID = s.ServiceID
WHERE s.ServiceDate >= DateAdd("m", -6, Date())
GROUP BY p.PersonID, p.Name, p.Mobile
HAVING Count(a.ServiceID) >= 10
AND Max(s.ServiceDate) < Date() - 35
ORDER BY Max(s.ServiceDate);People who attended at least ten times in six months but not in the last five weeks. Share the list with pastoral leaders weekly; a phone call from someone who noticed means a great deal.
Other Reports Leaders Ask For
| Report | Purpose |
|---|---|
| Attendance trend by service | Average per month, year over year |
| First-time visitors and returns | How many visitors came back within six weeks |
| Group participation | Members not in any small group |
| Volunteer coverage | Rota gaps in the next eight weeks, people serving too often |
| Birthdays and anniversaries | Pastoral and welcome team prompts |
| Giving statements | Annual statement per donor |
Volunteer Rotas
Store availability and preferred frequency per volunteer, then build the rota as rows of date, role and person. A query flags gaps and people scheduled more often than they asked. A report per volunteer, emailed monthly, reduces the "I didn't know I was on" problem.
Emailing personalised schedules from Access is shown in sending email from Access with Outlook VBA.
Privacy and Permissions
Split the database and give different front ends to the office, pastoral team and treasurer.
Keep pastoral notes and giving in tables only certain front ends can open, or in a separate back end with restricted folder permissions.
Record consent and contact preferences, and respect them in every mailing query.
Store children's data minimally, and follow your safeguarding policy.
Back up regularly and keep backups secure.
Where AI Can Help a Church Office
Drafting welcome messages to first-time visitors from the check-in details.
Summarising volunteer availability replies into the rota format.
Writing the weekly notices from a list of events.
Personal and pastoral information should not be sent to public AI tools; keep AI use to drafting and administrative text, or consider a private local model. The giving side shares much with our nonprofit donor tracking guide, and the attendance structure with school attendance tracking.
FAQ
Church membership database FAQ
People, attendance, groups and giving