I'm a church secretary, and my church wants me to create a new database with Access (which we already have one that does everything we need, it's called Church360). It needs to have events, such as church services, that I can tag attendees afterward. It also needs to be able to track offerings with several accounts.
I set up the members in Access, I also set up a separate table for the whole families that I can tag them to. Is there a way to set up relationships between individuals, who will each have their own line in the Members table?
Should I just make an Excel table to track attendance? How could I connect it to the Access table?
We also need to track offerings, with several different accounts.
I set up a 2024 calendar in Outlook, with all the worship services, can it connect to Access and track attendance from there?
Also, all church events have a liturgical color. Lent is coming up, it's purple, Easter is white, after Easter is Pentecost which is green for half the year, Advent is blue, and there are a few red and black days around the year. Is there a way I can change the color of individual events in Outlook Calendar, or just the theme of all of it? I was able to change liturgical colors in Google Calendar, but I don't know how to connect any of it to Google. Not that I can do it in Microsoft either!
tbh I kind of feel like I'm being asked to reinvent the wheel, but the guys would like to save about $500/year and use Microsoft. I'm personally not sure it's worth it because it won't do all that the old program can do, PLUS the old program does the Annual Reports for me!
Thank you for your help.