Find Jobs
Hire Freelancers

Convert Excel Form and VBA into Access Database with Form for Ongoing Input

$30-250 USD

已完成
已发布大约 9 年前

$30-250 USD

货到付款
I have an excel file that is used to estimate the cost of a customer entering a healthcare facility. This form is currently filled out on each customer, printed, and stored. I would like to convert the Excel form into an Access Database so we can store the data ongoing. Both the inputs and the calculated profit/loss should be stored for easy reporting and querying. The Excel file uses some basic form elements (checkboxes, combo boxes) and some VBA. I have unlocked any passwords. Please note that you have to double-click the insurance cell to see the list of insurances. Rows 5-9 reference data on the "Insurance Rates-Levels" tab. Acceptance Criteria: - Form needs to calculate profit/loss after data is entered - Form needs easily printed to a single page (see how excel file prints for example) - Form needs to look professional - Form needs to allow the user to type and automatically search the insurance combo box - Tab index should be set from top-to-bottom for easy navigation - Form should auto-expand if there is content in the - Data needs to be structured in a way that I can query the following: - Profit/Loss Grouped By Date and Insurance - Average Total Pharmacy Cost by Date and Insurance - The following need to be stored in the database (different tables are fine where necessary): - Inputs by user (for the checkboxes, storing the number value is sufficient) - Total Costs by Category (calculated values) - $ Margin Per Day - % Margin Per Day - I also need the ability to store multiple forms per patient. - I need a combo box added to the top of the form allowing me to select the type of form it is (new admission, weekly check, end of month, discharge) - I need the ability to easily clear the form - There must be no internet calls embedded in the application - There must be no passwords embedded in the application Nice To Have: - Table that stores all of the calculated inputs. For example, the "Labs" value should be user editable. However, if this table is edited, it should not retroactively edit all of the previously completed form data. Please feel free to correspond with me to get feedback. There will be other projects like this in the future if this project is successful. Good luck!
项目 ID: 7158959

关于此项目

