I am looking to test Barcode scanning applications and asset recording. Can anyone recommend a good "free" or trial application / software that I can use to test the viability of such systems?
Or have a script that can run in Excel to scan barcode to predetermined columns.
Eg: Using predefined barcodes.
1st barcode - Scan barcode to determine object type
2nd barcode- Scan to determine column to populate
3rd barcode- Scan to enter the barcode information
In doing that, you can type on the keyboard or scan a bar code whenever the PC is waiting for input, be it in Excel or whatever. Of course there are more sophisticated setups (ie. wireless, scans stored in a gun, etc) if you need those.
As far as the scans you outlined, typically the way it works is that each asset is given a unique number. You scan one bar code and then have all the information on it.
In terms of the app, there is a lot more to fixed assets then just the tracking and it depends on what your looking for. One of the better known ones is Sage Fixed Assets Accounting:
I don't believe they have a free trial, but there's plenty of info there to show you what I'm talking about.
But given what I said about the scanning, I'd focus on what you want the app to do for you. The scanning really is just an add on.