Find Jobs
Hire Freelancers

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

$15-25 USD / hour

Cancelado
Publicado hace más de 7 años

$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
ID del proyecto: 11598271

Información sobre el proyecto

26 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 15 días
5,0 (1 comentario)
2,6
2,6
26 freelancers están ofertando un promedio de $22 USD /hora por este trabajo
Avatar del usuario
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 en 10 días
5,0 (145 comentarios)
7,1
7,1
Avatar del usuario
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 en 30 días
5,0 (71 comentarios)
6,8
6,8
Avatar del usuario
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 en 10 días
4,9 (172 comentarios)
6,4
6,4
Avatar del usuario
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 en 15 días
4,6 (49 comentarios)
6,1
6,1
Avatar del usuario
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 en 10 días
4,6 (49 comentarios)
6,1
6,1
Avatar del usuario
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 en 10 días
4,5 (70 comentarios)
5,4
5,4
Avatar del usuario
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 en 10 días
4,9 (38 comentarios)
4,7
4,7
Avatar del usuario
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 en 10 días
4,9 (29 comentarios)
4,4
4,4
Avatar del usuario
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 en 10 días
5,0 (6 comentarios)
3,9
3,9
Avatar del usuario
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 en 10 días
5,0 (4 comentarios)
3,5
3,5
Avatar del usuario
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 en 10 días
5,0 (1 comentario)
2,0
2,0
Avatar del usuario
i am good at reading data
$16 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
fast and acurate
$22 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$24 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$22 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$22 USD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de THAILAND
Thailand
0,0
0
Forma de pago verificada
Miembro desde may 13, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.