Find Jobs
Hire Freelancers

Convert basic Excel spreadsheet into a simple database

$30-250 USD

Closed
Posted over 7 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 11758434

About the project

38 proposals
Remote project
Active 7 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
38 freelancers are bidding on average $179 USD for this job
User Avatar
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 in 3 days
5.0 (253 reviews)
7.6
7.6
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.
$200 USD in 8 days
4.9 (123 reviews)
6.9
6.9
User Avatar
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 in 3 days
4.9 (159 reviews)
6.6
6.6
User Avatar
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 in 10 days
4.6 (48 reviews)
6.1
6.1
User Avatar
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 in 3 days
4.9 (72 reviews)
5.9
5.9
User Avatar
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 in 7 days
5.0 (12 reviews)
5.5
5.5
User Avatar
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 in 7 days
4.9 (46 reviews)
5.6
5.6
User Avatar
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 in 3 days
5.0 (50 reviews)
5.4
5.4
User Avatar
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 in 7 days
5.0 (9 reviews)
4.6
4.6
User Avatar
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 in 3 days
5.0 (6 reviews)
4.7
4.7
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.
$111 USD in 3 days
4.9 (29 reviews)
4.4
4.4
User Avatar
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 in 3 days
4.8 (13 reviews)
4.4
4.4
User Avatar
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 in 3 days
5.0 (6 reviews)
3.1
3.1
User Avatar
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 in 12 days
5.0 (3 reviews)
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 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 in 10 days
5.0 (1 review)
1.7
1.7
User Avatar
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 in 3 days
1.8 (1 review)
1.6
1.6
User Avatar
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 in 3 days
5.0 (1 review)
0.4
0.4
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Expertise in ms access
$66 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Oct 11, 2016

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.