I am trying to creat a small business inventory using ms office. I cannot seem to find a template for what I want to keep track of. Can someone help me find something similar to this that I can modify to fit my needs? I want it to keep an item count like the auto number feature Place to insert the item description, Auto insert the date when purchased or some way to insert the current date without having to type it out. A place to insert the purchased item/s cost, A place to insert the sold price per item/s A place to insert the date sold " auto date insert feature" A place to inter the location where sold, and if possible a link to a pic of the item on my hard drive "not totaly necessary but would help with item description" I would like it to automatically add up the running total for unit's cost and another one for unit's sold so I can show a profit if any. I want to be able to print out hard copies in spreadsheet form too. Most templates in office have either too much stuff to enter but not everything I want, or not enough and won't let me change or add features. I don't know whether I need a Database or spreadheet for this but I keep thinkin both!! I need the database to keep track but spreadsheet to print up the inventory. Can someone help me find a template for this or at least give me some pointers on how to set this up and what I need to look for. Thanks Chad

Ur describing MS Access... but it can be done with Excel too. It depends on ur preference on both . Access is the best way to have a "simple to use product". But u need to know a little about it to put it in place .With Excel it's very simple to make : a simple line with titles, some fields easy to calculate with formula, u select all, u name it and have a pretty nice pivot table (in a second sheet)to have ur screenshot edition. U can customize ur "enterin formular".So, really,it depends on u...!

If you have Office with Access look at the sample database "Northwind", which has an inventort example.

I don't seem to have Northwind. Is there anywere besided http://office.microsoft.com/templates/category.aspx?CategoryID=CT061995421033&CTT=4&Origin=CT061993481033 where I may find more templates? Like somewhere people submit and trade them? Or possibly some place where I could give them the info on what I want and they make me a template for $ ?