Access Church Giving Database

I need a brand-new Microsoft Access file that lets our small church keep all giving information in one place. The database should open with a simple membership form where I can manually add or update each giver’s name, address and contact details. Every giver must have a unique ID so that offerings entered later will always link back to the correct person. A second form will record each offering. When I choose the member’s name, the form should automatically pull in their ID; I then select the fund from a drop-down list that starts with Tithe, Building Fund, Missions, Mercy Ministries and Other. I also need the option to add new fund names on the fly without touching the table design, plus a memo area for special notes. From these two tables I want to run three practical reports: • a weekly offering report that shows totals by fund, • an individual member donation history I can print at any time, • and an annual donor summary that is letter-ready for year-end contribution statements. I’m entering everything by hand, so the screens have to be clean and fast: tab order logical, dates defaulting to the current Sunday, and fund selection available by mouse or keyboard. Queries that drive the reports should already be saved in the database, and the finished file needs to work in the current retail version of Microsoft Access with no extra add-ins. Once the file arrives I’ll populate it with real data and run the reports; if all three print correctly with sample data, the project is complete.

Project ID: 40202190