IntelliTrack Check In/Out - Manual (Page 17)

Table of Contents
xvii
Overview.................................................................................................................. 382
Compacting the Workstation Application File ........................................................ 382
APPENDIX C: Microsoft Access Integration .....................................383
Introduction.............................................................................................................. 384
Full Access Import................................................................................................... 384
Import Access Inventory Data ................................................................................. 385
Query Import Data – Site Table........................................................................ 387
Query Import Data – Bin Location Table ......................................................... 388
Query Import Data – Inventory Table .............................................................. 389
Query Import Data – TblCheck Table .............................................................. 390
Query Import Data – Inventory by Location Table .......................................... 391
Exporting Data......................................................................................................... 392
Custom Reports........................................................................................................ 392
Adding Reports................................................................................................. 392
Custom Queries ....................................................................................................... 393
Adding Queries................................................................................................. 394
APPENDIX D: Customizing IntelliTrack ..........................................395
Cautions when Customizing IntelliTrack ................................................................ 396
APPENDIX E: Bar Code Symbology .................................................399
Bar Code Symbology Characteristics ...................................................................... 400
APPENDIX F: Sample Reports ...........................................................401
Calibration and Maintenance Due Report ............................................................... 403
Check In/Out Inventory Details Report ................................................................... 404
Check In/Out Inventory Summary Report............................................................... 405
Past Due Item ID Report.......................................................................................... 406
Checked Out Items by Cust/Emp ID Report ........................................................... 407
Checked Out Items by Department Report.............................................................. 408
Checked Out Items by Order # Report .................................................................... 409
Cust/Emp ID Report ................................................................................................ 410
Cust/Emp ID Receipt by Order # Report..................................................................411
History by Date Report ............................................................................................ 412
History by Item # Report ......................................................................................... 413
2283.book Page xvii Thursday, July 9, 2009 11:26 AM