Training Course Descriptions

As your Authorized Technical Service Center we can assist you in your educational efforts for a number of different types of training workshops.

DataFlex Procedural
A three day basic/intermediate hands-on course for procedural DataFlex. Learn how to proficiently design and maintain applications along with reporting knowledge to extract data into a workable manner that would enhance any business.

FlexQL 2.0 Report Writer
This course is a one day hands-on training class on how to use the FlexQL report writer. Attendees will learn introductory and intermediate level reporting which will entail report design with various selection criteria along with file relationships and accessing other data structures.

Course Length: Five (5) Days
Course Level: Beginner-Intermediate

This course provides the student with a solid foundation in data structures and algorithms, enhancing the student’s ability to develop portable, efficient, and maintainable DataFlex programs. Course work and exercises are developed to build progressively upon programming tasks, culminating in a useful program example. Throughout the course, a toolbox approach to the activities will be emphasized, augmenting your personal programming repertoire. All examples follow a practical application design approach for creating, enhancing, or rewriting DataFlex programs.

    * Become more productive with DataFlex utilities
    * Learn fundamental data structures and algorithms
    * Acquire skills in use of DataFlex’s object-oriented language
    * Write maintainable and efficient DataFlex code
    * Develop an enhanced repertoire of programming tools
    * Learn how to program for re-use
    * Develop balanced programming techniques

 Introduction Programming (cont.)

Overview Using Autocreate
Assumed prerequisites and skills Database design & data sets
Project Design & Application Development File layout
Standards File relationships
Testing Data set construction
Tool Selection Connecting data sets
User interface design
Programming Using the DataFlex Documentation
Algorithms Evaluating third-party tools
Constructs
Commands Reporting
Procedures, Functions, and Expressions REPORT macro & DFQuery
Standard reporting
Object-oriented programming Subtotaling
Terminology Top-down reporting
Fundamentals Low-level reporting
Applying fundamentals REPORT object
Class-building
FlexQL
WinQL

Note: All training is scheduled for pre-payment

Cancellations are permitted up to 10 business days prior to the start date of the workshop. If a cancellation is made 5 to 10 business days prior to the start-up date, 50% of the course will be invoiced. If a cancellation is made 1 to 4 business days prior to the start-up date, 100% of the course will be invoiced. If attendance is rescheduled within 10 business days prior to the workshop it will be subject to a $ 75 administration fee.

Executive Tactics Corporation
Sales (800) 622-1080  Phone (614) 336-2150  Fax (614) 336-2152

          Training Course

Course Length: Five (5) Days
Course Level: Beginning/Intermediate

For this course attendees should have basic computer programming knowledge. Also a working knowledge of Windows operating systems is helpful.

This five day training course is designed to give you a jump start into the Windows environment using DataFlex. Attendees will learn how to use all of the new utilities along with modifying code inside and outside of the Application Builder. Will also learn how to setup Data Dictionaries and how to create a Windows Help system for their applications. After this course you will be able to develop true 32 byte applications for Windows 95 or NT using DataFlex.

* Learn about new utilities & how to use them.
* Modifying code inside & outside of AppBuilder.
* Utilizing the Data Dictionary.
* Adding Views & Selection Lists.
* Fonts and GUI Features.
* AppBuilder
* Application Wizard and View Wizard
* Data Dictionaries
* Windows Help System
* WinPrint
* DFSpy

Note: All training is scheduled for pre-payment

Cancellations are permitted up to 10 business days prior to the start date of the workshop. If a cancellation is made 5 to 10 business days prior to the start-up date, 50% of the course will be invoiced. If a cancellation is made 1 to 4 business days prior to the start-up date, 100% of the course will be invoiced. If attendance is rescheduled within 10 business days prior to the workshop it will be subject to a $ 75 administration fee.

Executive Tactics Corporation
Sales (800) 622-1080  Phone (614) 336-2150  Fax (614) 336-2152

          Course Outline

Introduction

Project Development Cycles

Sample Project Exercise

Fundamentals of Object Oriented Programming
        Encapsulation - Using the Black Boxes
        Inheritance - The real power behind Object Oriented Programming
        Polymorphism
        Binding Systems - The difference between late and early binding systems

