It is very easy to use a USB scanner to do inventory. Just buy a USB scanner, plug it into your computer (the drivers and software will automatically install). Then just open excel and scan away. The bar codes you scan will be put directly into the excel field.
We purchased a Zebex Long Range Bar Code Handheld Scanner for $104.06. It works really well. The FAMIS # is 05024454X. It is a must for maintaining inventory.
If you have an new model of the iPod touch, or an iPad, I have been using an amazing app combined with the built-in camera to do my inventory. The app is called Inventory Scanner and it's free from the App Store. You can use it with most barcodes one products already, or, do what I have been doing which is printing my own barcodes and using them. Really liking how easy it is.
We used Destiny through E Follet. This can work for assets as well as books. I would look into this possibility, however there are some large costs associated with it. What you can also do is buy a USB scanner and just use Access or Google Spreadsheets.
Hope that helps.