Customizing queries, reports, and labels, Customizing queries – IntelliTrack Inventory Management User Manual

Page 104

Advertising
background image

I

NTELLI

T

RACK

I

NVENTORY

V

8.1

User Manual

78

Access. IntelliTrack DMS v8.1 supports Microsoft Access 2007 and 2010*
(*Microsoft Access 2010, 32-bit version only). Creating a custom label
requires a full version of NiceLabel software.

Customizing
Queries,
Reports, and
Labels

IntelliTrack allows a user to easily integrate customized queries and
reports that he/she has created with Microsoft Access into Inventory. For
example, if a user creates a customized report that is designed to meet the
company’s specific need, the user can add that report to the Inventory
report form so that it appears seamlessly integrated, as though the report
was originally shipped with IntelliTrack. Select Customize Command Set
from the Tools Command Tab to access the customization options.

Customizing
Queries

The application ships with pre-defined queries; these cannot be altered or
deleted. However, custom queries (forms) created in MS Access may be
added to the application at the Customize Queries form. Once added, the
query will appear as a query option in the Queries form. Use this form to
add custom queries (forms) to the application. (Please refer to your Access
documentation for more information on creating forms.)

Important: To add a new query, you must have a working knowledge of
Microsoft Access. For more information, please refer to

“Custom Queries”

on page 315

.

Select Tools > Customize > Queries option from the ribbon to create cus-
tom Query (Forms).

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

Advertising