|
GETTING STARTED
|
 top
|
Provides an introduction to the FOCUS environment and its features and terminology.
TOPICS
COVERED
General Concepts
File Structures
Master File Descriptions
Facilities for End Users
More Facilities for End Users
Application Developer Facilities
|
WORKING WITH FOCUS
|
top
|
Shows users how to work in FOCUS using TED.
TOPICS
COVERED
General TED Concepts
TED Commands
Terminal Operator Environment
Types of Windows
WINDOW Commands
|
BASIC REPORT PREPARATION |
top
|
For anyone who is interested in learning about basic report preparation using FOCUS.
TOPICS
COVERED
Course Conventions and Databases
Starting a Simple Report
Printing Values
Creating Report Requests
Record Selection
|
CREATING SIMPLE REPORTS |
top
|
Shows users how to use FOCUS to create simple reports.
TOPICS
COVERED
Course Conventions and Databases
Line and Page Formatting
Headings and Footings
Techniques for Formatting Reports
FOCUS Hot Screen
Using the Hot Screen
|
CREATING COMPLEX REPORTS |
top
|
Shows users how to use various techniques to create sophisticated reports with FOCUS.
TOPICS
COVERED
Course Conventions and Databases
Advanced Sorting Techniques
Creating Matrix Reports
Additional Formatting Options
Ranking Data
Subtotaling Operations
The WHEN Clause
|
ADDITIONAL REPORTING TECHNIQUES |
top
|
Explains what you need to know in order to perform additional reporting techniques.
TOPICS
COVERED
Course Conventions and Databases
The JOIN Command
The MATCH Command
HOLD and PCHOLD Files
SAVE and SAVB Files
Retrieving Data
|
FUNDAMENTALS OF GRAPHS |
top
|
Provides an introduction to graphing concepts and techniques used in FOCUS.
TOPICS
COVERED
Conventions and Graph Types
Graph Requirements
Setting Graph Parameters
Bar Charts
Bar Chart Parameters
Histograms
|
ADVANCED GRAPH TOPICS |
top
|
Explains how to create and format graphs for presentation on various types of platforms.
TOPICS
COVERED
Conventions and Graph Types
Connected Point Plots
Scatter Diagrams
Adjusting Graphs
Display Options
|
DATA MANIPULATION FOR REPORTING |
top
|
Explains how to create and format graphs for presentation on various types of platforms.
TOPICS
COVERED
Course Conventions and Databases
Expressions
Prefix Operators
The COMPUTE Command
The DEFINE Command
Comparing COMPARE and DEFINE
|
ADVANCED SCREENING TECHNIQUES |
top
|
Explains how to create and format graphs for presentation on various types of platforms.
TOPICS
COVERED
Course Conventions and Databases
DECODE and EDIT
INCLUDES and EXCLUDES
Screening on Masked Fields
Screening Accumulated Data
Additional Screening Procedures
|
CREATING FILE DEFINITIONS |
top
|
Explains how to create and format graphs for presentation on various types of platforms.
TOPICS
COVERED
Course Conventions and Databases
Describing the File
Describing Segments
Field Declaration
|
ADJUSTING FILE DEFINITIONS |
top
|
Shows users how to adjust file definitions in FOCUS.
TOPICS
COVERED
Course Conventions and Databases
Field Attributes
Editing Options
Additional Ways to Describe Fields
Creating an MFD
|
ACCESSING EXTERNAL FILES |
top
|
Shows users how to describe external files to FOCUS.
TOPICS
COVERED
Defining External Files
Fixed Format Files
Variable Segment Files
Other DBMS Files
Optional Interfaces
|
BASIC MODIFY REQUESTS |
top
|
Provides an overview of the basic MODIFY requests in FOCUS.
TOPICS
COVERED
What is MODIFY?
Entering a Basic MODIFY Request
Reading and Describing Data
FREEFORM
PROMPT and CRTFORM
|
SEGMENT MODIFICATION |
top
|
Provides further instruction in maintaining and understanding files and databases in FOCUS.
TOPICS
COVERED
The MATCH Statement
Root Segments
Updating Segment Instances
Deleting Segment Instances
Modifying Unique Segments
Modifying Descendent Segments
|
COMPLEX MODIFY REQUESTS |
top
|
Provides an overview of the use of FOCUS and how to use it to perform complex MODIFY Requests.
TOPICS
COVERED
Course Conventions
Course Databases
The COMPUTE Statement
The VALIDATE Statement
|
ADDITIONAL FILE MAINTENANCE |
top
|
Provides further instruction in maintaining and understanding files and databases in FOCUS.
TOPICS
COVERED
Course Databases
Messages
The LOG Statement
Case Logic
Branching
Designing a Sample Application
|
DIALOGUE MANAGER AND FIDEL |
top
|
Provides an advanced look at the Dialogue Manager and FIDEL features found in FOCUS.
TOPICS
COVERED
Course Conventions and Databases
Dialogue Manager
Control Statements
FIDEL
PF Keys
Cursor Control
|
MORE FEATURES OF FIDEL |
top
|
Provides an overview of the additional features of FIDEL and how FIDEL is used with MODIFY and Dialogue Manager.
TOPICS
COVERED
Course Conventions and Databases
FIDEL in MODIFY
Additional FIDEL Features
FIDEL and CRTFORMs
FIDEL in Dialogue Manager
|
MAINTAIN FACILITY |
top
|
Explains how to use the FOCUS MAINTAIN facility to maintain FOCUS files.
TOPICS
COVERED
Course Overview
Basic MAINTAIN Procedures
Developing Screens
The Winform Properties Dialog Box
The Create Field Dialog Box
Creating Buttons
|
CREATING A MAINTAIN APPLICATION |
top
|
Teaches users how to build cases, create a grid, and use other commands to complete an application in MAINTAIN.
TOPICS
COVERED
Course Overview
Developing Cases
Case Codes
Using a Grid
Additional Commands
only £50.00
(approx $90 USD)
|
