Overview, Full access import, Full access – IntelliTrack Inventory Management User Manual

Page 334: Full

Advertising
background image

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

Advertising