Key Concepts of OOP
        Classes
        Properties
        Procedures
        Objects
        Messages
        Forwarding and Delegation
        Broadcasting
        Object Access Methods

Creating Classes and Objects
        Basic VDF Classes

Designing Databases

Data Entry Objects
        Data Entry Objects and Views
        Delegation and the importance of Container Objects
                The Desktop and what you can do with it
                The importance of the DBView container and the Activate_View Message
        Optimizing "Load" time
        The Confirm Packages
        "Key trapping" with VDF
        Status Help
        Navigation concepts with objects

Developing Applications

Creating a "Real World" Application
Windows 95 Registry and DataFlex Workspaces
        Creating new workspaces
        Modifying existing Workspaces
Implementing Business Rules in DataFlex Applications
        Using "Hook" Methods
                Procedure Creating
                Procedure Update and Backout
                Validation Functions - Item Validation with DD Validation
                How DataDictionaries communicate with other DataDictionaries
                Smart Data-file locking
                Propagation of DataDictionary Save and Deletes
                Foreign Fields - Where they come from and what they can do for your application
        Using the Database Builder
                What to do in the Database Builder and what NOT to do
Using the Application Builder
        Creating a Lookup List - how it interacts with the DataDictionary
        The DataDictionary Objects and what you can do with them
        Using the Alignment tools
        Video resolution problems and how to avoid them
        Tab pages and what they can do for your application
        Taking Application Builder to the max.
        How to add your new classes to AppBuilder
        Adding manual code segments in AppBuilder
                Where to add code and where not to
        Using Modal Panels
        Using "Constrained" Lookup List
        Using the View Wizard

 Additional Topics to be covered

DataFlex Base Classes
Creating New Functions and Procedurals
Using Windows95 Help / ForeHelp
Creating new Windows95 Help files
Deploying VDF Applications / Setup Factory
Reporting Techniques Using WinQL and WinPrint
Programming with Arrays
Year 2000 date problems
Adding Bitmaps and sound to your Applications
The VDF PowerBar and DBExplorer

Executive Tactics Corporation
Sales (800) 622-1080  Phone (614) 336-2150  Fax (614) 336-2152

          Report Writer Training

Course Length: Two (2) Days
Course Level: Beginner-Intermediate

Utilizing hands-on instruction, demonstration, lecture and group discussion, attendees will be introduced to Windows based report writing in the WinQL environment. Upon completion of the course, attendees will have gained general knowledge of report generating applications as pertaining to database, installation and configuration of WinQL from CORE Software, command and menu structure, planning a flexible report, integrating multiple databases, field manipulation, formula creation and problem solving, sorting and finally report generation including compiling to an executable for delayed or static reports.

        * Introduction to report writing in general, WinQL specifically
        * Demonstration of WinQL capabilities
        * Menu/Command structure, Dialog boxes
        * Formula Editor
        * Determining conventions and setting variables for report generation
        * Linking of multiple databases, key fields and indexes
        * Manipulating groups and sub-totals
        * How to read formulas
        * Modifiers
        * Give premise, create formulas to extract data
        * Using provided databases, create report with specific goals
        * Table discussion of formulas devised to achieve goals
        * Compile reports for use outside of WinQL environment
        * Manipulate a compiled report other than attendees own to extract specific data

Note: All training is scheduled for pre-payment.

Cancellations are permitted up to 10 business days prior to the start date of the workshop. If a cancellation is made 5 to 10 business days prior to the start-up date, 50% of the course will be invoiced. If a cancellation is made 1 to 4 business days prior to the start-up date, 100% of the course will be invoiced. If attendance is rescheduled within 10 business days prior to the workshop it will be subject to a $ 75 administration fee.

Please call for expanded course outlines
(800) 622-1080

Payment: All courses must have prepayment to reserve a seat. You may pay by check; however a credit card number must be given to hold your seat until your check arrives. Please note if your check does not arrive by time of training your card will be charged.

For more information please contact:

Executive Tactics Corporation
PO Box 1146
Columbus, OH 43065
Sales (800) 622-1080  Phone (614) 336-2150  Fax (614) 336-2152

E-mail us at etc@link2link.com

Copyright © 1997 Executive Tactics Corporation
Last revised: February 07, 2003