Ditutup

Access Pick List

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

Kemahiran: Excel, Microsoft Access

Lihat lagi: access pick sheet, warehouse worker, want to find worker, find the operator, find number operator use, find number operator, find operator, warehouse inventory, create access database spreadsheet, create access database reports, inventory reports access database report, excel count, consolidated excel, pick excel, excel form access, access create report, access database form reports, create report excel spreadsheet, create inventory excel, project inventory excel sheet, excel spreadsheet database form, search list excel, excel consolidated, create search access database, excel form access database

Tentang Majikan:
( 5 ulasan ) Olney, United States

ID Projek: #5373547

27 pekerja bebas membida secara purata $2262 untuk pekerjaan ini

Prashantskin

[login to view URL] I have gone through your project requirements. I have also gone through your excel spreadsheet.. I will develop the things in access so that you can get pick list.. Do you want to get the pick list in acc Lagi

$555 USD dalam 5 hari
(479 Ulasan)
7.2
maverick44000

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 Lagi

$390 USD dalam 6 hari
(71 Ulasan)
6.8
rhomeu

Hi, I think it would be better to convert your spreadsheet into MS Access front-end and back-end. The data will reside on a MS Access back-end and we will eliminate your spreadsheet for faster data search and it of Lagi

$555 USD dalam 5 hari
(66 Ulasan)
7.0
vikas0903

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 Lagi

$289 USD dalam 5 hari
(38 Ulasan)
5.6
expertatwork

hey Dave, this is feasible, i hope you are using WINDOWS. please reply, we can discuss further, thank you !

$250 USD dalam 6 hari
(149 Ulasan)
5.8
MarlinSoftware

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 Lagi

$300 USD dalam 7 hari
(23 Ulasan)
5.5
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [login to view URL] Looking for further discussions in this matter. with than Lagi

$526 USD dalam 9 hari
(42 Ulasan)
5.6
dynamitewebsol

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 dalam 2 hari
(8 Ulasan)
5.1
NourElDeen

A proposal has not yet been provided

$388 USD dalam 10 hari
(44 Ulasan)
4.8
hilelbaroud

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 tas Lagi

$50515 USD dalam 15 hari
(2 Ulasan)
4.5
SteveP495

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 Lagi

$400 USD dalam 10 hari
(4 Ulasan)
4.7
Edison1983

*****Similar Project, I've done. Please check HOTEL MANAGEMENT PROJECT, IOHL Project samples in my Portfolio.**************** Very attractive user form with lot of function. Good Day!.. I'm a VBA Programmer, having Lagi

$277 USD dalam sehari
(21 Ulasan)
4.4
infoshree80

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 Lagi

$250 USD dalam 5 hari
(17 Ulasan)
4.8
sg11513

Hi, Greetings! I have gone through the project specs carefully and would like to offer our services for your project assistance. We have recently completed a similar assignment. I have attached a small sample o Lagi

$277 USD dalam 5 hari
(15 Ulasan)
4.5
denissilanov

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 dalam 7 hari
(3 Ulasan)
3.2
OriolAM

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 R Lagi

$333 USD dalam 10 hari
(4 Ulasan)
3.4
SCKRamana

I am ready to to work and delivery the access databas as per your guidelines Lagi

$250 USD dalam 3 hari
(3 Ulasan)
3.1
sajebhammad

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 Lagi

$250 USD dalam 4 hari
(12 Ulasan)
2.9
elboukharimu

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 Lagi

$736 USD dalam 15 hari
(7 Ulasan)
4.3
driverahz

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 dalam 2 hari
(1 Ulasan)
2.3