Duration:
Day 1: 1:00 p.m. to 5:00 p.m.
Day 2: 8:00 a.m. to 12:00 p.m.

Location: WorkWise Offices - Learning Center, Milwaukee, WI

Course Description
This class is designed for those who need to understand the process of extracting data from TCM and presenting this data in a report

This class is designed to be a one day session with approximately 1½ hours of lecture/demos and the remainder devoted to a hands-on workshop creating reports that will be assigned by the instructor.

You should consider attending this class if you need:

• to create a Crystal Report of TCM data
• to create a query in Excel
• to gain a better understanding of the TCM Database Infrastructure
• to view and print File/Structure record layouts
• to learn how to establish file/table joins and table relationships
• to become familiar with how ODBC works
• to learn to use the Field Locator tool

With improvements in the Synergy ODBC and the latest Synergy Version 7.5.1f the ability to extract and manipulate TCM data has been significantly enhanced. With this new capability has come the dilemma of how to use this new capability in report writer tools such as Crystal Reports, Microsoft Access and Excel.

WorkWise is pleased to offer this workshop to enable you to understand the process of extracting data from TCM and creating a report from it.

Agenda

• Introduction
• Objectives of the Course
• Overview of ODBC
• Organizing the TCM Database
• Files, Records, Structures, Fields
• Commonly used Structures in TCM
• Printing Record Layouts of TCM Structures
• TCM Application Flow Charts - AP, AR, COP, DC, GL, IM , MS , MRP, PO , SFC
• TCM Field Locator Tool
• Table Joins and Relationships
• Concepts of Relationships - Demo in Crystal Reports
• Report writing using TCM Database
• Crystal Reports - Create various reports using Crystal Reports as the Tool
• Microsoft Excel - demo report using Excel Query wizard
• Hands on workshop using Crystal Reports and Excel

This outline of topics for discussion is NOT meant to be a “defined” agenda, but rather an outline of topics, which may be discussed either in depth or briefly, depending on the class experience and capabilities. Other topics may be introduced and included as required by the class participants.

Cost:  $450.00 Per Person . Maintenance Plan customers only: $405.00 for each additional attendee

$800.00 Per Person for COMBINED:   Care & Feeding  and Data Mining class. Maintenance Plan customers only: $720.00 for each additional attendee. (Price for both classes taken separately is $1125)

Click here if you’re interested in attending the COMBINED:  TCM Care & Feeding and TCM Data Mining classe!

Registration