Find Jobs
Hire Freelancers

Microsoft Access User Interface

$250-750 USD

Completed
Posted almost 8 years ago

$250-750 USD

Paid on delivery
Objective: to create a user interface on an existing MS Access database that will allow lookup, delete, add and delete functionalities, as well as report generation and email sending. Problem: Our client is manually looking up and updating data on the Access database. As the DB has grown the amount of time required to maintain the DB has grown exponentially. Details: 1. The user interface will need lookup tools, i.e. entering a client number, or surname, or address to bring up full record details - where several records are found, a list needs to appear allowing user to select the record. 2. Once full details appear, this can then be updated or deleted. 3. Functionality to add new records. 4. Functionality to send emails to given records, based on information in given fields. 5. Some fields may need to be calculated, i.e. where there is a commission rate of 10%, then box x shows this in £. 6. Automated tools: - Automatically include a sequential client number for new records. - Auto update of fields - i.e. remove a flag in field 30, from 30 days of the date in field 28. 7. Access to DB will be restricted - access should only be via UI. 8. Report generation on given field(s), i.e. maintenance due in the next 30 days (using field x). Other information: - There are templates available in the latest versions of Access - we are happy to use and update a given template for this project. - Project needs to be functional by 29/04 - exactly what is delivered on this date can be arranged up-front. - A copy of the database is attached - it has been created using Office 2016. - Please state the programming language you intend on using. - We will provide grouping information for the UI once the project has been awarded. - Evidence of work with UIs would be beneficial. - DB is in .mdb format, this can be updated. - This is our first UI project, therefore, we would appreciate feedback and input on the above requirements, as we may have missed simple requirements that should have been included! Thank you in advance, and please let me know if you require further information. Mike
Project ID: 10209471

About the project

