Help building a database

Post Reply
User avatar
Superblood Wolfmoon
AnalLog
Posts: 1867
Joined: Thu November 21, 2013 10:01 pm

Help building a database

Post by Superblood Wolfmoon »

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?
I'm trying real hard to be the shepherd.
User avatar
---
Future Drummer
Posts: 2439
Joined: Tue February 12, 2013 5:03 pm

Re: Help building a database

Post by --- »

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
User avatar
lennytheweedwhacker
The Master
Posts: 47947
Joined: Wed January 02, 2013 3:21 pm

Re: Help building a database

Post by lennytheweedwhacker »

--- 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
And they say that a hero could save us
I'm not gonna stand here and wait
Post Reply