Help build an MS Access application

Closed Posted 7 years ago Paid on delivery
Closed

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!

Database Administration Microsoft Access Software Architecture SQL Visual Basic

Project ID: #10762934

About the project

17 proposals Remote project Active 7 years ago

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

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
(197 Reviews)
7.0
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
(79 Reviews)
6.4
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
(13 Reviews)
5.4
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
(39 Reviews)
4.8
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
(8 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
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
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
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
(1 Review)
0.0