28提案
远程项目
活跃9 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi, I have gone through your project details given in description and also excel file attached and would like to take an opportunity to work on it to provide you efficient solution. I have worked on number of MS Access projects and can deliver you your requirements in the project. In the solution, it will have necessary forms for maintaining insurance rates/levels and also calculated form as shown in "cost tool" tab of excel. Along with that reports will be there for easy reporting purpose. Waiting for your response for more discussion in detail and plan out activity. Thanks.
$161 USD 在7天之内
4.7 (175条评论)
6.3
6.3
28威客以平均价$209 USD来参与此工作竞价
用户头像
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.
$130 USD 在6天之内
4.9 (270条评论)
7.6
7.6
用户头像
Hello, If you are looking for top MS Access coder, former Microsoft Access MVP is at your service. This is, more or less, straight forward project, but it will take some time to make same logic in Access form as in Excel. When I do that part, I will like to ask something about: - Total Costs by Category (calculated values) - $ Margin Per Day - % Margin Per Day But that will come later. Regards, Branislav Mihaljev
$221 USD 在3天之内
5.0 (240条评论)
7.5
7.5
用户头像
Hello sir, I am PREFERRED freelancer in excel and related skills on this forum with 200+ five star reviews. I have understood your requirement and I am ready to start the implementation immediately. Looking forward to discuss with you about the project.
$250 USD 在2天之内
4.9 (335条评论)
7.7
7.7
用户头像
Hi Sir. I have read the project description and I am ready to design the database in Access. On a separate note, if you like, we can have Access on the back end with Excel having the input form OR the Excel itself can have the data saved in it. Please discuss for any of the proposals above. Regards.
$250 USD 在6天之内
5.0 (89条评论)
7.0
7.0
用户头像
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$250 USD 在25天之内
4.9 (128条评论)
6.3
6.3
用户头像
Hey, I reviewed the requirement that you have shared and also saw the spreadsheet that you attached. I am an expert in Excel and Access based systems as you would see in my work history here on freelancer. I did a similar migration from Excel to Access for a multi-store POS system and can assure you that I can do this migration for you with 100% accuracy. Also, is Access form necessary to be done? There are other ways to accomplish your requirement that are even more efficient. Please let me know if you would like me to work on this project for you and we could discuss the details. I can assure you of excellent quality work. Thanks and Regards, Shikha (Automyze Consulting)
$555 USD 在10天之内
4.9 (103条评论)
6.5
6.5
用户头像
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 been freelancing for over 2 years. But I joined this site just few month ago. Within a month I won two of tough contests held on this site. This says a lot about the quality of my services. I have worked on lot of advance excel dash boarding and VBA coding using microsoft access database and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Tha
$210 USD 在3天之内
4.9 (24条评论)
5.9
5.9
用户头像
Propunerea nu a fost încă furnizată
$200 USD 在5天之内
5.0 (85条评论)
5.7
5.7
用户头像
Dear, I am Access/VBA,VB,VB.Net,C# expert since 13 years. I checked your project description.I have already completed little bit similar type of project. I offer you application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, these forms will be for performing data operations and also other functions like selecting the data criteria for generation of the reports If you could reply me on this message I will be able to send you some screens. Looking forward to your valued response. Regards, Chetnaa
$100 USD 在10天之内
4.5 (24条评论)
5.1
5.1
用户头像
Greetings for the Day!!! 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,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$166 USD 在3天之内
5.0 (56条评论)
4.8
4.8
用户头像
Hello there, Yes I can do because I have very much experience with telerik controls,and I do have experience of converting vb6 application to c# as I have worked upon one of the payroll system in vb6 which was subsequently upgraded to c#.net, it too used crystal reports for reports. I have reviewed your job post and would like to propose my interest in working for this task, as I am having expertise with .NET Framework, VB.NET, Visual Basic, VBScript. I am a senior software engineer with 10 years of experience with strong technological background and analytic thinking. Yes I am a .NET Lead Developer and I have 10+ years of development experience in which as a team lead. For development we follow SDLC or agile methodology based on discussion with customers. Give us a chance and will prove to be asset for you and promise a long term healthy service. Though our specialization is ASP.NET, C#.NET, SQL Server and windows applications but we don't restrict ourselves there, provide us what you wish to see, we will work with you and help in you in every aspect. Moving forward, If you grant me the opportunity to work on this job, be assured I can work with minimal or no supervision, meet deadlines, and understand directions in one go. Awaiting an affirmative response from your end! Thanks and Best Regards Janvi
$277 USD 在7天之内
5.0 (3条评论)
4.9
4.9
用户头像
Hi, I have gone through your descriptions, I am 8+ years experienced Visual Basic,HTML,CSS,VB.NET,ASP.NET,MVC,C#,Bootsrap,Telerik control,Crystal report,MS Access,MySQL,SQL,MSSQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your work confidently. I am very much Interested to do your work,Please revert me if you have any concern.
$300 USD 在10天之内
4.9 (17条评论)
4.8
4.8
用户头像
Hi, I have read all your requirements and I can do this job very professionally and you will get Pro Quality Work. Also we will work until your 100% Satisfaction please visit my profile portfolio for my work. PLEASE PM ME FOR MORE COMPLETE INFORMATION AND FOR MY RECENT WORK. Simon.
$160 USD 在7天之内
5.0 (16条评论)
4.4
4.4
用户头像
Hello, I'm developing for/with my customers MS Access applications since mor than 25 years. Selecting me for this project you'll get a very professional application for your business open to add new features in a very simple an professional way. Hopefully with my assistance! If you want some screenshots of my previous project pls. let me know. Best regards, Paul Goldbeck
$200 USD 在3天之内
5.0 (5条评论)
4.3
4.3
用户头像
Hi, I have experience with Excel VBA, Ms Access VBA, Visual Basic, VB.net. I can convert Excel VBA forms and macros to Ms Access with all required changes. Please let me know if you have any clarification. Thanks, Regards, Brindabanb
$166 USD 在3天之内
4.6 (7条评论)
4.2
4.2
用户头像
Hello. More 20 years programming experience. Regards. ---------------------------------------------------------------------------------------------------------------------------------------------------
$155 USD 在3天之内
4.7 (9条评论)
4.4
4.4
用户头像
Hi There, This project sounds perfect for me, I'm currently working on a project similar in terms of data input, forms and storage of data, I've been using Microsoft Access now for roughly 5 years and Microsoft Excel for over 13. I have plenty experience in detailing with lots of data and applying checks where necessary. I love working with data, moving it around, formatting, manipulating, endless possibilities. I can do a great detail job for you. I'm not afraid to ask questions even if it seems like a dumb questions=, it's best to clear things up there and then. As much as you want to convert your system to Access I am more than capable of creating databases in Excel, data storage, user forms. Is there an urgency for the job? Well Thank you for your time in reading my response, if you have any questions please feel free to ask. If you are concerned about the price, I really value what I do, I'm honest and I want to a great job for you. Thank you and Kind Regards Sarah
$555 USD 在14天之内
5.0 (1条评论)
3.2
3.2
用户头像
I HAVE MUCH EXPERIENCE IN EXCEL,ACCES AND VB. I AM HONEST ,FOR THAT REASON MY BID IS LOW AS THERE IS ONE OR TWO ASPECTS I NEED RESEARCH,BUT I AM SURE IF WE WORK TOGETHER WE CAN SORT THAT OUT. I AM WILLING TO START ASAP ON BEING AWARDED THE PROJECT. ENRICO
$49 USD 在3天之内
4.9 (9条评论)
3.3
3.3
用户头像
Hello, I have been working with a MNC bases company since last ~ 4 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert on SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always work keeping these things in mind during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Ashish Seth
$222 USD 在3天之内
4.9 (8条评论)
3.3
3.3
用户头像
Understand you need Access 2010/ 2013 based offline solution. Evidently we need to develop various tables, entry form and reports. Please supply sample data and sample reports desired. This box has limited space to discuss. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Worked on Macro, VB, Pivot, User Form Proficiency in Office tools ,SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Delight.
$150 USD 在5天之内
4.0 (11条评论)
3.6
3.6

关于客户

UNITED STATES的国旗
Peoria, United States
5.0
3
付款方式已验证
会员自7月 22, 2010起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。