I have an online English school helping students worldwide. I am looking for an ACCESS database enabling me to track students who paid their monthly fee and who didn't. Reports, emails and updates will be needed. PayPal will only notify me of students who paid so the reports will have to be generated from payment entries into the database.
Form: A payment entry form is needed to show payments and to later help generate reports of students who did not pay.
Accounts should be found by: student_ID or Student name or first name.
Report 1: A report is needed showing students who did not pay. This must be sorted by country and then alphabetically and listed by Student_ID, Student Name, First Name and email address. This report is needed to stop access to the school until the students pay their fee. An email must be generated to notify the student and sent.
Report 2: A report is needed showing students who have not paid for two consecutive months. This must be sorted by country and then alphabetically and listed by Student_ID, Student Name, First Name, email address. This report is needed to cancel the student's account so that a new student can be added. An email must be generated to notify the student and sent.
Report 3: A monthly income report is needed showing the total by country, which will be sorted alphabetically. A grand total for the month must be calculated at the end. The report has to show the following information: Student_ID, Student Name, First Name, Amount paid.
Report 4: A yearly end report for income must be created from the above by country and sorted alphabetically. The report has to show the following information: Student_ID, Student Name, Student First Name, Total paid for the year, Grand Total paid by country and Grand Total Yearly Income.
Report 5: The report is needed to indicate how many seats remain available for a class. The maximum is five. The
information, sorted by student level, will show the day, time and remaining seats available.
Updates must be possible when accounts are created and cancelled.
Updates must be possible when an entry error is made.
Updates must be possible from accounts that need to be reinstated (cancelled accounts to be reactivated).
Updates must be possible reducing the number of available seats in the class for that day and time
when new students are added to that class. The maximum is five.
Data fields needed are as followed:
Account Information
Student_ID: first_name+city
Student Name
Student First Name
City
Country
Email
Student Level: Beginner, Lower-Intermediate, Intermediate, Upper-Intermediate, Advanced, Fluent
Student Training Program
Class Information
Class_ID: Examples Beg100, LInt102, Int302, UInt701, Adv405, Flu405
(Numbers representing 1, 2,3,4, 5 ,6 ,7th day then 01,02,03,04,05,06,07,08 lesson for that day)
Class Program: Basic or Corporate specialty name
Class Level
Class Size: Maximum is 5.
Class Day
Class Time
Program
Progam Name: Basic or Corporate
Program Specialty: Too many to list but should be entered manually then selected from a drop down menu
Program Fee: $34.95 for Basic / $59.95 for Corporate It should be possible to update this.
Payment
Student_ID
Student_Name
Student_First Name
Class name
Class Month
Class day
Class time
Student Payment
I hope I did not miss anything.
Hello,
I have more than 7+ years experience in this field. you can also check my client feedback here: https://www.freelancer.com/u/mituld.html
By reading your requirement i have some question please message me so we can discuss over the chat and communicate quickly.
Lets discuss the project and start the work.
Best regards
Hi
I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce,vBulletin ,Shopify, Bigcommerce, Magneto ,Zen cart-Drupal , android and IOS , I cancreate and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
Dear Professor,
Its nice to see that someone is serving globally for education purpose.
Well actually all your needs can be managed. Just one basic question ..
1. Do you have website ?
2. If so do you have this recurring payment options in that website already ?
let us discuss more about it further and make your problem solved.
Awaiting reply.
Regards
Sam
Im experience with my duties I do it in experience quality You can contact with me on chat to understand your project and send to you an sample from my experience work and you can pay for me after you like my work
Hi,
I have reviewed your project description and have understood that you want us to develop a solution which would help you to keep track of your student's activities and would status reports of various activities which is fine and would request you to open up the PMB for the same.
We are confident to develop this as per your required specifications.
1 Will there be any other access level besides you ?
2 Is there any solution that you would like us to emulate?
3 What are the exact features to be integrated?
As we are new to this platform we would not demand any upfront payment and would request you to just create a milestone and can release it once satisfied.
Please provide us detailed specifications and open PMB to discuss this further
We would also provide 1 month post completion support on live server to ensure that everything works as desired.
Looking forward to hear from you !!
Kind Regards
Anvita
Hello Sir,
I have Experience of more than 6 years in creating and customizing Web themes, extensions, application and plugins and framework like Codeigniter .
I am well equipped with various technologies:
Magento,Wordpress,codeigniter, WooCommerce, Opencart, PHP, MYSQL, js, JQUERY, PHP Frameworks, PhoneGap, Andriod, IOS and AJAX and designing through Adobe Photoshop, including HTML5, CSS2/3, Bootstrap (responsive sites).
and also:
- API integrations
- Payment Gateways
- PSD to HTML
- Shopping Carts
- Ecommerce
- DataBase Design
Looking forward for further communication about the project.
Hi,
I notice all your needs and completely understood your requirement.
If you want to see samples let me know...
I have done similar kind of work. Just give me a response and I assure you won’t be disappointed.
I also assure you about the quality, accuracy, punctuality and budget which are best in the market.
Just give me a response and I pledge you won’t be disappointed.
Looking forward to hear from you and hoping for a long term work relationship.
Feel free to contact.
Thanks
We are small company with 7 employees working on web and mobile app projects of this size. We have done web based projects using PHP, MYSQL, ASP.NET, SQL Server. And also develop Android apps.
Hello,
My name is Michael Butar butar, I am from Indonesia. I found your job post and I’m very interested in your vacancy. As a skilled Web / Database / Mobile Apps Programmer professional with experience developing web, I think you’ll find I have the skills you’re looking for.
I have 11 years experience in IT Software Development and have built database desktop software, website and web application . I know PHP, C#, VB.NET, Classic ASP, HTML5, Javascript, JQuery, Node.JS, AngularJS Programming Language and I know MySQL/MariaDB and Microsoft SQL Server. I know MVC framework for ASP.NET MVC, Code igniter and Kohana I develop mobile apps using Ionic Framework and Apache Cordova. Please take a look at my portfolio in my profile and my site : web-software-developer[dot]com to get an idea of the kind of software I have developed. You could take a look at my sample code : github[dot]com/indigomike7. I am a hardworker, Fast Learner and could adapt to new technologies very well.
I have stable internet at home and I am looking for a long time working for you and I think I can handle your projects alone or in your team. I could provide a team too If you wish a team for your project development,please see our team’s website dikorting[dot]com.
Thank you for your time, I am looking forward to hear again from you
Regards
Michael B
i can provide you the most satisfied product. I have good knowledge of php and java. And as far as my fee is concerned i work with only 200rs/hr. Please let me know if you are interested.
Dear Professor,
Harshita, with 4yr of experience in web development, proposes to develop a web application for Monthly Tuition Payment Control. The purpose of which is to track and manage the fees of students. The application will record all fee details of students along with relevant data(s) and generates reports for:
• Students who have not paid fees
• Students who have not paid for two consecutive months. Sorted by country and then alphabetically and listed by Student ID, Student Name, First Name, email address with email and account cancellation functions.
• Monthly income report with the grand total for each country, sorted alphabetically.
• Yearly income report, sorted alphabetically with all relevant data.
• Indicate available seats for a class, with the maximum being five.
Project WBS:
¬ Discussions on the requirements – 1hr
o To openly discuss, understand and address the open question(s).
¬ Backend Architecture - 10 hrs.
o Includes all development for the application backend running on PHP.
¬ Frontend Development - 10hrs
o Include all development for the user view.
¬ Integration and Deployment – 5 hrs.
o Completing the application from an end-to-end perspective, doing the final touch and handover.
*Testing will be done in all of the above-mentioned stages.
Thank you for taking the time to go through my proposal.
My profile doesn't hold any rating as I am new to freelancer. Quality is guaranteed.
Best regards,
Harshita