Find Jobs
Hire Freelancers

I need a developer to complete a partially built Access database

£250-750 GBP

Скасований
Опублікований almost 9 years ago

£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 yrs ago

Хочете заробити?

Переваги подання заявок на 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, 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)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.