Executive
Summary
This
project was completed for the Brigham Larson Piano Academy Program Director.
She is responsible for keeping track of their music inventory, selling books to
students, ordering more books when levels get too low, and entering them back
into inventory when the order arrives. She also must keep track of checked-out
books and know which students’ books are over due, with the option to renew the
checkout. She desires to keep track of all previously checked-out books so that
students can later find favorite songs quickly. On top of her inventory and
library tasks, she must also manage communication with the parents. This
includes sending out general information emails (such as invitations to sign up
for a recital time), reminding parents to respond to a particular email if they
haven’t, and letting every parent know which recital time their children have
been assigned. Once that information has been collected, she must arrange the
order of the performances in each of several recitals so as to provide variety
in the music and allow siblings to perform one after the other; finally, she
must type up the recital programs to print off and hand out at the show. This
VBA project has automated virtually every responsibility listed above.
Key
terms: Library, Inventory, Email, User Forms
- http://files.gove.net/shares/files/16w/dallanmc/Project_Write-Up.pdf
- http://files.gove.net/shares/files/16w/dallanmc/L_Inventory_and_Library.xlsm
- http://files.gove.net/shares/files/16w/dallanmc/L_Email_and_Recitals.xlsm
- http://files.gove.net/shares/files/16w/dallanmc/L_general_email.txt
- http://files.gove.net/shares/files/16w/dallanmc/L_performance_reminder_email.txt
No comments:
Post a Comment