These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Wednesday, April 11, 2012

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

No comments:

Post a Comment

Blog Archive