Need simple database for stock control

[mz007]

hi,

can anyone advise me on creating simple database for stock control,
i am new to database stuff. well so far i have created tables such as





i think i may want to change the column "unit on order" to "outgoing stock" and i want to know how would it update if i put figure in outgoing stock. that will show me whats current stock. thanks

 

[Steve R.]

First, have you done a search of this forum? For example: "Stock Control"

Have you reviewed normalization?

You may want to take a look at Database Answers. Specifically, item #165.

 

[John Big Booty]

...

You may want to take a look at Database Answers. Specifically, item #165.

Nice link

 

[vbaInet]

Nice link

It was right under your nose - first thread:

http://www.access-programmers.co.uk/forums/forumdisplay.php?f=74

 

[gemma-the-husky]

try the demonstration MS Inventory template - it's not bad at all.

google "ms sample databases" - that will find it.

 

[accessfleet]

Have you looked at the inventory template at MS office online in the business template area?

I am currently in month 9 of building your own. It has been a real learning experience for me.

 

[John Big Booty]

It was right under your nose - first thread:

http://www.access-programmers.co.uk/forums/forumdisplay.php?f=74

As you can see I've not explored this part of the forum all that thoroughly

 

[dcartford]

Hi mz007,

For greater visibility, i have included your table's fieldname below :

productid
product_name
product_description
serial_number
units_in_stock
units_on_order
unit_price
start_date

To begin with, the above table would fit to function as your Product Master Table, helping you to store your product profile, not for your stock control purpose. You may need to create a new stock table and referenced the transaction rows to this product_table (via productid as FK, refer book from accountingdes.com). To devise the procedure for updating your stock balance and unit_cost, look for Joe Celko's tips on the fifo and average sprocs, it is created as a UDF from a DBMS.

Good Luck