Simple stock control program

[angies79]

I'm really new to this and, although Access looks impressive it also looks
daunting. I am looking to build a reaaly simple stock control program. It
only needs to show the following.

Product List
Product In with quantity
Product Out with quantity
History of Movement

Is access best for this or is there already a program out there which is at
a reasonable cost.

 

[Steve]

Access is the best of the best!!!!

You need the following tables:
TblProduct
ProductID
ProductName

TblProductReceipt
ProductReceiptID
ProductID
ReceiptDate
QuantityReceived

TblProductOut
ProductOutID
ProductID
OutDate
QuantityOut

You can record product in/out on one form. Create a form based on ProductID.
Add a subform based on TblProductReceipt and another subform based on
TblProductOut.

You can report history of movement for your products in similar fashion with
a report/subreport.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[angies79]

Steve

Thanks for this start. the first 3 tbl's I've read and understand, whish I'm
chuffed about. If I get to the next part and stumble I may have to give you
another shout!

Once again thanks a lot

Angie

 

[Keith Wilby]

I'm really new to this and, although Access looks impressive it also looks
daunting. I am looking to build a reaaly simple stock control program. It
only needs to show the following.

Product List
Product In with quantity
Product Out with quantity
History of Movement

Is access best for this or is there already a program out there which is
at
a reasonable cost.

The sample Northwind.mdb that ships with Access should give you some
pointers.

Keith.
www.keithwilby.com