Success

Notes

Error

 
 
 
 
Budget

Small project <800

Posted on

2014-01-04 15:09:14.0

Buyer:

Ar***

This project has expired

Why don't you register anyway? We are sure that you will find many similar projects out of the thousands waiting for you!

Post similar project now

Description

~~Background Enquires and consultations are received by email, telephone, skype, phone etc to continue studying in the UK. Pre-screening emails are sent, upon passing the pre-screening documents are requested, then checked.  An application is then sent, a decision is received. Once the student has enrolled and confirmed enrolment an invoice is sent. Currently all the information is recorded by hand and stored in emails, important leads are lost and as the number of students are increasing it is becoming increasingly difficult to keep track of all the student applications etc. Database Requirements: Main entities: University/College/Language schools (University information, including point of contact, partner university (yes/no), scholarship information etc Courses – course information, title, fee, start dates etc Agent – agent information, date agreed, etc Student – Student information, enquiry/consultations etc The database will need to be integrated into outlook to automatically mail merge and automatically read emails which are sent via contact form then send a pre-screening email, if not then manual import into the database. The database will be stored on a server and accessed remotely, ideally in MS Access and front end in VB. The database will need to capture all the related data from the main entities and produce daily, weekly, monthly, quarterly and yearly reports on user provided parameters. The database will also need to be fully searchable with the ability to store documents or store document locations, for each individual student, record or store emails and which action has been/needs to be taken etc.   Source code for the database will be needed.