Automating Church Register

1.      Executive Summary

My dad is the secretary of our local church. Currently he is maintaining church records on paper/books. This application I am creating would provide forms for data entry/update and deletion of basic entities to be maintained for church. It is not a comprehensive solution but a small subset as a first step towards moving away from paper/books.

In Scope

a.                        Display understanding and usage of the following in VBA

a.      Forms and basic controls

b.      Event Handling

c.       Control loops

d.      Variable/sub/function scope

e.      Basic spreadsheet capabilities

f.        Reading data from spreadsheet to form

g.      Writing data to spreadsheet from a form

h.      Searching for data within spreadsheet programmatically.

    Not in Scope

a.      Detailed validations and advanced controls ( like calendar control)

b.      look and feel

c.       Through/complete church management functionality

2.      Functionality

The application will provide the following capabilities

1.      Add  a family & family details

2.      Search for a family

3.      Update family details

4.      Mark a family as deleted/removed

5.      Add family members

6.      Search/browse  family member list

7.      Update family member details

8.      Mark a family member as deleted/removed

9.      Register Birth, death, marriage

1.     Issue  birth/marriage/death certificate


http://files.gove.net/shares/files/12w/ajoabrah/ChurchRegisterProject.xlsm
http://files.gove.net/shares/files/12w/ajoabrah/MBA_614_Project_writeup-Ajo_Abraham.pdf