buglord posted:

Sup goons. I'm managing inventory for a business, and have been doing so using MS Excel. For a while, the demands were simple enough that the program was a viable option. Now, things have expanded so much that keeping track of all these products and components is time consuming. That, and I can introduce errors pretty easily which causes the whole rickety scaffolding to be wrong.

Is MS Access going to be a better alternative for this? During slow periods, I'm goofing around with LibreOffice Base (because I don't know Access or Base yet). Company is willing to get an Access license, but I'd like to be sure it would be better for me and worth the learning curve before I place the order. Here's what im doing:

-Keeping track of about 50 food products and making sure there's enough of each to produce different menu items. Some food products are shared between menu items, and some aren't.
-Ordering packaging for menu items and keeping track of those too.
-Order food products ahead of time, since it takes about 30-40 days to get the product in after I call in an order. This is where it gets trickier, because I have to look ahead 3 months and be sure our supplies are not too low, but also not too high where food products sit in a warehouse too long.

I feel like there's a much better way to do all this.