Whats the best way to create a basic stock control database?

chris_zulu asked: I need to make an inventory control database. Ideally, I would like to keep track of Stock quantity Stock description Stock location Say someone wants 4 mice, I would like to go to the database, find out where the mice are, and type in how many have been removed (4), and for the [...]