Find Jobs
Hire Freelancers

Convert basic Excel spreadsheet into a simple database

$30-250 USD

已关闭
已发布超过 7 年前

$30-250 USD

货到付款
I need to convert the attached spreadsheet into a simple MS Access 10 database. No executable file, just plain Access. Relationship should be 1toMany. My idea is a main panel where you can chose at least two options: Data entry, Reports. The Form for data entry will offer the ability to add 1 or more "subjects" for each "victim". The reports should give the ability to query on any field, adding 1 or more filter for a specific timeframe. We should have total and subtotals count as well as list of all cases split by installations with totals. Reports should be exported in excel. A nice to have feature is the ability to import data from external plain spreadsheet.
项目 ID: 11758434

关于此项目

38提案
远程项目
活跃7 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
38威客以平均价$179 USD来参与此工作竞价
用户头像
Hi, This is absolutely doable and it does make sense to move data from Excel to Access. This looks like a straightforward project and I think I will have just a few questions. I can start right now and I think I can complete it within few days. One note for Access report: if you need it have dynamic columns there, it must be programmed that way. If this is the case, this part will take some time to do it. Best regards, Branislav MIhaljev
$222 USD 在3天之内
5.0 (253条评论)
7.6
7.6
用户头像
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.
$200 USD 在8天之内
4.9 (123条评论)
6.9
6.9
用户头像
Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$70 USD 在3天之内
4.9 (159条评论)
6.6
6.6
用户头像
Hi, Sure it's possible just you'd like to have via Ms Access with Ms Excel automation. For me Access/Excel automation coding is one of my favorite coding jobs. Why I bid $500 and for 10 day? I'm just know what a tricky coding requires here. I'll code that as you expect for great result. Thanks for your time and regards, Zura
$555 USD 在10天之内
4.6 (48条评论)
6.1
6.1
用户头像
Hi, I'm a professional Microsoft Access and VBA developer with strong background in developing and modeling information systems using Ms Access. I have read your project description and would like to help you fulfilling your needs. I have done similar projects before, check my profile for details. I'm looking forward to hearing from you. Regards,
$80 USD 在3天之内
4.9 (72条评论)
5.9
5.9
用户头像
Dear Client, I am interested in your MS-Excel to MS-Access 2010 based database development. However, there is not any link of your current MS-Excel file as you have mentioned on the project description. I would like to propose to build system on MS-Access 2010 with own ribbon menu for navigation. Yes, we can create data entry system where we can assign one/more subject for a victim. Furthermore, we can filter report based on the date range and subject as well . Please share the current MS-Excel file so we can discuses further. Thank you. Regards, Havit
$250 USD 在7天之内
5.0 (12条评论)
5.5
5.5
用户头像
Hey, Can you share the Excel file you mentioned in the project description? I am an excel and access expert and can create the desired database structure for your purpose. Please send a message to me if you would like me to work on this project for you and we may discuss the next steps. Look forward to hear from you and thank you for considering my bid. Best Regards, Rishi (Automyze Consulting)
$250 USD 在7天之内
4.9 (46条评论)
5.6
5.6
用户头像
I'm making this kind of desktop applications for small scale businesses. We can talk about the specifics when the bid is accepted.
$200 USD 在3天之内
5.0 (50条评论)
5.4
5.4
用户头像
Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA. Any code I provide is well structured and commented, client gets whole access and rights for the code I made. Warranty covers any bugs detected later. Looking forward for further clarifications of the details. Regards, Sergey
$150 USD 在7天之内
5.0 (9条评论)
4.6
4.6
用户头像
Hi, I have been an independent Access programmer in New Jersey for the last 20 years. Access is all I do, full-time. Hence I work quickly and efficiently and have a lot of great ideas from all the projects I have worked on. I have designed thousands of programs for hundreds of companies in the New York metro area. I have completed over 150 jobs on Upwork/Elance/Freelancer/Guru. I am available by phone or email, business and non business hours. and will be around in the future if you need little tweaks. I can respond quickly to requests. Better known companies I have worked for over the years are Shredit, Shiseido, Multi-Lok , The Alzheimer's Organization and Shop Rite. I would be glad to talk to you on the phone in detail and come up with a more accurate quote.
$250 USD 在3天之内
5.0 (6条评论)
4.7
4.7
用户头像
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.
$111 USD 在3天之内
4.9 (29条评论)
4.4
4.4
用户头像
Can get the Excel sheet imported into the database. Have expertise in MS Access and Excel automation. Have experience in database designing, ER diagrams and table relationships and constraints, have done similar freelancer projects. Create the simple forms for data entry and reporting on the same. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Please review my portfolio on recent projects completed. - Have done Heating design based on current/voltage restrictions for each mat having multiple models, exam results grading by finding keywords, Canadian Province tax calculations based on province parameters, , merger of rows and columns of data based on key values My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Outlook automation - Performing different actions other that using the existing rules, updating calendars based on logic. - MS Access - Expert in designing table, user input forms and also reporting from data. - Excel to MS access data porting and conversion and designing new system for use.
$100 USD 在3天之内
4.8 (13条评论)
4.4
4.4
用户头像
Hello from across the pond! I am a certified Microsoft Office specialist who works as a data analyst. I live and breathe database creation, data manipulation and automation through VBA. I have recently created a similar database for a client, who wanted a database and a report section, which output into an excel document, and I would be happy to provide details if required. I have always completed my work in the agreed time and budget, whilst keeping frequent communication on progress. Please don't hesitate to ask any questions. Thanks, Arran
$120 USD 在3天之内
5.0 (6条评论)
3.1
3.1
用户头像
Hi, I have more than 14 years of MS Access and Excel exp and I am expert in this kind of work. Please send me more details (attachment is missing) so that I can estimate cost and time better. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$250 USD 在12天之内
5.0 (3条评论)
1.8
1.8
用户头像
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 the project, from design to development, importing data, testing, documentation and production support. Look forward to your prompt & affirmative response. Best regards, Anita
$150 USD 在10天之内
5.0 (1条评论)
1.7
1.7
用户头像
I have a Bachelor’s degree in Computer Science with 5 years experience in Academic, Articles, Reports & Technical Writing. I have experience in handling Thesis, Dissertations, Coursework, Session Long Papers, Manuscripts, Term papers, Business Plans & Presentations among others. I am proficient in Cloud Computing, Software Engineering, I.T Security & Networking, Ms Project, Office Applications, and Latex. As pertains to this project, I have read and understood all the instructions. I will deliver a quality and 100% original paper. I will deliver the paper within the given deadline and will engage in constant communication to avoid any inconveniences.. Regards, Isaac
$100 USD 在3天之内
1.8 (1条评论)
1.6
1.6
用户头像
There is no attachment. Since I could not see the Excel file I cannot comment on the same. But, yes if you are having data in excel, I can convert it into a good database with all the reports you want. Please share your excel sheet for specific inputs from my side.
$133 USD 在3天之内
5.0 (1条评论)
0.4
0.4
用户头像
my suggestion is develop windows based application using c#.net. Hi, Myself expert in asp.net, c# and sql server with 10 yrs of experience in software development. Experienced in technologies like Asp.net with c#, c#.net, WPF, Asp.net Mvc3, Sql server 2005/2008, linq, entity framework, javascript, jquery, xml, ajax, json, Html5, webservices, SSRS, telerik and devexpress controls. Developed various web and desktop applications for finance, insurance , education and research domain. Let me know ur requirement in detail. Awaiting for your positive response. Payment terms: 1. 20% release on awarding the project. 2. 20 % release on 1st phase UAT. 3. 20% release on 2nd phase UAT. 4. 20% release on UAT sign off. 5. 20% release on project completion. Thanks and regards...
$250 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, I'm new to this so I am willing to do this at a low cost and turn it around quickly. I have over 12 years experience in the finance sector and I am an advanced user of excel and Microsoft access. Thank you
$150 USD 在5天之内
0.0 (0条评论)
0.0
0.0
用户头像
Expertise in ms access
$66 USD 在2天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
United States
0.0
0
会员自10月 11, 2016起

客户认证

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