MS Access SQL – barcode scan able “it would be used for IT asset tracking”. 
The following fields would need to be captured:
1.      Asset ID
2.      Description
3.      Tag Number
4.      Serial ID
5.      PO No.
6.      Custodian
7.      Location
8.      Model
The primary key for the database will be the Tag Number.  Secondary key or relationship would be the Location. 
The goal is to scan each location, tag numbers, and update the database to set a baseline location for each piece of inventory. 
Scanned information will have the following format in an excel spreadsheet:
1.      Location
2.      Tag Number
3.      Tag Number
4.      …..
5.      Location
6.      …..