Find Jobs
Hire Freelancers

Help build an MS Access application

$5-20 AUD / hour

Completed
Posted almost 8 years ago

$5-20 AUD / hour

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!
Project ID: 10762215

About the project

16 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 (b) expand the functionality of the existing system. I am able to do all the thing you have been described in your project description. I have 6 year's experience designing and developing Microsoft Access Application with advance knowledge of Database Designing, Forms and Reports designing, SQL, VBA and particular skill in integrated Microsoft Office solutions based upon automation of Excel, Word and Outlook. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio. As your requirements I can do the following…. I can make it so it can be use in Multi-user environment (With different access level for each user.) with log-in dialog. I can make printable reports with ability to export data to Word, Excel, PDF etc. The user interface structure of the application will be such that there will be a single Home form and all the other forms can be loaded on this main Home form through button clicks to access their functionality. Thank you for taking the time to read my proposal. With Best Regard
$8 AUD in 30 days
4.9 (70 reviews)
5.8
5.8
16 freelancers are bidding on average $18 AUD/hour for this job
User Avatar
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 continue to work on the rest of the requirement. Regards
$15 AUD in 10 days
5.0 (18 reviews)
6.6
6.6
User Avatar
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 discuss in detail. I will provide you best services in development. Please have a look at my Profile, Ratings and feedback. Please let me know, if you want to see the samples of my work. I am working in Microsoft technologies and you can find the details below. My Skills includes: 1) .Net (Web/Windows) asp.net 2) MVC 3) Entity Framework 4) WPF/WinForms 5) MSSQL Server 6) SQL Server Reporting Services 7) Javascript/JQuery 8) WebServices/WCF Services 9) MySQL 10) Hosting Sites 11) Mailchimp 12) AngularJS 13) Recently Worked on Vending Machine solution with Monetary apparatus and Shipping Goods motor also worked on Kisok applicaiton. many more...... I have no fancy talks, no false promises and nothing to hide but honesty and a great will to expand our work experience. I am willing to expand my work experience to different clients and in this order I apply for this job in the hope to hear some positive response from you. I hope you will take us positively and will give us a chance to work with you. Many Thanks & Regards Sikander
$17 AUD in 40 days
4.9 (26 reviews)
6.4
6.4
User Avatar
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 FOR BETTER UNDERSTANDING============= Few Queries:== 1. Is your application a web application or desktop? -- Please confirm 2. Do you want an executable file which should be created from MS access to run the system ? 3. "The databases are separated from the Form entry Access databases to allow different staff members to have different views of the same centralised data. " -- What do you want to mean by "different Staff"-- Different type of members based on their roles or Different type of member but in the same role? please confirm Please revert back for further discussion. -- Regards, Sumantra
$14 AUD in 20 days
5.0 (3 reviews)
6.0
6.0
User Avatar
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 to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$22 AUD in 10 days
4.7 (40 reviews)
6.0
6.0
User Avatar
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 having a FE for users and and a BE database however for a more robust solution you may consider having the BE in MS SQL server and keep the FE in Access. Please have a look at my portfolio and contact me if you need further details. Best Regards Ahmed
$27 AUD in 30 days
4.8 (13 reviews)
4.4
4.4
User Avatar
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 this and have it on your side, which would help you to have achieve your business goal in a better way. I feel .Net Windows application is a suitable choice for your business requirement compared to the MS Access. * You dont need to buy any extra software to us it. We promise you that, if you can share your completed business requirements we can work with you and deliver the application as per your requirements and your time lines. As we are a 9+Years organization, we can be there when you have Please initiate a discussion with us, to take it to next level, Your Sincerely, BizDevCt
$16 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 .Net, Visual Basics, c++,c#,python , • Expertise : • PHP • Python • Visual Basic • .NET • Software Architecture • Software Testing • Word • PSD to HTML • MySQL • C++ Programming • UNIX • Software Development • ASP.NET • VB.NET • Programming I have completed more than 100+ projects Software development. Highly accomplished and experienced software Developer with comprehensive mastery of all software. Expert at both local and global vendor networks. Able to work independently with little to no supervision as well as functioning as an excellent team player. You can test the quality of my work if needed. Best Regards, Fayaz Ahmad
$8 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 invest the time in getting the web application up and running before adding more complexity. I don't think it would take a great deal of time to migrate your existing Access database to a fully web based system. I actually do contract work in the aviation industry working on EFB's and training forms so I have a good business knowledge of the industry. I'd be very interested in a Skype call with you to get a better understanding of how your system currently works and how you and your staff are using it. I look forward to hearing more. Regards, Chris
$22 AUD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Belair, Australia
5.0
18
Payment method verified
Member since Mar 2, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.