Access as Inventory Tracking System

[tinkerbell737]

I am somewhat new to Access and I wanted to know if it could be efficiently used for an inventory tracking system. Basically, I want to enter the inventory for supplies I have on-hand and then create a way for me to remove 'stock' by making an invoice or something. Is that really possible?

I was thinking also that I might be able to accomplish this in Excel by maintaining the inventory in one workbook and a 'stock removal' sheet on another workbook that would recognize a field (like SKU#) and calculate the removal.

Which might be better for this project, would you advise?

Thank you

 

[Dugantrain]

Ah, the Access vs. Excel question. Search the Archives, this has been explored to no end. There's really no definitive answer, it's a matter of opinion, but a database tool, although more difficult to master, will be much more powerful and save you a lot of headaches in the long run. I'm sure that the majority of experienced Access developers here have done an inventory-tracking thing before, if you want something to go by, someone would probably attach one. I'd attach the inventory tool that I'm supporting now, but it's so complex and confusing (Project Managers changing the scope and requirements of the project on an almost daily basis) that it'd probably scare you away rather than help you.