Find Jobs
Hire Freelancers

Create a user friendly interface to operate a Microsoft Access database running a warehouse location system

$250-750 AUD

Completed
Posted over 4 years ago

$250-750 AUD

Paid on delivery
We have a warehouse inventory location system using Microsoft access. We currently update all data (pallet location changes, stock codes being removed from a pallet etc.) by writing the changes on a sheet on a clip board which is kept on the forklift, then transcribing from this sheet into the access database at the end of each day, and printing out the stock locations, to be kept on the forklift to search for them when needed. We are looking to improve this system, by creating a user-friendly interface, which can be accessed by a wifi connected tablet kept on the forklift. The data kept in this database includes: - SKU (product code) - Pallet number (each pallet in the warehouse has a unique number) - Date the stock was received (so that we can ensure we send out the oldest stock first) - Bin location - Supplier Refer attached MS Access database currently used to track bulk STOCK (SKUs) on PALLETS and then track the assigned BIN LOCATION of the Pallet. When stock is received, it is placed on pallets which are labelled with a unique ID Multiple SKUs may be on 1 pallet Pallet contents is then recorded, and the pallet is moved to an available bin location (spot in the warehouse pallet racking. As stock in the warehouse picking area is depleted, the forklift operator needs to locate the bulk stock to replenish below. We have outgrown the current system and would like to upgrade the database so that: 1 - It has a user friendly interface 2 - Ability to log on via a WIFI tablet (with different user privileges to the desktop version) while on the forklift in the warehouse 3 - Cloud based is OK 4 - Use a Tablet on the forklift to search for a SKU to locate the Pallet and the position of the Pallet within the warehouse (that is its Bin Location or Zone). 5 - Be able edit data on the fly to remove SKU(s) from the pallet as they are depleted, and if no other SKU’s are on the Pallet, clear all data on that pallet, so that the pallet and bin location are available for future use (and stop showing up in searches for that SKU. 6 - The migration of updated data to any new solution. Note that in some cases we have the same SKU (code) from different suppliers, but these are a different products. We differentiate them by adding a SKU prefix for each different supplier, so that we no longer have the same product code. We add a SKU prefix to every item, not just the ones where there are duplicates from different suppliers. Please provide feedback regarding the best solution and a quote to complete the project.
Project ID: 21499181

About the project

22 proposals
Remote project
Active 5 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
I own and manage an IT company and have an inhouse team of web designers and developers. I assign projects to my team while I personally coordinate and communicate. I take up sole responsibility for all deliverables. We have developed several custom web applications and have also developed inventory applications (but desktop solutions for domestic clients). I have read through your requirements and have studied the attachment. I propose developing it in PHP and MySql. We have migrated MS Access applications to web applications earlier also. The details or attachment has no information of how stock is going out/ getting depleted from the warehouse. So please share details. Also when we work if we can have the running MS access application, it will be helpful. We will also need the full database for migration to new solution. I will also need you to book a domain and buy hosting that supports latest versions of PHP and MySql. I ensure a very thorough job and also support if you need changes / enhancements in future. I look forward to hearing from you and working on the project.
$750 AUD in 20 days
4.9 (143 reviews)
6.9
6.9
22 freelancers are bidding on average $580 AUD for this job
User Avatar
I have 15 years experience in UI UX. I have worked with world-class and world brands. I have completed hundreds of successful projects. I would very much like to discuss the details. See my profile Cheers
$1,200 AUD in 7 days
5.0 (159 reviews)
8.7
8.7
User Avatar
Hello! That can be done but with few conditions. First, the tablet must run Windows system and have at least Access runtime installed. There is no MS Access for other mobile device OS. Second, it must be in the same network with your local database. Editing data in Access database is not available over the internet. If you need to make it such, let me know and I'll explain what to do to make it such. Regarding the interface and operations, we can chat about the details, that will be an easier part. Regards, Branislav Mihaljev
$500 AUD in 7 days
5.0 (291 reviews)
7.8
7.8
User Avatar
*** I AM EXPERT IN MS ACCESS DATABASES *** Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$250 AUD in 5 days
4.8 (83 reviews)
7.3
7.3
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$750 AUD in 6 days
4.9 (27 reviews)
6.2
6.2
User Avatar
Hi I've viewed your current DB. Using this I'll enhance this to best condition just on your need. I'll detail on private chat. I'm Ms Access coder since office 97 released. I hope hear soon from you. Best regards, Zurab
$750 AUD in 7 days
4.7 (75 reviews)
6.5
6.5
User Avatar
Hi. I’ve read the project description and I u deter and you need a UI for the current access database you have with the specifications mentioned in the brief. This is something I can definitely help you do. About the tablet version I could make a UI that supports both a computer for a desktop version and a Web version for the one used for the forklift. I have a very good idea on how to get this done. The structure of the database shouldn’t be a problem. I can create this in .NET which I have experience for over 5 years now. Please send me a message if you’d like to further discuss details. Best regards, Rodrigo
$555 AUD in 7 days
4.7 (27 reviews)
5.9
5.9
User Avatar
Hi, I am a professional MS Access and SQL database developer with 10+ years of corporate experience. I am developing MS Access since 2008 and SQL server database since 2012. I can provide you best and long term support whenever you required. I am confident on my skills and can meet your expectations easily. I am willing to take care of your project and provide you best support. Please ping me to ahead our conversation. Thank you
$500 AUD in 5 days
4.9 (33 reviews)
5.7
5.7
User Avatar
What tablet you are using or intend to use, and what operating system it's running? If the operating system is other than windows, I can't work on this project.
$700 AUD in 15 days
4.9 (41 reviews)
5.7
5.7
User Avatar
I have studied your doc attachment and have done a similar Access projects before with 5* ratings: • https://www.freelancer.com/projects/database-programming/legal-finances-database-improvements/ • https://www.freelancer.com/projects/php/build-ACCESS-Database-with-external/ • https://www.freelancer.com/projects/excel/Access-Database-design-18665960/ • https://www.freelancer.com/projects/database-administration/Customer-desktop-database-management/ • https://www.freelancer.com/projects/database-programming/Convert-data-Word-table-Access/ • https://www.freelancer.com/projects/database-programming/data-base-search-options/ I am an experienced Access Developer with Database Programming, Analysis and Administration skill. Having the ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products. EDUCATION • BSc Computer Sciences, University of Hertfordshire, UK 2014 • Microsoft Certified Business Intelligence Developer 2009. • Microsoft Certified SQL Server Administrator 2008. • compTIA A+ Certified 2008
$500 AUD in 7 days
4.6 (7 reviews)
5.0
5.0
User Avatar
Hello, I m a web and desktop developer with 9 years of experience in this industry ,I did many management web system and also done an inventory application during my professional life, I can do what you want in the deadline just contact me and we can discuss more about the project. Best Regards Fouad
$500 AUD in 7 days
5.0 (2 reviews)
3.6
3.6
User Avatar
Dear I read your description and I have found that your job very interesting And it would be easy to be done at a short time you can see my work in the profile ---------------------------------------------------- it would be nice to work with you sir :-D Thanks
$500 AUD in 7 days
5.0 (3 reviews)
3.1
3.1
User Avatar
Hi,I can convert/update your access database to a locally website by vb.net, asp.net and ms sql server express, it is better to build this solution to manage users and allow for forklift operator to login in the system by WiFi and to cover the future requirements. I have experience in MS SQL server,asp.net, crystal reports and VB.net more than 12 years. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - University of Syria-Aleppo - year 2006. Programming and database specialized, expert in vb.net and SQL server with all versions, Crystal reports, also expert in iis and Windows servers 2005, 2008, 2012… Other skills: C#,asp.net, Php, my sql , technical & Sage ACCPAC ERP support, SQL Replication, Excel vba and macros, Access vba, Microsoft office(Word, Excel, PowerPoint, Access). Best Regards. Khaled Alflah
$590 AUD in 7 days
4.9 (11 reviews)
3.2
3.2
User Avatar
---- CLOUD INTERFACE FOR YOUR ACCESS DATABASE ------------------------- i already analyzed your access DB and i will make you a cloud interface with all of your requirements fulfill --------------- waiting to discuss with you for further move ------------- 17 years Software Professional with business database expert.
$750 AUD in 7 days
4.7 (4 reviews)
3.0
3.0
User Avatar
Hi Current version of Database is in Very old format Following three solution are possible 1 Re-develop / upgrade to newer MS access version and get wi fi router in your work place. 2. Host the Newer version on Cloud 3 Get the system Developed in ASP.net and SQL server to get it hosted like website Please consider all the above three solution and discuss further. We can provide any one of the above solution Thanks ..
$600 AUD in 35 days
4.5 (1 review)
2.8
2.8
User Avatar
High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I have gone through your Job post and I can understand your job requirement thoroughly. I have a total of 15 years of experience in Web Designing and Development and had completed a number of projects with some great graphics and User Interface so far. I have all the required skills and experience you need for the above Job. I have strong command over: * WordPress, PHP, Wordpress themeing, Plugin Development * Android and IOS all kind of mobile apps development *Responsive theme Design * HTML5, CSS3 , Jquery, Bootsrtap, Git, * Widget Development * Other CMS: Magento, Joomla, Expression Engine, Drupal etc. * I’m honest & trustworthy, dependable & fast learner. * I’ve over 7 years experience in Wordpress Website designing/development. * I am available 40 hours a week for your job. You can be assured of a quality communication and the quality of the work provided from my end. I’m looking forward to hearing from you soon. Thank you for considering my cover letter.
$250 AUD in 7 days
5.0 (1 review)
2.0
2.0
User Avatar
Hello, i have read the details provided..please contact me to discuss more on the project deadline and some other few things
$500 AUD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Brisbane, Australia
5.0
6
Payment method verified
Member since Apr 10, 2015

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.