Find Jobs
Hire Freelancers

Create living database/combined with Excel for customized project management tool

$15-25 USD / hour

Cancelled
Posted over 7 years ago

$15-25 USD / hour

We are looking to create a tool or tool(s) for a particular project as we do not have the bandwidth to create this ourselves at this time and manually executing these tasks is very inefficient, time-consuming, and error prone. We are unsure if this is one project or multiple projects, but will evolve over time and work with chosen person to see what best options are. Primary Immediate tasks include: 1) Build living database(s) in possibly Access that will have all skus we are producing for this client. Examples of data will be part number, specs, cost price, sell price. 2) An increasing list of over 20 sub-customers buy particular skus, and both the number of sub-customers and number of skus will increase and change over time. We would want to be able to pull data based on sub-customer skus into a professional quotation sheet just for that sub-customer. As data changes, we re-run the data pull and will automatically change the quotation sheet with new data. 3) Each month we receive a forecast from parent customer-- need to be able to compare skus in forecast to known skus and immediately know about discrepancies. Quantities per sku set must hit a certain point for us to achieve our target cost price. Automatically analyze incoming data set (which is in excel format), compare to existing inventory, and show what is needed to be produced to meet forecast as well as gap between what is needed to be produced to meet forecast and what is needed to be produced to meet target cost price. Ultimately, this should be able to immediately show us what we need to produce each month and where the gaps are for decision-making. There is a lot of nuance to this and this will involve a lot of back and forth to come up with a solution that is easy to update and difficult for users to break from a lack of knowledge of the program. There are many ways this could go and we may not be thinking of all the right questions to ask or going down the right path. We have an urgent need to solve this quickly as well as building out a more permanent/flexible solution. This is for a single project and the mechanics of creating it may be easy for an expert in Access/Excel. The work will come in deciding the correct inputs/outputs and in making data from the end customer work with it, since we will have limited ability to dictate how they give us the forecast. Right now we are computing all of this with multiple excel spreadsheets from many sources and is highly labor intensive and prone to errors. If this goes well, there are quite a few other projects that would need similar solutions to solve varied and interesting problems. The ideal partner on this will be an expert in Access/Excel and in analyzing our desired end result to guide us to the simplest, flexible solution. My office is based in Bangkok, Thailand, so prefer someone to be in somewhat similar timezeone (Europe to Asia ok) for better interaction. Thanks, Jake
Project ID: 11598271

About the project

