Find Jobs
Hire Freelancers

I need a developer to complete a partially built Access database

£250-750 GBP

已取消
已发布将近 9 年前

£250-750 GBP

货到付款
General information for the business: We sell 175,000 variants of 200 products across Europe Database management system (DBMS): Microsoft Access Description of requirements/functionality: The role of the developer is to initially provide inhouse programming support for the existing database (Sprint 1) which has been scoped and developed by the Supply Chain Manager in accordance to current processes. As the database grows to cater to the end user process, there are a number of areas where the basic Access tools are not enough to complete a specific tasks, programming code is needed. The developer would need to understand the processes involved and program the code to achieve those actions, it is therefore required for the developer to attend our office in Camden, London for the 1st Sprint development and go through and understand the complex functions. The work will need to start on 11/05/15, with a plan to have Phase 1 complete and tested by end of the week. In addition, the developer would also act as an adviser and advise best practice processes for the database development. Specific technologies required: MS Access Extra notes: The current database is in the processes of development with the majority of key tables present and are being transferred to the sql server. The query views have been prepared in line with the various user views required for the forms. The Form views are still being developed and require programming to complete the action buttons and quick access/manipulation of the Data. GOAL The aim of this project is to create a centralised user friendly datasource which caters for the needs of the purchasing function of the business. The primary deliverable is the user ability to easily copy paste/import basic data from large datasets in excel into the relevant screens on the database, and then Accesspulling out the related data (ie paste ProductCode and Quantity, access retrieves related info ie. ProductName, UnitCost, Currency, LineAmount, etc). The secondary objective is to ensure the database is used as a core tool for communication, allowing user to update dates and add comments regarding specific orders/shipments without having to search through hundreds of emails. Once the initial requirements are addressed, there will be a need for further development to create the order proposal functions which allows the user to calculate what products to order and when.   OVERVIEW To complete the database a sprint approach will be used to deliver the required functions. The tasks below will consists of subtasks and provide the developer with full insight (images and detailed descriptions) of the work required. This will be tracked and updated using a Jira web portal. Sprint 1 1. Review current database structure and relationships 2. Make recommendation/changes to improve performance 3. Complete Multi User access (Login Menu) with login defaults 4. Complete the Order View form 5. Complete New Order Creation form 6. Create order reconciliation function with to match open orders/shipments to deliveries 7. Create process for splitting orders into physical shipments (many to many relationship) a. One shipment may contain multiple full/partial orders b. One order maybe split across multiple shipments 8. Create process of logging date changes, etc as automated comments and display on order form 9. Complete Pricing Matrix form, allow quick update of unit costs and constraints (ie MOQ) a. Ensure the unit cost can be updated from multiple forms/queries 10. Create Query for average sales per parameter to calculate weeks’ stock in warehouse Sprint 2 1. Create Stock order proposal function with automated supplier nomination a. One product has multiple suppliers, priority goes to unit cost and leadtime 2. Create an RAG status based on immediate shortages and propose orders 3. Develop the live exchange rate function to allow user to select live data instead of fixed 4. Create dashboard reports
项目 ID: 7612709

关于此项目

12提案
远程项目
活跃9 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
12威客以平均价£766 GBP来参与此工作竞价
用户头像
Hi I am interested in this project. i am an experienced Ms-Access database applications developer. i can do the job for you. if interested in hiring me then please let me know so that we can discuss it further. Thanks. Regards, Jawad
£500 GBP 在10天之内
5.0 (85条评论)
5.8
5.8
用户头像
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. I have worked on lot of advance Microsoft access database, SQL, MYSQL,SQL server and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
£600 GBP 在10天之内
4.9 (14条评论)
5.7
5.7
用户头像
A proposal has not yet been provided
£750 GBP 在10天之内
5.0 (6条评论)
4.8
4.8
用户头像
I am interested. can we discuss? .
£300 GBP 在10天之内
4.9 (19条评论)
4.5
4.5
用户头像
Sir need to discuss with you. thanks..................... ..................
£722 GBP 在15天之内
5.0 (4条评论)
3.7
3.7
用户头像
I have experience of 2 years in database .I will definitely complete your work on time and deliver it to you.
£250 GBP 在6天之内
4.4 (28条评论)
4.0
4.0
用户头像
Hi, We are a professional Web Designing & development and Mobile app development company, Leo IT Hub. We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us this opportunity. Our team is experienced, creative & efficient enough to get your job done well. If you have any questions or wish to discuss your project further then please let me know here...
£750 GBP 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
I hereby submit my offer to undertake the contract scope of works and services described in your tender. I shall bring over 20 years experience building business applications with Ms Access. All developed modules shall be warranties for a year and programming code well documented. Please contact me i you have questions on any or all aspects of my offer.
£666 GBP 在20天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
£555 GBP 在10天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED KINGDOM的国旗
United Kingdom
0.0
0
会员自5月 5, 2015起

客户认证

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