Duration classroom training:

Day 1: 8:30 a.m. to 5:00 p.m. - TCM Windows Care & Feeding: Part 1
Day 2: 8:00 a.m. to 12:00 p.m. - TCM Windows Care & Feeding: Conclusion

Day 2: 1:00 p.m. to 5:00 p.m. - TCM Data Mining Workshop: Part 1
Day 3: 8:00 a.m. to 12:00 p.m. - TCM Data Mining Workshop: Conclusion

Location: WorkWise Offices - Learning Center, Milwaukee, WI

TCM Windows Care & Feeding Course Description

Some dates of the TCM Windows Care and Feeding course are designed specifically for users running version 8.0 of TCM. These dates are noted.

The how-to’s of TCM running in a Microsoft Windows Environment

This course will help you understand the workings of Microsoft Windows and TCM operating system related functions. You should consider attending this class if you want to:

• Understand the structure of the TCM installation, folders, usage, data areas
• Install / debug TCM client installations
• Customize menus for individuals and/or groups
• Develop a disaster plan for TCM servers and recover from minor annoyances to catastrophic failures
• Better understand common Windows/Networking terms and definitions required by TCM
• Install ODBC and use basic debugging techniques
• Understand the differences between remote access methods and which are better for your facility
• Set up printers in a TCM environment
• Use various products, utilities and file transfer methods
• Review TCM data file operations like copying/deleting company data
• Learn about general MS Windows issues

TCM Data Mining Workshop 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: $800.00 Per Person. (Total cost if classes taken separately $1,125)

Additional Attendee $800 Per Person - Maintenance Plan Participants only $720.00 for each additional attendee.

TCM Windows Care & Feeding ONLY : $675.00 Per Person.

Maintenance Plan customers only: $607.50 for each additional attendees

Click here if you are only interested in the TCM Windows Care & Feeding class

TCM Data Mining WorkShop ONLY: $450.00 Per Person.

Maintenance Plan customers only: $405.00 for each additional attendees

Click here if you are only interested in attending the TCM Data Mining class

Printable map and directions to WorkWise with hotel information »

Note: WorkWise requires a minimum of four paying attendees to hold the week of classes. WorkWise reserves the right to cancel a class if attendance is below this minimum. WorkWise will determine whether a class has the minimum required attendance two weeks prior to the start date of the classes. In the event that a class is cancelled, paid attendees will have their registrations refunded.

Registration