IntelliTrack Inventory Management - Manual (Page 334)

I NTELLI T RACK I NVENTORY V 8.1
User Manual
308
Overview
Microsoft Access is a powerful and flexible database management system.
A full version of MS Access allows you to modify existing database
objects, create new forms, reports, and interface directly with other data-
base systems. Please note that IntelliTrack DMS v8.1 also supports MS
Access 2010, 32-bit version only. The examples in this section are based
on MS Access 2007.
Note: You must have a full version of MS Access installed on your com-
puter to use the full Microsoft Access features with IntelliTrack Inventory.
Full Access Import
With a full version of MS Access installed on your computer and familiar-
ity with importing data directly into Access tables, you can import any
existing inventory data into an Inventory database without redefining
detailed item information manually, including the site, location, and quan-
tities on hand.
Note: To use the full Microsoft Access importing tool, you should have
experience importing data using Access Tools; if you do not, you should
review importing in the Microsoft Access documentation.
To maintain data integrity, existing inventory must be imported into the
Inventory system in a specific order. The following tables are imported in
the order shown below:
1. Sites
2. Bin Location
3. Inventory
4. Inventory by Location
This appendix specifies field order and criteria for tables in Data Structure
on page 235 . Before importing data, review the data structures of the four
tables listed above in Data Structure on page 235 . If the import data does
not match the order and defined criteria, modify the export tables or build a
2287.book Page 308 Thursday, July 7, 2011 4:45 PM