Database Design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am part owner of a Public house and would like to create a database to
manage the cellar stock (drinks and snacks) and tie this in with suppliers.

We do a stock count each week, I would like to be able to check the stock
held and sold as well as calculate gross profit for a given period.

Any help would be gratefully recieved.
 
I wish that I could drop in for a pint of bitter right now, but I'm 6K miles
away (assuming that you are in the UK).

My standard advice for a business looking at software is this: Have you
looked to see if there is any commercially available software available?
Checked the trade publications? It might seem expensive, but unless you have
a lot of spare time on your hands or are looking to develop new skills, it is
almost always better to buy something off the shelf. The second best option
is to hire someone who is experienced.

Creating a database to deal with stock, suppliers, and profit as you
described is extremely difficult and complex.

Having said that, open up Access but not a database. Go to File, New. When
the Task Pane pops up go down to Templates and click on "On my
computer.....". At the Templates window select the Databases tab. There you
should see database wizards for creating Inventory Control, Expenses, and
others. One of them might get you started. Also back on the Task Pane you
could go to Templates on Office Online where there are more Access database
creation tools.

Cheers,
 
Back
Top