Piano Assistant

My mother, Alayne, has been teaching piano now for 10 years and continues to run her small little business through her memory and a notepad. She has had a various group of 15 to 20 students at any given time and often has trouble documenting fees, reminding students about lessons, and tracking her schedule. She does not get paid sometimes because people forget or she neglects to document the fees and payments. Also, students occasionally don’t show up because they forget or the time was not communicated. I realized that I could consolidate all of these activities by writing her a user friendly VBA program called APPA. This application, Alayne’s Personal Piano Assistant (APPA), allows my mother to easily manage student information, lesson scheduling, tuition expenses as well as sending automated reminders about lessons and tuition.


http://files.gove.net/shares/files/15w/mfavreau/APPA.xlsm
http://files.gove.net/shares/files/15w/mfavreau/email_Lesson_reminder.txt
http://files.gove.net/shares/files/15w/mfavreau/images.jpg
http://files.gove.net/shares/files/15w/mfavreau/Final_write_up.pdf