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 13, 2010

Home Salon Management System

This project involved the creation of an Excel workbook intended to be used as a database and management system for running a home salon. The final product began essentially as an ‘upgrade’ to an existing workbook used by my sister who works as a hairdresser out of her home. The old workbook was outdated and ‘clunky’ with various glitches occurring. The old workbook used only worksheet formulas to keep track of basic income and expenses on a monthly basis with summary information on a master sheet. The new workbook created for this project provides all the functionality of the old workbook with improved ease of use as well as additional useful functions and features. The new workbook uses multiple user forms to make it easier to enter income and expenses to better manage the finances of a home salon business and the worksheet have a much improved appearance. Additionally, the new workbook adds functionality to store data such as contact info, hair color formulas, notes, etc. on all clients entered in the client data worksheet. Information on each client is conveniently displayed and can be edited on a user form, where new clients can also be added and managed. The user can also choose to send e-mail and text alerts to clients reminding them of their next appointment.

Excel Project: Excel Workbook
Project Write-up: PDF Document

No comments:

Post a Comment

Blog Archive