Find Jobs
Hire Freelancers

Develop an Access database for production planning

£250-750 GBP

Closed
Posted over 9 years ago

£250-750 GBP

Paid on delivery
To develop a production planning system using Microsoft Access. We are a small food manufacturing operation and need to upload orders from our Sage system and then to use several rules to produce a production schedule and capacity plan.
Project ID: 6572655

About the project

50 proposals
Remote project
Active 9 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
50 freelancers are bidding on average £448 GBP for this job
User Avatar
Hello, Do you have more details about the project? I am placing a bid on presumption, but I will rather see and discuss the project first. Regards, Branislav Mihaljev
£555 GBP in 10 days
5.0 (222 reviews)
6.3
6.3
User Avatar
Hello I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other database. I am also among the top three MS Access developers on this site. You can verify by going to https://www.freelancer.com/freelancers/skills/Microsoft_Access/ Please consider this a tentative bid - I will confirm the time and amount once I know the full specs. Please let me know if you have any questions. Look forward to hearing from you. regards Rajiv
£277 GBP in 10 days
4.9 (107 reviews)
6.3
6.3
User Avatar
Hi there. I have developed a very similar program in Access before and I can design one for you too. The one I developed had a front end user interface in Excel and the back end was Access. Kindly discuss the details. Regards.
£500 GBP in 5 days
5.0 (45 reviews)
6.1
6.1
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
£526 GBP in 8 days
4.9 (91 reviews)
6.1
6.1
User Avatar
Hi, I have worked on production planning systems for other customers in the past. Provided them forms, reports and graphs. Some of the features include how many quantities are required to complete the various processes involved in making of each part, which weeks are already planned and which are pending to be planned. Do we have enough material for making the part as per the production plan etc.. So essentially there are many features and we can have discussions to understand your scope and related business rules. Mentioned below is my brief profile. ============================= Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010 projects both big and small using MS Access as a front end as well as back end. I have worked on Forms, Queries, Modules, Reports, Sub Reports, Macros, Switch Board Manager, Linked Table Manager etc. With the kind of experience I am having I can assure you of quality work first time and on time On this highly competitive site I fully understand how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
£325 GBP in 10 days
4.9 (60 reviews)
5.6
5.6
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this regard. with thanks and regards
£444 GBP in 10 days
4.5 (35 reviews)
5.5
5.5
User Avatar
Good Day, I would like to express my interest in your project. I am a holder of a BSc. (Hons) Computing degree from the University of Greenwich (UK) and have over 8 years professional work experience in the IT industry. I have an excellent grasp of database design/development, SQL, MS Access, Visual Basic for Applications, data import and export to MS Excel, txt, and pdf, etc. I would be very glad to provide an MS Access database that will import Sage order data from Excel/CSV and then apply rules to produce production schedules/capacity plans. Please find below some MS Access applications that I have worked on: ( A ) MARKETING CONTACTS DATABASE: Complex database for keeping track of clients who are targeted for various marketing campaigns. Utilises complex SQL queries to filter clients based on various criteria. Includes bulk importing and exporting of data to MS Excel. ( B ) PROJECT MANAGEMENT DATABASE: For management of Project and related data, report generation and emailing of reports as pdf attachments, etc. ( C ) MEMBERSHIP MANAGEMENT SYSTEM: For management of Membership and related data, barcode printing on member ID cards, barcode event registration, etc. I would like to assure you that I am committed to providing you with a system that meets and where possible exceeds your requirements. (Excellent references and work samples are available on my profile page.) Please feel free to contact me in case of any queries. Thank you. Yours Sincerely, Jeane
£350 GBP in 10 days
5.0 (5 reviews)
4.9
4.9
User Avatar
Hi, Approach: To solve this problem, we can develop an analysis Tool (Management Information system) which takes SAGE reports as input and creates reports for business decision making. This is a great tool which can help you respond to day-to-day business problems quickly and effectively. Tool description: Organization: It could have three parts: 1) Database, which holds SAGE data 2) User Interface, to provide user input 3) Processor, which runs various programs and creates analysis reports and charts. Functionalities of management information system (can be customized to your requirement): 2) Operations analysis 5) Inventory status. 3) Other requirements Tool language:It is based on Microsoft excel and uses VBA code for operation. I would like to share a similar system made fro another client. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. Regards! Vikas
£388 GBP in 10 days
4.9 (17 reviews)
4.8
4.8
User Avatar
HI I am an excel-visual basic expert and I can help U with your project pm me ............................................................................
£500 GBP in 10 days
4.9 (22 reviews)
4.8
4.8
User Avatar
Hello I am working with MS-Access database and VBA for the past 14 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Access Projects through Freelancer.com. I would do your work and is ready to start right now. Give me the job, get it done, satisfy yourself and then make payment. I wont seek any payment from u until ur job is fully done as per your satisfaction. Customer satisfaction is much more important and my top most priority. No satisfaction no payment. Hope to hear positively from u. Regards John
£250 GBP in 7 days
4.8 (30 reviews)
4.7
4.7
User Avatar
HI, Access and Excel VBA expert here, I offer you access 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, the user interface structure of the application will be such that there will be a single Home form and all the other forms can be loaded on this main Home form through button clicks to access their functionality. I can offer you with a very dynamic access reports, dynamic in terms of their structure i.e. the structure of a single report can change depending on the data to be displayed on it each time for e.g. access reports can be used to generate invoices on them, now as structure of the invoice is dynamic i.e. there may be any number of items billed, so in such scenarios I can offer you reports which can handle this dynamic nature of such data. Criteria for the data to be displayed on the report can be set on user forms and they can be generated on button clicks. I want to send you an access DEMO application to give you an idea of the functionality that I can offer you, if you could reply me on this message I will be able to send you the demo app. Regards.
£250 GBP in 10 days
4.9 (33 reviews)
4.6
4.6
User Avatar
I have spent the last 14 years working in the finance industry where I used Excel and Access for many applications to improve the efficiency of the business. Prior to that I worked as a Supply Chain Mgt consultant, so have a strong understanding of production planning, MRP which will be useful in this project. My original qualification was as a Mech Engineer. Key to success with project like this that are delivered remotely (client and consultant in different countries) is communication. Having English as a first language, I see is a distinct advantage to ensuring we have very clear and open communication when gathering your requirements - something we will do over a Skype call (unless you have requirements already documented). The benefits that I can bring to a project like this is a large experience in operational efficiency, having managed the global operations for a finance business. This means I will be able to recommend improved ways of doing things and optimise your solution so that you get the most value from it. I also have a vast experience in project management having worked on both sides, both as client and as solution provider, so really appreciate and understand the best way to run projects like this to maximise success. If you would like to get more detailed information on me and my skills, please message me and we can chat online or on a Skype call. I look forward to working with you if I am successful with this bid. Thanks and regards Steve
£500 GBP in 10 days
5.0 (4 reviews)
4.6
4.6
User Avatar
Hi, I have been designing production systems using data coming out of Sage and Microsoft Access as a reporting tool for some 18 years. II have even exploded bills of material down 3 or 4 levels. I have worked for Bylada who makes frozen food in New York. I have done production planning systems for a subsidiary of Shiseido, for a manufacturer of wipes, for a manufacturer of hair accessories, and for Multipliar a manufacturer of cell phone batteries.( just to mention a few) In general I have been writing reports for over 20 years for Sage 50 and Sage 100, using Access as my programming tool. I have worked for close to 500 companies over the years on projects large and small. Of course besides reports, I create all sorts of programs using Access. A production planning tool is in fact much more than a report with Access because you really have to write a program. I just completed an inventory report for a clothing importer. He exports his Sage order,purchase order, and inventory files to Excel and I consolidate all the data into one report that shows his available to sell. We even take into account on the water shipments. Anyway I would be glad to talk to you about your project and send you screenshots of projects I have done..
£444 GBP in 10 days
5.0 (4 reviews)
4.2
4.2
User Avatar
Hello, Thank you very much for posting the job. Though I am new to this particular site I have been freelancing for years and I also have 7 years of professional work experience. I have worked on lot of advance dashboards on Access and delivered them successfully with high quality. I am looking to establish in this site and therefore quoting very low. In regards to that I will not only do this work for you at this low price but also, if you are willing, will work on one more project of yours for a very low price. I hope you help me establish myself here by giving me this project. To give you background, I worked in a healthcare company for 3 years where I got an opportunity to work with the production team on a project very similar to this. I created several tools and reports that helped them track several KPIs and make very informed decisions. The tools help them in batch planning, raw material management, downstream and upstream optimization, capacity planning and forecast, bottleneck analysis etc. I feel very happy to bring one more point to your notice. I have won all the contests that I participated in this site. This shows the skills that I possess. Thanks & Regards
£500 GBP in 10 days
5.0 (2 reviews)
4.1
4.1
User Avatar
I have been in this industry for 6 years and such jobs are my daily practice. I can assure you that if you work with me once, you will always work with me for these kind of projects. I have been read your Project description throughout. I have been made this type of application many times and I can do all the thing in $555 in 7 days. You can see my profile for more details . See some screenshots of my previous work in my portfolio. Let's discuss for even more details before you award me the project. Thank you in anticipation. Have a nice day...
£555 GBP in 30 days
5.0 (8 reviews)
3.5
3.5
User Avatar
I'm expert in excel and ms access. I'm developer/programmer.I have developed many software's/web applications. You said, you want to upload orders into ms access database from Sage system Can you please explore this little bit more. Can you please explain rules? and capacity plan and production schedule Thanks
£349 GBP in 10 days
4.9 (23 reviews)
3.3
3.3
User Avatar
Hi, why shall I say more words! I guarantee that the job will satisfy all your requirements. You can select any freelancer that he inspire you the feeling or their feedback. I'm just the one, just I can say that I offer unlimited revisions until you are 100% satisfied. Let's get started! Respectfully, Liviu
£500 GBP in 20 days
5.0 (4 reviews)
3.1
3.1
User Avatar
Hello, I'm an expert C# developer with experience working with Access Databases. I can deliver this project as a .net application with Access Database. Please let me know more details about your workflow.
£250 GBP in 15 days
5.0 (3 reviews)
3.0
3.0
User Avatar
I have developed a number of Access databases and can easily help you move to sql server at later stage if that becomes a requirement.
£555 GBP in 10 days
5.0 (1 review)
3.0
3.0
User Avatar
I have 15 years experience in access database design and development. I have completed well over 250 custom databases in this time. I have worked on existing databases and created from scratch. A list of some databases I built are. ASCL database for Major Hospital in OKC. A scheduling program for the anesthesia department for a Major Hospital in OKC. A ford Parts Database to help a company keep track of inventory in house and EBay. and Many more. I was on Freelancer for 3 years and my account was hacked and I had to create a new profile. I have all my feedback from that site if you want to see them.
£555 GBP in 10 days
5.0 (3 reviews)
2.8
2.8

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Oct 10, 2014

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.