[AccessD] Inventory Tracking

Does anyone have anything that would help me set up a new database for
tracking inventory? I can't seem to get it in my head how to set it up.
It should be simple, but adding to the inventory & taking out of
inventory - I am having problems with setting up the tables. This is my
first inventory tracking system.

 

There are only 3 storage locations where the inventory is kept & only 5
types of items stored. But adding and removing items, then keeping track
of the minimum inventory and the actual inventory I don't know the best
way to set up the tables.

 

I know I need a location table & a type of inventory table, but how do I
list the same items for each of the 3 locations in a table? If they add
to the inventory at a certain location on a certain date, it should add
to the actual inventory for that item and location.

 

Hope someone can help on this....

 

Virginia