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. 

No comments:

Post a Comment

Blog Archive