Red Mosquito

I own a small restaurant and want to create a database of all my inventory. The goal is not really to track inventory as it is to be able to create shopping/ordering lists for employees (since some day I won't want to be doing this crap anymore).

What I envision is a database with every product built in, along with a category (produce, meat, dairy, etc.), a vendor, last date ordered, quantity on hand, secondary vendor...stuff like that. With this I envision being able to just pull up all produce items, or all items I get at Cash & Carry. Something like that.

So my question is, would Microsoft Access be the easiest way to accomplish this given that it's software I already have?

meatwad wrote:would Microsoft Access be the easiest way to accomplish this given that it's software I already have?

yeah

there's some open-source stuff that's a lot more powerful (postgresql), but i'm not sure it's appropriate for what you're needing

--- wrote:

meatwad wrote:would Microsoft Access be the easiest way to accomplish this given that it's software I already have?

yeah

there's some open-source stuff that's a lot more powerful (postgresql), but i'm not sure it's appropriate for what you're needing

you're not appropriate for what i need