Hi Christy,
Good question. I've been looking at this myself and trying to link the
inventory template with the Time and materials template myself.
If you google this, here is a response from
http://en.allexperts.com in
2004. I think it still applies.
Joe from Waterloo
_________________
Date: 7/20/2004
Subject: Stock control - using Access
Question
I Can't find inventory template on Microsft site (none available to my
area). And can you tell me what you mean by: An inventory app centers around
a transactions table.
Thanks Margaret
-------------------------
Followup To
Question -
My son is starting up his own shop, and wants to be able to type in the name
of a product for sale and to see on screen how many are in stock ie, (control
software). He can't afford to buy a software package. I can do forms and
reports in Access but I want to know if it is possible for me to put a basic
package myself for his use? Is this possible? Hope you can help?
Answer -
Yes is possible. In fact, you can start with an inventory template provided
by Microsoft (check the Downloads area at microsoft.com).
An inventory app centers around a transactions table. The structure of that
table would include:
TransactionID (Primary Key (PK) Autonumber)
ProductID (Foreign Key (FK))
QtyOrdered
QtyReceived
QtySold
You would then have tables for Orders, Sales and Products that would relate
to this table. Everytime Product is receivd or sold its entered as a
transaction. To find out qantity in stock you just add the recevied amounts
and subtract the sold amounts.
Hope this helps,
Scott<>
