I am a volunteer at a charitable music school, who offer music lessons, hire instruments and sell sundry items on a Saturday morning during school term.
I have attached a spreadsheet that has the forms the students must fill out to enroll - not all students will hire an instrument
There is a database of Students (with their parents), Tutors and hire instruments, along with a list of rooms (I'd like to add the capacity at some stage in the future), but I don't have this at them moment (I am currently at my "real" work place)
Enrollment form filled out
If not previously enrolled then details taken
If previously enrolled - details checked
Availability of classes checked (there is some flexibility in this - class times and location may change at the beginning of the year
the student may request a time, but we have ultimate authority of this.
IF hiring an instrument
Form filled out and signed
Availability checked while filling out.
Email sent to:
To check class allocation
Checks payment received
We will need to assign a tutor to classes
During the year we will need to:
Sell sundry items along with books
Change class locations
At the end of the year we will need to
Return the instruments
The people in the office are all volunteers - so need it to be easy to use and cost effective.
I am open to suggestions