34 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
Hello, My name is Florin, I am from Romania and I am a database applications developer. After going through the project description, I can provide a simple and user friendly solution for your needs. You will not require MS Office installed, the application will not require installation, the interface can be customized in any way. The application will consist of two files: - a database file, password protected, accdb preferred because of the number of records it can store vs mdb; - an interface file that will connect to the database and will handle all the queries. The app will manage customers (i saw the data in the attached zip file) and will generate the required reports based on the existing records. About the email sending feature, i will add an Email Settings screen where some data will need to be filled for the feature to work (in the same way as a standard email client, like Outlook or Thunderbird). Let me know what you think of my idea, i would be more than happy to build a demo based on the database you've provided, and we could talk further after you see the demo. Thank you for your time! Kind regards, Serban Florin
$250 USD in 5 days
5.0 (19 reviews)
5.2
5.2
34 freelancers are bidding on average $488 USD for this job
User Avatar
Hello I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other database. I am also among the top three MS Access developers on this site. You can verify by going to https://www.freelancer.com/freelancers/skills/Microsoft_Access/ I think the best version of MS Access till date is 2010. However I can work with the latest versions as well. I have seen all your specs and I think this should be easy to accomplish in 15 days max. I do not recommend that we use any ready templates - it would be better to create a brand new custom db. I look forward to hearing from you. regards Rajiv
$300 USD in 10 days
4.9 (159 reviews)
6.9
6.9
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. 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, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
$500 USD in 10 days
4.9 (122 reviews)
6.9
6.9
User Avatar
Hi there! I have read what you exactly need, however I would like to ask you a few questions. I would call myself a master of what I do, I do work smart and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detailed discussion. If I can deliver I will deliver in best possible way. Thanks
$555 USD in 10 days
4.7 (33 reviews)
6.7
6.7
User Avatar
Hi Mike, You are absolutely right on your update #1. I think we should have a discussion on this. I have read and understood your concept regarding this system. I have planned to design using .NET c#. I am comfortable in other language also so we can have a discussion in this. I have to discuss something on point 4. Regarding the reporting and deliverable, I will be communicating with you on daily basis either via freelancer msg or mail. as soon as a small portion will be completed I will be sending to you for the approval. This will help us to make the process faster, smooth and efficient. I will request you to discuss with me about this project more, let me share my plan and lets do this together, Please contact me to start this project. Regards Priyam
$515 USD in 13 days
4.9 (22 reviews)
6.0
6.0
User Avatar
Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget accordingly. Thanks regards Jawad
$555 USD in 10 days
5.0 (87 reviews)
5.7
5.7
User Avatar
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. In my portfolio look at the screen of "Create sales and purchases database application". You will find some similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$555 USD in 10 days
4.6 (48 reviews)
6.2
6.2
User Avatar
Hi, I am good at MS access and programming. I would like to discuss the user interface part. Looking forward to work on this project.
$550 USD in 10 days
5.0 (54 reviews)
5.7
5.7
User Avatar
Dear Client, I am interested in your MS-Access User Interface (UI) development project. Please visit my Profile>Portfolio for review of UI design screen shots. I design custom Ribbon Menu for navigation on the application which looks professional. Furthermore, new color and theme is applied on the form design for easy user interaction. I would like to purpose build on MS-Access 2013 with ACCDB file format with VBA coding as required. There will be two file front-end (User interface) and back-end file (Data file) and back-end file with be locked for direct access. Furthermore, also the front-end will be locked for going to design view to prevent user from accessing table directly. I also like to purpose to build front-end on MS-Access as it is faster for future update. For the email sending we need to have MS-Outlook installed and configured then this application will it to send emails. Feel free to drop me a message if you have any queries. Thank you. Regards, Havit Nepal
$560 USD in 10 days
5.0 (11 reviews)
5.5
5.5
User Avatar
Hello I can make user interface using delphi. This will desctop application to connect, manage, input data etc. into/using database. If payment is acceptable for you , please write me a message, I will make presentation, and we start discuss the project.
$350 USD in 10 days
5.0 (11 reviews)
4.8
4.8
User Avatar
Hi sir, I am very interested in your project and offer my services. The project you posted is my type and I do this job for you if you let me. If we create UI in Access then only programming language we can use is VBA but, we can use ActiveX controls if something is not possible within the scope. Please see my portfolio for reference. I can provide sample database for checking if required. I'll gladly provide project coding its not a problem. Feel free to contact me for further discussions. Looking forward, Nblsoft
$333 USD in 7 days
5.0 (6 reviews)
4.3
4.3
User Avatar
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 administration and maintenance with Linux/Unix and Windows Networking.
$250 USD in 4 days
4.9 (31 reviews)
4.5
4.5
User Avatar
Greetings! I have 15+ years experience with MS Access. Some databases I developed are in use even now, despite ones were designed many years ago using MS Access 2000. My approach is: - data structure must be correct, expandable (any further improvements/functionality should affect on necessity to rebuild existing parts of the database) and reliable - UI should be native, user-friedly, time saving So, speaking about your project: 1) Structure of the tables must be tuned a little bit to become normalised (in particular Family name should be kept in a single place, all other table should refer to) - I could do it easily 2) To design a really native and useful UI we'll need some chat regarding purpose and way of using the database. I.e. since I know daily routines of the user(s), then I'm able to offer the best way of doing it using the database. 3) Assuming that you'll need several more days to choose the executor, we still fit into the deadline April 29, as far as 2 weeks I mentioned to perform the job include multi step providing of intermediate results, work on bugs detected, tuning accordingly to your impressions etc. So, proposed milestone#1 is regarding our common agreement that (1) and (2) is well specified and ready to be implemented, and milestone#2 - implementation itself. Also, you'd get: - free support for bugs found (if any) - my readiness for any future improvements you'll wish Please feel free to contact me. Regards, Sergey
$350 USD in 14 days
5.0 (11 reviews)
4.6
4.6
User Avatar
I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,Yellowpages,Yelp,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction, and the price is negotiable if required. please award me this project and contact me for further details
$444 USD in 10 days
5.0 (29 reviews)
4.5
4.5
User Avatar
Hi I understand that you are looking for someone to work on your MS Access Database. I have worked on MS Access & Excel projects for other clients as well and delivered quality output on time. I will maintain good quality and ensure to provide you efficient output. I have knowledge of MS Access queries, forms, reports, Excel formulas and macros as well. Please drop me a message and then we can discuss the details regarding your project. I am flexible with working hours and we can plan how to take this ahead after understanding your complete requirements in detail. Thanks Abhishek
$550 USD in 10 days
4.6 (7 reviews)
3.4
3.4
User Avatar
hi i can develop for you a small windows desktop application (vb. net) to make your database more useful. with reporting issues and security profiles. i can start working now.
$277 USD in 7 days
5.0 (1 review)
2.5
2.5
User Avatar
I am experienced at developing desktop applications and can conduct the activity within the time frame. I will use VB.net as native environment for MS access to develop the user interface, reporting and updating functionalities.
$750 USD in 10 days
5.0 (1 review)
1.8
1.8
User Avatar
Dear Sir/Madam, I have 17 years experience with Microsoft Access. I have developed many projects using Access as front and back end. I have developed solutions for Customer Relationship Management, Project Tracking, Academics Databases, Human resources, Patient Management, Lease Management, Pharmacy Retail Software. I can confidently handle all aspects of software project, from design to development, testing, documentation and production support. Look forward to your prompt & affirmative response. Best regards, Anita
$500 USD in 12 days
5.0 (1 review)
1.7
1.7
User Avatar
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requirements.i have right skills to work on this assignment my award = superb result = happy client. In a good partnership, good results happen. Good cooking makes good eating!BWe consider our client as our partner. can u provide your email or sky-pe etc for further discussion about the project. I am ready to discuss with you with best Regards
$555 USD in 10 days
0.0 (2 reviews)
0.0
0.0
User Avatar
am an exxpert in C# desktop applications, design and develop , I can easily did that to u and finish it in good architicture
$555 USD in 10 days
0.0 (1 review)
0.0
0.0
User Avatar
Dear Sir I have 11 years experience in IT and I think I would be an ideal candidate for this project. The language that I will use for this task is VB and access. I have worked on sql and progress databases before.
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GUERNSEY
Swindon, Guernsey
4.9
39
Payment method verified
Member since Aug 6, 2009

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.