Switch to full style
Post a reply

Help building a database

Thu September 21, 2017 2:38 pm

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?

Re: Help building a database

Tue October 10, 2017 1:48 am

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

Re: Help building a database

Tue October 10, 2017 6:32 am

--- 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
Post a reply