Closed

Help build an MS Access application

I am am writing a Student Management System in MS Access 2013, for an aviation school which I am co-owner of. We have 25 staff and 100-200 students to manage. I have basic-to-intermediate MS Access skills. I have created a functional system that works for our needs, and now I need to find a trusted Access programmer who can (a) tidy up what I have done eg. Screens, object names, simple VB code and (b) expand the functionality of the existing system, as I do not have the time (plus some requirements are beginning to stretch my capabilities in Access/VBA which I do not have the time to improve on).

The databases are separated from the Form entry Access databases to allow different staff members to have different views of the same centralised data. The central databases reside on our central corporate server, and the Forms databases reside on individual PC's, including PC's that use VPN to access the central databases. I have been unsuccessful in my attempts to compile the Form databases into an executable file.

There is a great deal of demand to add to the system functionality. It currently keeps student administration information, does some basic reports (mostly as Excel spreadsheets), and prepares standard letters using Mail Merge function with MS Word.

Som one the next stages are to:

- strengthen the production of standard letters function, including an audit trail for letters produced for each student

- tidy up the look and feel of the screen entry system

- tidy up the VBA code and object naming conventions

- create a (reasonably complex) formal quote (report) using the student lessons database. This will require some advanced date function coding in VBA.

- creating student progress reporting

- add in ability for student photos to be stored, and ID cards printed (we have an ID card printer)

- add in staff sign-on with passwords, and group authorities for access to functions, also for audit-trail purposes

- dashboard reporting of student progress, with alerts and auto-emails. Each flight instructor has an assigned batch of students, so dashboards would be based on selected students, assigned students, or all students.

- possible conversion to SQL and web-based entry to allow effective off-site usage and security

- Automatic database compacting and backups

- Series of reports (some simple, some complex) for managing students, and reporting to government prescribed formats.

- Generation of CSV file for upload to government reporting systems

- Many other suggestions and enhancements that will inevitably arise!

Skills: Database Administration, Microsoft Access, Software Architecture, SQL, Visual Basic

See more: writing formal letters, writing effective emails, writing conventions, sql, microsoft access, visual basic for apps, writing a batch file, word advanced skills, who needs a vb programmer, what is formal writing, what is automatic writing, what does an it programmer do, what are writing conventions, what are conventions in writing, what are advanced excel skills, web site which help to create software, web programmer student, web application system architecture, web application quote, vpn quote

About the Employer:
( 0 reviews ) BIDAR, India

Project ID: #10762934

18 freelancers are bidding on average $15/hour for this job

Prashantskin

[login to view URL] I have gone through your project requirements regarding the Student Management system for an aviation school I will do all the things mentioned in your request. I will do the job within 10 days only More

$11 AUD / hour
(550 Reviews)
7.2
eperfections

I am very interested in your project. I have 10+ years experience. I am the BEST programmer on this platform. Ready to start immediately. Plz share complete details.

$20 AUD / hour
(196 Reviews)
7.0
bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have b More

$20 AUD / hour
(12 Reviews)
5.4
augurstech

Dear Employer, Greetings from Augurs Tech, We have more than 5+ Years of exp working on applications with C#, Asp.net, MVC and Database like MsSQL, MsAcess, FoxPro and MySQL. We have worked on complex applic More

$12 AUD / hour
(26 Reviews)
5.5
aleator

I am not a mediator. I will help quickly and efficiently. Ready to do this job. I have several dozens of completed projects in Access. Maybe your project will be the next? From the Access, of course, familiar.

$13 AUD / hour
(46 Reviews)
4.7
narendragautam

Hi, I am Sr. Developer in PHP,C# ASP.NET,MySql, Sql server, HTML5,Javascript,bootstrap, CSS3,Phonegap,Java Android developer. recently worked on [login to view URL] [login to view URL] [login to view URL] More

$20 AUD / hour
(6 Reviews)
4.5
softtechsurat

Hello sir/madam, we have read and understand your requirement and very much confident that we can complete this project within low budget and less time . Give us chance to serve you better Looking forward to be More

$20 AUD / hour
(18 Reviews)
4.2
$20 AUD / hour
(5 Reviews)
4.2
katilinas

I CAN do this job, and do it well! My repeat hire rate is 47 %. If you look at my portfolio you will see that my skills are a good fit. Do You need a freelancer who can fulfill all of your requirements? I'm sure it wil More

$13 AUD / hour
(18 Reviews)
4.3
$20 AUD / hour
(3 Reviews)
3.6
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ More

$5 AUD / hour
(10 Reviews)
3.2
adcdao

Hi, I'm an Access programmer for over 20 years. I also have a strong knowledge of VBA that I use with AutoCAD, Access, Excel and Word. Here's a link to a description of a recent project I did with Access 2013: ht More

$15 AUD / hour
(2 Reviews)
3.2
miloskrizan

My mainstream is VBA and VBscript coding and API automation with user-friendly graphic interface MS Office applications (Excel, Word, Access, Sharepoint, IE,...), creating of customized Windows API applications and com More

$20 AUD / hour
(1 Review)
2.7
TimHudspith

I have just completed an Access-based class management system for a private mathematics school in Malaysia (a Freelancer client) that has significant overlap with the requirements you outline. Please see my profile for More

$20 AUD / hour
(1 Review)
2.2
intellisoft5

Hello Sir, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the resu More

$13 AUD / hour
(1 Review)
0.9
avanthaj

Thank-you for providing this opportunity to submit a bid for this MS Access Project. Please provide further details by email, regarding the requirements for this Project. Background: An experienced Solutions Ar More

$20 AUD / hour
(0 Reviews)
0.0
WaqasLatif786

I have Experience in Microsoft Access.I have done a similar project [login to view URL] contact me for further Discussion.

$5 AUD / hour
(0 Reviews)
0.0
AmirHirani

HI currently i m working as senior dot net i vb.net developer and having 4 years of experience. So i can develop according to ur reqiurement . U can also call me on 9427700652

$13 AUD / hour
(0 Reviews)
0.0
muraridevkotwal

Hi, I can easily develop the required school management system for you in less than a month. KEY FEATURES: --------------------- - Student Login[with Admission number] - Teacher Login[with employee Id] - School More

$13 AUD / hour
(0 Reviews)
0.0
$6 AUD / hour
(3 Reviews)
0.0