How can I create a Stock Control system for a Public House using .

[Guest]

.... Microsoft Access. I would like to be able to have a core 'Cellar Stock'
database, which contains all the stock in the cellars/stockrooms at any one
time, and a different system containing the stock held in the bar on shelves,
fridges etc. When stock is taken from the cellar to go to the bar it is
written down on a stock movement sheet (product name, quantity, where to?,
etc). I want to be able to have a system, whereby, at the end of each night
the stock sheets could be input into a form, and it would 'move' the stock in
the database system from the cellar to the bar, and vice-versa (incase of
excess stock being brought to the bar etc). So that, at any one time, I can
count the stock in the cellar, and check it against the system to see if
anything is missing from the cellar.

Additionally, I would like to be able to see a report of site-stock
(cellar+bar+any other locations it may have gone) to aid in our monthly stock
check.

I would also like to include a system whereby sales from the till could be
input, to minus from total site stock, and spillage/hospitality drinks could
be entered to minus from total site stock, etc.

basically, I would like to be able to control each item of stock in my
establishment, right down to the ast measure of vodka, and the last bottle of
beer.

Can anyone tell me how I would go about this? I'm lost

I am using Access 2002.

 

[Nick Coe \(UK\)]

Sorry Joe, but I reckon this is into the 'paying someone to
do it or help' category.

To get you started - I'd have a table that described every
item that could be stock, a unique list with no stock
quantities or locations and an id no for each.

Then I'd have a table that described unique locations with
an id no for each.

These two tables are really your dictionary of items and
places.

Next you create a table where you have the id for a place
against the id for an item and a stock qty. You will have a
number of instances of each place id because you will have
many items in each place.

That's where I'd start....

After that there's Forms, Reports and so on... Have fun
)

And yes I am available at the moment, but that's not why I
said what I said in the first sentence.

--
Nick Coe (UK)
www.alphacos.co.uk

---

message

... Microsoft Access. I would like to be able to have a core 'Cellar Stock'
database, which contains all the stock in the cellars/stockrooms at any one
time, and a different system containing the stock held in the bar on shelves,
fridges etc. When stock is taken from the cellar to go to the bar it is
written down on a stock movement sheet (product name, quantity, where to?,
etc). I want to be able to have a system, whereby, at the end of each night
the stock sheets could be input into a form, and it would 'move' the stock in
the database system from the cellar to the bar, and vice-versa (incase of
excess stock being brought to the bar etc). So that, at any one time, I can
count the stock in the cellar, and check it against the system to see if
anything is missing from the cellar.

Additionally, I would like to be able to see a report of site-stock
(cellar+bar+any other locations it may have gone) to aid in our monthly stock
check.

I would also like to include a system whereby sales from the till could be
input, to minus from total site stock, and

spillage/hospitality drinks could