inventory using Microsoft Access

["Lin Light" <holight at llcoop dot org>]

I've started playing with Create Lists exported into Access as a means doing
an inventory.  This is how I think it can work and if anyone has tried this
or can see any flaws let me know.
1) Create a list based on a location code [Adult Fiction = hoa]
2) Sort by call number [af Abc throught af ZZZ]
	Sort to be able to reduce the size of each report so you can run a number
of reports/queries to keep up to date
3) Export into Excel to limit or segment the report/database
4) Open Access and import spreadsheet
5) Make sure structure is as you want it and column names make sense
6) Create a Table that will be used to store the barcode numbers that will
be scanned in for items on shelf
7) Create a form so you can just scan in the barcodes of the items on shelf
8) Take laptop with WIFI or stand- alone Access to the stacks and start
scanning
9) Scan only what you can run a report on before staff starts reshelving
10) Run a query that looks for duplcate barcodes
11) Those items that aren't matched up with a scanned in barcode will appear
as a result of the query
12) Store for later rechecking
	Export Due Date and Status to give an idea as to why the item isn't on the
shelf.

Issues!
	If your library experiences a high circ count it would be good to run the
report just before you take to the shelves
	Any shifting of new items into the collection should be noted or ceased
during work on this area

I know this is very basic, but I thought if I throw it out now, before
spending a lot of time working out details, that maybe someone else  may see
something that would be helpful.

Lin


Lin Light
Head of Technical & Automated Services
Herrick District Library
Holland, Michigan
616.355.3727 Voice
616.355.1426 Fax
llight at herrickdl dot org