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?
Help building a database
- Superblood Wolfmoon
- AnalLog
- Posts: 1867
- Joined: Thu November 21, 2013 10:01 pm
Help building a database
I'm trying real hard to be the shepherd.
- ---
- Future Drummer
- Posts: 2439
- Joined: Tue February 12, 2013 5:03 pm
Re: Help building a database
yeahmeatwad wrote:would Microsoft Access be the easiest way to accomplish this given that it's software I already have?
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
- lennytheweedwhacker
- The Master
- Posts: 47947
- Joined: Wed January 02, 2013 3:21 pm
Re: Help building a database
you're not appropriate for what i need--- wrote:yeahmeatwad wrote:would Microsoft Access be the easiest way to accomplish this given that it's software I already have?
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
And they say that a hero could save us
I'm not gonna stand here and wait
I'm not gonna stand here and wait