Lukket

Monthly Tuition Payment Control

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: $[url removed, login to view] for Basic / $[url removed, login to view] 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.

Færdigheder: Grafisk Design, HTML, PHP, Web Design

Se mere: email format country inn, tuition monthly control, monthly pmi calculated apr, payment facebook monthly, largest email providers country, email grab country, email contact country, grab email addresses country

Om arbejdsgiveren:
( 0 bedømmelser ) India

Projekt-ID: #14682478

27 freelancere byder i gennemsnit ₹611/time for dette job

gopalvora

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 Joo Mere

₹412 INR / time
(448 bedømmelser)
8.2
mituld

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 s Mere

₹592 INR / time
(372 bedømmelser)
8.1
lavizsolutions

Hi, Kindly share me more details so that i can give you estimated time and cost. Please check my below work.. 1. Case Management system. http://lavizsolutions.com/private/CMS/index.php you can create activ Mere

₹1111 INR / time
(19 bedømmelser)
6.8
kailasamir

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 Mere

₹722 INR / time
(41 bedømmelser)
6.0
TanzeelAhmed

I REVIEWED YOUR PROJECT DETAILS & WOULD LIKE TO OFFER YOU MY SERVICE OF DOING FIRST TASK FOR FREE, JUST TO PROVE MY SELF TO U AND ALSO GET EXCELLENT REVIEWS FROM U, AFTER YOU AWARD ME JOB AND CREATE INITIAL MILESTONE F Mere

₹750 INR / time
(21 bedømmelser)
5.5
brijeshcoder

Hello Sir, I have gone thru your project description and I am very much interested in doing your project. I am sure I will exceed your expectation. A brief about myself. I have very good knowledge of laravel, A Mere

₹638 INR / time
(13 bedømmelser)
4.4
bhagwansahane89

expert. come on chat now so we can discuss in detail.

₹400 INR / time
(28 bedømmelser)
4.8
SoftoMozo

Run by IITians and based in Delhi, India, we cover complete horizon of Software development and Online solutions and services. We have been delivering with utmost efficiency at affordable pricing. Apps- Productivity: Mere

₹638 INR / time
(6 bedømmelser)
3.7
gagandeeps416

Hi, I am Gagandip Singh having experience of more than 5yrs in php development. My key skills are HTML,CSS,JAVACSCRIPT,JSON,AJAX,PHP/MYSQL,CMS(worpress,joomla),MVC's(CI,Cakephp,yii,laravel),Mobile Apps with Phonegap Mere

₹555 INR / time
(8 bedømmelser)
3.8
a7mad11711

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

₹638 INR / time
(23 bedømmelser)
3.9
aadilahlawat42

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,W Mere

₹722 INR / time
(11 bedømmelser)
3.8
Cybermatrixsol

Hi, Greetings of the day!! We provide affordable and trustworthy Web Design & Development and Mobile App Development. We are also providing Dedicated Resource for all our services. We have 6+ years of experience in Mere

₹555 INR / time
(3 bedømmelser)
2.8
webdev1802

Hello, I have 6+ years of experience. I have reviewed your project requirement and ready to start the discussion in order to clarify the queries. I have done similar kind of work in past. I have all the skill set req Mere

₹555 INR / time
(2 bedømmelser)
2.3
dgtalsoft01

Hello, Your requirements are all clear to understand. I have enough experience in this part. But I have some question about your project. So please reply as soon as possible. I promise you high quality result. Mere

₹638 INR / time
(2 bedømmelser)
1.3
sanwarsumit

Hi, Let's discuss completely about all your requirements before making a final deal to start. I want to start this task as soon as possible beyond this I have more than four years of experience, in developing field Mere

₹444 INR / time
(1 bedømmelse)
0.8
tanmaybhawsar

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.

₹638 INR / time
(0 bedømmelser)
0.0
harshitaarora08

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 app Mere

₹600 INR / time
(0 bedømmelser)
0.0
VBroTechnology

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 Mere

₹400 INR / time
(0 bedømmelser)
0.0
₹400 INR / time
(0 bedømmelser)
0.0
dayakmlt

Do you want just in MS Acess or can be in ms excel also. let me know when you want. Phone call is required to understand clearly

₹555 INR / time
(0 bedømmelser)
0.0