Terminé

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!

Compétences : Administration de Bases de données, Microsoft Access, Architecture Logicielle, SQL, Visual Basic

en voir plus : writing formal letters, writing effective emails, writing conventions, 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, vb data entry form, vb dashboard, vb code for data entry form

Concernant l'employeur :
( 18 commentaires ) Belair, Australia

Nº du projet : #10762215

Décerné à:

dipakmoliya

Dear Client, My name is Dipak Moliya. I’ve read your project description and can see that you need a trusted Access programmer who can (a) tidy up what you have done eg. Screens, object names, simple VB code and ( Plus

$8 AUD / heure
(70 Commentaires)
5.8

16 freelance font une offre moyenne de $18/heure pour ce travail

hieutc

Hi, I have experience working with MS Access and VBA. I have read through your requirement for improvement and I am confident that I could do it. I could do one for testing purpose first and after that we will c Plus

$15 AUD / heure
(18 Commentaires)
6.6
sikandermandal

Dear Sir, This is Sikander. I have read you job specification and come across your requirements about this project. I have 14+ years of experience in software development and I am ready to start this job. Please dis Plus

$17 AUD / heure
(26 Commentaires)
6.4
sphinxsolution

Hi, This is Gaurav, Writing on behalf of Team Sphinx. We are one of the rapidly growing web and App Development Company based out of USA,Austrailia & Pune,India. We have developed more than 300+ solutions so Plus

$20 AUD / heure
(13 Commentaires)
6.5
digitalaptech

Hi there, Thanks for posting your requirement.I would like to mention we have previous experience to create such web and desktop applications. =============PLEASE SHARE YOUR INPUTS FOR THE FOLLOWING CLARIFICATIONS Plus

$14 AUD / heure
(3 Commentaires)
6.0
zu02

As I see here need ms Access fe and be( be in server, fe in eavh pc with login and user rights etc..)..I'll make it fully functional. Also here is a great that you are familiar with Ms Access... Hi there, I’d like Plus

$22 AUD / heure
(40 Commentaires)
6.0
qitsol

We have completed over 500 jobs on freelancer + upwork. We did similar projects. Please check our 241 reviews on freelancer.com [login to view URL] See our 100+ reviews on upwork / [login to view URL] http:/ Plus

$23 AUD / heure
(5 Commentaires)
5.9
surajitmitra

Hello, I hope you are well, I am from an ISO certified, closely-knit family of 150 employees, working hard to provide customers with the best user experience & performance, beating any written quote at the same tim Plus

$17 AUD / heure
(1 Évaluation)
4.9
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] Plus

$20 AUD / heure
(7 Commentaires)
5.1
bspanovic

Hello You can look and test one of mine application's on this link: [login to view URL] Log on as jrellsve , paswword is jrellsve I'm Microsoft Certified Database Developer. My Microsoft transcript you Plus

$23 AUD / heure
(12 Commentaires)
5.4
sofex

Hi, I will be happy to provide you with the required solution. I am experienced in VBA and I will be able to integrate Access solution with Excel, word and Outlook. You still can continue in the current approach by Plus

$27 AUD / heure
(13 Commentaires)
4.4
$20 AUD / heure
(3 Commentaires)
2.1
bizdevct

Dear Sir, Apologies for my intrusion here!.. But i am really puzzled for choosing MS Access as your main tool to develop this application. In my honest and humble perspective, you need a better platform to develop th Plus

$16 AUD / heure
(0 Commentaires)
0.0
qualityworker22

Hello, My name is Fayaz Ahmad, I am expert in Software Development .I have 7 years+ experience in software development and architecture and I am certified Software Developer . I have completed 100+ projects using Plus

$8 AUD / heure
(0 Commentaires)
0.0
IntrepidDev

Hi, your project sounds very interesting. I think I'd be an ideal candidate to work with you. I'd recommend moving to a web based system before starting your next stages. In my professional opinion it would be wise to Plus

$22 AUD / heure
(0 Commentaires)
0.0
wfy1961924

Hi, I'm expert in MS Access and VBA. And I have a lot of experience to develop software using MS Access and VBA. Hope I can have the chance. Thanks.

$8 AUD / heure
(0 Commentaires)
0.0