Ok, I've been tearing my hair out over this one. Then again, I can't program my way out of a wet paper bag.

Using access, I need to develop a database that will track inventory,purchase orders and work orders. When filling out a workorder, the entries have to deduct from the total inventory on hand.

Do the orders have to be setup in excel? how would one go about this? Is there a website that can point me in the right direction? Or am I better off investing in specialty sw?

This is for a small business, so I'd rather not shell out the big bucks for it.

Any help would be appreciated