Find Jobs
Hire Freelancers

Access Pick List

$250-750 USD

Closed
Posted about 10 years ago

$250-750 USD

Paid on delivery
I have an excel spreadsheet with inventory product listings. This sheet may have listings for the same product number in numerous warehouse locations. When a product is delivered and a current location is full, the product is entered on a new row on the sheet with its description and new location and count at that location. The project is to create an access database linked to this spreadsheet so the excel sheet can be searched and reports created. Specifically, I want to create pick lists from orders that come in every day..Product numbers will be entered on a form to search for all the locations in all warehouses for that product, and the inventory count at each location. These found locations will be sent to a "pick list". The next item will be searched for locations, and the results sent to the pick list and appended to the first search list. The operator will repeat this until a complete list is created with all the items to be picked with all their respective locations. An "amount to be picked" field will be provided for each product so that a quantity to be picked can be entered. Then, this list(report) can be printed out. The warehouse worker will use this list to locate and pick amounts required for each item. Warehouse worker will have the option to correct the count at each location should he find it is incorrect. A "Pick List Tab is included in this attached excel, but it does not work reliably. I think it is beyond fixing. The sheet to link will be tab "Consolidated" Thanks, Dave
Project ID: 5373547

About the project

26 proposals
Remote project
Active 10 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
26 freelancers are bidding on average $2,338 USD for this job
User Avatar
Hi Dave. I can create the Access Database for you that would be linked up with Excel. I have read the description in detail and can design to have the pick list created from multiple locations. I have done very similar projects in both Access and Excel before and I can handle this one for you. Kindly discuss so we may proceed. Usman.
$390 USD in 6 days
5.0 (77 reviews)
7.0
7.0
User Avatar
hey Dave, this is feasible, i hope you are using WINDOWS. please reply, we can discuss further, thank you !
$250 USD in 6 days
4.8 (168 reviews)
6.0
6.0
User Avatar
Hi, I am a developer with over 23 years experience building complex database systems, specialising in the development of applications in MS Access using VBA and WinAPI. I could produce Access database that would match your project specification within a short time period. Please view my portfolio for some examples of my work.
$300 USD in 7 days
4.9 (23 reviews)
5.5
5.5
User Avatar
A proposal has not yet been provided
$388 USD in 10 days
5.0 (57 reviews)
5.5
5.5
User Avatar
Hi, Approach: For your project, I expect solution to be on following lines: 1) User form: This will be design on excel and will collect user inputs, which will then be stored in ACCESS DB. This will be connected to various data sources. 2) Access operations: Need to control database operations, (like automated picking of raw data from sources, formatting it to be stored in predefined format). Buttons will be provided in User form sheet to control operations like this. 3) Processing/Calculation logic: Logic will be needed to perform data processing/calculations over formatted data. In my estimation, whole process may take 5 - 7 days for completion. This estimation will also depend (and may vary) on how prepared you are with project draft and related details. I believe I have understood your requirement and can help you in that. [I have worked on similar project before like preparing Management Information System, PWA analysis etc.] My background: I have been working as Sr. pricing analyst since last 4+ years. During this stint, I have worked on projects involving price models, creating competitive information databases etc. In my projects, I work extensively on excel (with 100K rows of data from production sites). Please revert back for any questions/clarifications. Regards! Vikas
$289 USD in 5 days
4.9 (38 reviews)
5.6
5.6
User Avatar
Hello sir, i read your requirements very-well and ready to start work from now. Hope you will give me a chance to do work with you, waiting for your reply, Thank you
$250 USD in 2 days
4.9 (12 reviews)
5.3
5.3
User Avatar
Hi, I build robust, strategic business solutions. Period. PEDIGREE / PREVIOUS WORK My pedigree includes these (my own sites and my own developed software): My Excel and Access development site (I also TEACH development): vbafasttrack.com. I recently completed a project to build a Bitcoin trading application, a binomial and trinomial employee stock options model for a mid-tier US investment bank and have an Insto finance and trading background myself. I am also the developer of the following software freelancesniper. Be advised I have my own company doing this stuff and have an institutional IT background. Cheers. SteveP.
$400 USD in 10 days
5.0 (4 reviews)
4.7
4.7
User Avatar
i can handle this task for you withou any problems. I have a wide experience with XLS and Access. I create websites and web application based on custom designed access databases. You can rely on me to complete this task for u.
$50,515 USD in 15 days
5.0 (3 reviews)
4.6
4.6
User Avatar
Hi, Having more than 12 years of experience in development.I have done so many inventory project. I have gone through the excel sheet I am ready to help you, Please check my portfolio for work sample I will deliver you this as early as possible. Looking forward to hearing from you Thanks Chetnaa Desai
$250 USD in 5 days
4.5 (18 reviews)
4.7
4.7
User Avatar
Hi, I am interested in the project. I hold a MSc in Finance and a BSc in Economics, although I think that for this project these are not required. I am skilled at Excel and VBA and this will probably help a lot. Kind Regards.
$333 USD in 10 days
4.7 (4 reviews)
3.4
3.4
User Avatar
I am ready to to work and delivery the access databas as per your guidelines / Than k you
$250 USD in 3 days
5.0 (3 reviews)
3.2
3.2
User Avatar
Hello! I have 8 years experience in programming and know Excel and Access well. I can make this project for you. Everything will be done according to your requirements.
$250 USD in 7 days
5.0 (3 reviews)
3.2
3.2
User Avatar
Hello there, It is my great honor to apply for this job vacancy. I am very hardworking and can work effectively as fast as I can. I have excellent skills in Data Entry, Web Research and Microsoft Office and I have enough experience with different kinds of tasks as you can see in my "Work History", most of the time I gave my clients a great result. I have a fast internet connection at home, have my own PC to use anytime and have own space to work. I can work full time and will focus on this project. I can follow instructions very well and will deliver the project on time. It is a pleasure if ever you will message me for an interview. I can work as soon as possible. Thanks and more power.
$250 USD in 4 days
3.8 (13 reviews)
3.8
3.8
User Avatar
Hi, I'm very interested helping you creating your Access database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database assignments. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details if you have about your project, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$736 USD in 15 days
3.5 (7 reviews)
4.2
4.2
User Avatar
Hello, I can develop your application. I'm a Freelance With 10 Years of Experience In Developing Applications On Ms Access For Small, Medium And Large Companies For Public And Private Sector.
$250 USD in 2 days
5.0 (1 review)
2.2
2.2
User Avatar
I am available right now. I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, AJAX, CSS, XML,DNS, IIS(Admin),Oracle PL-SQL,Classic ASP, MS SQL (DBA,T-SQL),VB 6.0,VBA,COM/DCOM,VB Script,MS Access, Excel, Macros, Flash (AS2, AS3), Crystal Reports (Designer and Server), ColdFusion
$833 USD in 5 days
5.0 (1 review)
0.6
0.6
User Avatar
Hi There, I'm relatively new to freelancer but not to software development especially related to ERP systems. ERP includes pick list, inventory management, pack slips, purchase orders, sales orders, invoices, lot tracking, bills or material. Using Visual Basic I wrote from scratch a ERP system (that included pick list) this system had over 2 million lines of code and is in use today by many aerospace manufactures and distributors. It sounds like you are a distributor. I've developed in MS Access and Excel for 15+ years. I understand the project is urgent and my schedule is free to start tomorrow 1/30 if you like. I see the project timeline spanning 3 days. Day 1 prototype + user feed back, Day 2 code + user feed back, Day 3 user acceptance testing and any final changes. Inventory systems and my forte. I'm really looking forward to the opportunity to deliver this project to you. Warm Regards, Nathan
$400 USD in 3 days
0.0 (1 review)
0.0
0.0
User Avatar
La propuesta todavía no ha sido proveída
$333 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Respected Sir, I can do this task as early as possible so, please assign this project to me. I am waiting for your reply.
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$266 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Olney, United States
5.0
5
Payment method verified
Member since Aug 2, 2013

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.