help inventory db

[mesersmith]

i wanna make a inventory data base, but i really don't know how.
i make one table named product, with id_product and product name.
then i make a table named inputs, and another one named otputs.


my problems is that i don't know how to make the queries.
can anybody help me with some ideea?
or maybe an example will be better.
thanks

[orange]

Why don't you look for M$oft's Inventory template database.

This is a database that has tables, queries, forms etc and may save you a lot of time.

There is an available data model , and several others , here
http://www.databaseanswers.org/data_...cing/index.htm

[Access_Blaster]

Data models can help you picture the layout.

69.Inventory Control
http://www.databaseanswers.org/data_models/index.htm

[orange]

There is a lot of good info here
http://www.accessmvp.com/strive4peace/