Intellitrack Inventory Management Manual do Utilizador descarregar pdf (Página 334)

INTELLITRACK INVENTORY V8.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

1 2 ... 329 330 331 332 333 334 335 336 337 338 339 ... 365 366

Sem comentários

Intellitrack Inventory Management Manual do Utilizador Página 334