Red Mosquito
http://forums.theskyiscrape.com/

Help building a database
http://forums.theskyiscrape.com/viewtopic.php?f=14&t=10571
Page 1 of 1

Author:  meatwad [ Thu September 21, 2017 2:38 pm ]
Post subject:  Help building a database

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?

Author:  --- [ Tue October 10, 2017 1:48 am ]
Post subject:  Re: Help building a database

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

Author:  lennytheweedwhacker [ Tue October 10, 2017 6:32 am ]
Post subject:  Re: Help building a database

--- 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

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/