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

Tuesday, April 12, 2016

Customer Database

Executive Summary

For my project, I built user forms to assist my brother with
his new start up. He is trying to introduce a new way for organizations (e.g.
schools, sports teams, scout troops, etc.) to raise money. Rather than the kids
going door to door and selling something to people, the kids will take a
brochure to people. On this brochure, there is a list of approximately 75
different services that people could be interested in purchasing in the coming
months. Some examples of these services include lawn care, new dentist, new
car, and many other differing items. The brochure asks people to mark any of
these services that they are interested in purchasing and explains to them that
their names will be sold as leads to local businesses in order to raise money
for the local organization.

My project is designed to help my brother’s new company to
create a database in order to keep track of the 1) the organizations they are
working with, 2) the individuals within that organization and 3) customers
leads that can potentially be sold to local businesses. I decided to write a
User Form that would ensure that all the correct information was entered, and
that would minimize the amount of data entry that would have to happen. It also
keeps track of some statistics that the company will hopefully find useful.