Excel inventory database
Hello EE, I have been set the task of putting together an inventory database (preferably in Excel). What I would like to do is be able to alocate each location within the warehouse a specific name e.g. row 'A' column 'A' & 'row 'A' column 'B' etc or a site name e.g. Home, Office etc and from this give each one a unique barcode sticker (any barcode software recommendations are welcome!!!). What i would then like to do is have excel linked to that barcode software so that when I input specific details of an item it produces a barcode specific to that item...... From this I would like to be able to scan the item and then the location and for excel to put them both together.....if and when a few items are scanned to one location i would like for excel to colate the information so it gives you the quantity rather than a list of the same individual items. Within the stock database i want to be able to then print a stock list per warehouse location, per site location or per item
Basically what i want to know is how easy would the above be and for any recomendations!!!
Thank you in advance for you time.......
Regards
Carl
Basically what i want to know is how easy would the above be and for any recomendations!!!
Thank you in advance for you time.......
Regards
Carl
ASKER
Thanks scott, trouble is i don't know a thing about access..... Is it some thing that with a decent concept of excel would be able to transfer knowledge over to access??
You may want to purchase or borrow a book on it. There's lots of beginner and intermediate books that will get you started. It's worth it! Anyone in a position, such as yours, will benefit by leaning how databases work. What you learn in Access (databases) generally applies to all/most databases.
Scott C
Scott C
ASKER
Any book recommendations???
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thank you Scott, point taken
Excel can work adequately as a database, admitted Access is best for larger amounts of data
Databases manage data. Spreadsheets manage "what if" questions and scenarios, and large reports that span wider than a page (where the query is run in Access and exported to Excel).
I'm a heavy database (Access) as well as Excel programmer and I could type all day expaining my suggestion.
Scott C