Overview, Program requirements, Using microsoft access with dms inventory – IntelliTrack Inventory Management User Manual

Page 28

Advertising
background image

I

NTELLI

T

RACK

I

NVENTORY

V

8.1

User Manual

2

Overview

The IntelliTrack DMS Inventory software is designed to be used with por-
table bar code readers to provide a complete turnkey solution to manage
your inventory.

Note: Portable data terminals are not included with the Inventory soft-
ware and must be purchased separately.

IntelliTrack DMS Inventory functions handle everything from routine
physical inventories to perpetual inventory management. The IntelliTrack
Inventory portable software enables the portable bar code reader to collect
inventory data automatically; including the collection and storage of user
ID, inventory, locations, and quantities, all with the accuracy, speed, and
simplicity of bar codes.

IntelliTrack DMS Inventory software includes a ready to run, PC compati-
ble SQL database to manage all of your inventory data, in addition, the
software includes standard reports, queries, and bar code label printing
capabilities. By using SQL Express or SQL, your application supports a
large, centralized database.

IntelliTrack offers a lite version of its DMS Inventory v8.1 SQL applica-
tion. The lite version limits your item count to 100.

Program
Requirements

Please be aware of the latest hardware requirements. Your system should,
at a minimum, meet these requirements. Please visit our website (

www.int-

ellitrack.net

), or refer to your Quick Start Guide for a listing of the latest

application requirements.

Using
Microsoft
Access with
DMS
Inventory

DMS Inventory v8.1 includes Microsoft® Access runtime files, hence, a
full version of Microsoft Access is not required to use the Inventory appli-
cation. All the features are available, including the use of all forms,
reports, data entry screens, and picture icons. However, you cannot create
custom reports and queries without a full copy of Microsoft Access.

With a full version of Microsoft Access installed on the computer, you are
able to open the application through Microsoft Access; use the full Access
ribbon to perform quick sorts and filters on many forms and queries, and to
reach all forms, reports, queries, macros and tables that are part of the Int-
elliTrack
system; perform custom imports and exports; and easily design

2287.book Page 2 Thursday, July 7, 2011 4:45 PM

Advertising