parts inventory management
 

I need to be able to keep up with parts on my husbands truck..(or he does).
I have already taken care of entering parts numbers, parts discription, &
notes. I need to have a column for parts on hand, that will update
automatically when numbers are entered in the columns for parts in and parts
out. I have the information entered into both Access and Excel. I've
contacted people I use to work with who did training on both Access and Excel
and they can't help me. I know there has to be a way to do this without each
part having it's own ledger sheet. Please HELP