26 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
As a Microsoft specialist and access and excel master and trainer for the past 10+ years, I know I am the ideal candid to get this project done for you. Looking at your specifications, it all feels like a single project too me. It might take a bit of time, but I am willing to commit the time to get this done. Access is actually a very good choice. The reason being that it allows for all of the functionality you require out of box. Thus I would recommend the following: - Access Database with live data and front end (Front end allows multiple users to work on itr at the same time. - A 'Switchboard' or main screen which leads of to all areas of the database - A customers form (Capture and view customer details and orders, possibly on subforms to show outstanding quotes etc. - An inventory form (List and record all skus) - An order form (Allocate skus to customers) - Stock levels form (To view and review stock with ability to import external forecasts. This will be tricky though. Importing it is easy, but ensuring it matches up takes a bit more work.) - Integrate reports (Whatever you would deem important) and the queries that manage them - Integrate quotes (This can be done by taking an existing quote layout, rebuilding it in access, and then having the system print or save this when you need it. This obviously isn't everything. But it can be done, that I know. I have done similar projects. Contact me for some consultation and movement forward.
$22 USD in 15 days
5.0 (1 review)
2.6
2.6
26 freelancers are bidding on average $22 USD/hour for this job
User Avatar
Hello. First of all we need to organize and set up the relations and formulations for part 3. Then we will write the VBA code for the 2nd item. And lastly we will create the database solution ( I am not sure if Access is the best) Anyway, if you are interested contact me. Thanks..
$52 USD in 10 days
5.0 (145 reviews)
7.1
7.1
User Avatar
Hi Jake, I am in Asian time zone and pretty comfortable to work with Thailand timings. Being highly skilled in both Excel and Access, I shall be able to complete your project in minimum possible time with accuracy and encompassing all requirements. I have gone through the project description and I think that a mix of Access and Excel will work the best for you. Please discuss your process details and your exact requirement so i can look into developing the design and flow before continuing with implementation. I have done a few very similar projects before and I assure you a great satisfaction at the end of the day. Please discuss. Thank you, Usman
$20 USD in 30 days
5.0 (71 reviews)
6.8
6.8
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. 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.
$25 USD in 10 days
4.9 (172 reviews)
6.4
6.4
User Avatar
Have expertise in MS Access and Excel. Have done automation in Excel and have designed Database for solutions for US based Car mechanic co, currently maintaining a football DVDs co Database for querires in MS Access and forms. Can build a solution based on Customers and Sub-Customers SKUs inflow and outflow. Will design the system and any matching reports that is required out of it. My Skills: • I have very good expertise in MS Access - GUI, Data entry forms, calculations and reportings. • MS Access - Database creation, tables, forms, queries and reports. Form designing, report designing, Reports generation. • WIll provide support for the application during implementation, fix any issues if found free of cost. • Will touchbase constantly to have the progress informed, as well to sort out any queries. • Please review my portfolio on the recent projects in Excel and MS Access.
$15 USD in 15 days
4.6 (49 reviews)
6.1
6.1
User Avatar
p.s. my time zone GMT+4 Georgia , Tbilisi Hi , Jake I'd like to be considered as a programmer for your ms access project. I'm professional experienced ms access programmer. please see my portfolio here. I'll make all your forms, reports etc just on your need via very friendly ms access interface. during coding we will adjust the db to the best condition. Thank for your time. Regards, Zura
$22 USD in 10 days
4.6 (49 reviews)
6.1
6.1
User Avatar
I have the expertise in Excel & scripting in VBA and can do this task, quickly and accurately, as per specification you have provided. Ready to start work immediately.
$20 USD in 10 days
4.5 (70 reviews)
5.4
5.4
User Avatar
Sir. I am interested in your Project. I have excellent skills in Microsoft Access and Microsoft Excel, which will be useful for your project. Project Goal: Create an Information System for your Organization (Microsoft Access/Microsoft Excel) I can create a centralized database, like Microsoft Access, which will be the repository of all your business information. The database will house all your business data and we can create shared access of the database through multiple terminal. Also, this data can be easy exported to Microsoft Excel, which can help you make various business decisions. So, using Microsoft Excel, I will help you develop a Decision Support System. Using Microsoft Access, we can do any sort of reporting using Querying of the Database. Eg. List of top 20 sub-customers with their preferred skus. Also, we can do quantitative analysis by comparing Parent customer data and our database data. Project Timeline: 15-20 days I have completed number of assignments in Microsoft Access and Excel and I am ready to share with you for your kind consider. I am ready to work at mutually comfortable time of zone. I assure you a long term support and service to your information system. I assure you my complete support and service. Please consider my proposal and discuss with me your detail requirement. Thank You Yours faithfully, Saravana Prakash
$15 USD in 10 days
4.9 (38 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.
$22 USD in 10 days
4.9 (29 reviews)
4.4
4.4
User Avatar
Hi, I have been designing spreadsheets for over a decade and understand the importance of relational databases. After re-reading your bid, I found many nuances you require. I use Access as a tool to consolidate data to get back to Excel. I am intelligent and intuitive. I would like to help you. Thanks. -Kevin
$44 USD in 10 days
5.0 (6 reviews)
3.9
3.9
User Avatar
Hello, I am an expert MS Access database designer/developer, having developed MS Access databases for over 10 years for large corporations such as Bayer Healthcare and Genentech, as well as small businesses. Most of my work has been in project management solutions, so I am well-suited to meet your needs. With my experience and using templates I've developed over the years, I'll be able to produce an initial working version of an application for you in a week's time. I'm based on the west coast of the United States (UTC - 0700), but I'm flexible with my time and will be able to accommodate communication at hours convenient to you. I'm looking forward to working with you and helping you organize your data, reduce errors, and increase insights! Best regards, Michael
$24 USD in 10 days
5.0 (4 reviews)
3.5
3.5
User Avatar
Hi there, Will you accept online solution using php, mysql, css ? I have over 6+ years of experience in php, mysql, css, facebook apps. I have developed software like accounting, inventory, food ordering, ecommerce website etc. Waiting for your response. Thanks, Amin
$15 USD in 10 days
5.0 (1 review)
2.0
2.0
User Avatar
i am good at reading data
$16 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
fast and acurate
$22 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Accomplishments in several large Information Technology projects, with a track record of "getting the job done". System experience encompasses: operational and financial. Skills include Enterprise Architecture, Project Management, Test Management, critical assurance, Business Analysis, Data Modelling and Conversion, and training/support/documentation. Expertise in Business Process Re-Engineering tasks. Responsible for the analysis, delivery and deployment of enterprise solutions. Enough client facing experience to understand their requirements with a scope for future enhancements
$26 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$24 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$22 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$22 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of THAILAND
Thailand
0.0
0
Payment method verified
Member since May 13, 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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.