Overview, Full access import, Overview full access import – IntelliTrack Stockroom Inventory User Manual

Page 342: E refer to, Full access import” on, Full access, Overview 314, Full access import 314

Advertising
background image

I

NTELLI

T

RACK

S

TOCKROOM

V

7.0

User Manual

314

Overview

Microsoft Access is a powerful and flexible database management system.
A full version of Access allows you to modify existing database objects,
create new forms, reports, and interface directly with other database sys-
tems.

Note: This chapter assumes that you have a full version of MS Access
installed on your computer. If you do not, this chapter does not apply.

It also assumes that you have experience importing data using Access
Tools; if you do not, you should review importing in the Microsoft Access
documentation.

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 a Stockroom database without redefining
detailed item information manually, including the site, location, and quan-
tities on hand.

To maintain data integrity, existing inventory must be imported into the
Stockroom 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 303

. Before importing data, review the data structures of the four

tables listed above in

Data Structure on page 303

. If the import data does

not match the order and defined criteria, modify the export tables or build a
custom Access query to place the information in the appropriate Intelli-
Track
table and fields.

2289.book Page 314 Thursday, July 9, 2009 2:35 PM

Advertising