Prestige Education is a tutoring centre. We want to improve our current MS Access application. Therefore, We want to create brand new application which is able to process the [url removed, login to view] application must be designed based on multiple branches.
1. Create, update, edit and Delete Student details which includes
a. Student Details
b. Family Details
c. Course Details
d. Tutor Details
e. Booking Details
a. Fee payable
b. Tutor wages payable
c. Summary report for each student
3. Reporting & Interfaces
a. Accessing Database with username, password based on priviliges
b. Creating, Updating, Editing Booking on a single interface
c. Summary Payment Report
d. Tutor Payable Report
e. Overdue Payment Report
f. Flexible reporting in single interface (School, gender, year level, subject)
h. Configuration Interface
i. Budget Reporting
j. Sending SMS to single student or Group based on certain criteria
k. Attendance Interface (Group, Private, Cancelled, Attendance Sheet)
a. Sending SMS to remind the booking
b. Saving SMSs (if possible with our SMS provider we want to save reply messages as well)
c. Email weekly timetable to tutors
d. Email to student/parent necessary documents
e. Emptying database with leaving required configuration unchanged
a. Splitting Database& Interface
[url removed, login to view] several Switchboard for different user profile.
I couldn't add the database because it is 17 MB. I can send it later on.
21 freelancers are bidding on average $926 for this job
I have over 10 years experience with Access and other database systems. I'm just finishing an Inventory and Bill of Materials system and I can provide a quality solution for you.
Will do this application in .net + SQL Server. I have recently devloped a simillar application for Sports Coaching Center. Your requirement is almost same. So, I can provide you a quick solution.