focus online training course

Receive your login ID to take the training courses online, as many times as you wish, for 1 year. Click here for group orders.

Buy this entire online training course with one easy payment of $67

Benefits

Unlimited access for 1 year
Learn anytime, anywhere
You control the pace
Start & stop wherever you want
No books to read
No software needed
Value Packs include Free online tech support
Double guarantee

100% Money back guarantee
One time payment No monthly fee
Use the course index for review anytime
Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
Free status reports for company managers

Requirements

All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer. Prices shown are per user.

What You will Learn

This online training course is designed for both FOCUS end users and application developers. It covers basic FOCUS concepts and terminology, its file structure, and the Master File Description. It details application developer facilities, and covers using FOCUS with TED, creating reports, graphs, and file definitions, and looks at data manipulation and screening techniques. Additional topics include accessing file definitions, using MODIFY requests, and the Dialogue Manager, FIDEL, and MAINTAIN facilities.

Getting Started

Recognize basic FOCUS concepts and terminology
Define the FOCUS file structure

Use the Master File Description
Create reports and use facilities
Use Application Developer facilities

Working with FOCUS

Recognize the general concepts of TED
Add and delete material in TED
Explain introductory material concerning the Terminal Operator Environment

Move and copy in TED
Describe the functions of the seven windows in TED
Operate WINDOW commands in TED

Basic Report Preparation

Describe the various course conventions
Identify the screens used by the various course databases
Use the TABLE command to initiate report requests
Use the PRINT and LIST verbs to print the field values in report requests
Explain the various uses of the WHERE clause

Use the SUM, ADD, WRITE, and COUNT Verbs in report requests
Describe the basic sorting process of data
Explain the various printing techniques used for creating reports
Use the IF statement and WHERE clause to screen records

Creating Simple Reports

Create subheadings and subfootings
Use the Hot Screen option in FOCUS
Explain line and page options in FOCUS
Create headings and footings in FOCUS
Use advanced methods to scroll

Use search and locate to find repeat forms
Save reports in FOCUS
Understand course conventions
Create course databases

Creating Complex Reports

Use the rules for coding statements in FOCUS graph requests
Describe how to use advanced sorting techniques when creating reports

Create headings and footings, including positioning text
Rank and summarize numeric data
Create totals in your reports and print them

Additional Reporting Techniques

Identify Alternate File Views and TableF
Explain the method of attaching files
Distinguish betweeen the Match vs Join commands

Describe the method for saving report output
Distinguish between the Hold vs Save commands

Fundamentals of Graphs

Understand FOCUS command syntax and the types of graphs you can create
Use graphing verbs and sort clauses to create graphs
Set parameters to affect the appearance and function of graphs

Create bar charts, using parameters that affect the appearance and control the horizontal axis
Create multiple bar charts
Create single variable histograms and multiple variable histograms

Advanced Graph Topics

Recognize FOCUS graph types
Control the format of graphs
Specify the parameters of graphs
Control the format of scatter diagrams

Specify the parameters of scatter diagrams
Using tuning techniques to adjust graphs
Apply special formats to graphs
Display graphs on alternate devices

Data Manipulation for Reporting

Use expressions
Use prefix operators
Create new fields
Use the DEFINE command

Specify the parameters of scatter diagrams
Explain the differences between COMPUTE and DEFINE

Advanced Screening Techniques

Use the DECODE function to make reports easy to read
Apply the EDIT function to manipulate fields
Use INCLUDES and EXCLUDES for character string screening
Use masks to retrieve specific information

Use sum of value tests with statements to determine the amount and type of information screened
Use compound logic to retrieve specific information
Store lists of screening values as text files

Creating File Definitions

Discuss file declarations
Discuss the FORMAT attribute
Explain how to specify field length
Define Master File Descriptions and their purposes
Explain the three types of declarations that make up an MFD

List rules for coding MFDs
Discuss rules for coding FOCUS commands
Define segment declaration
Explain the SEGNAME attribute
Discuss the PARENT attribute
Identify the SEGTYPE attribute

Adjusting File Definitions

Distinguish between the various segments used to track information in a database
Create special temporary fields in your files and know how to name a file, including the suffix attribute

Identify the various types of FORMAT values
Assign TITLE, DESCRIPTION, ACCEPT and other attributes
Use the CHECK command

Accessing External Files

Create a Master File Description for general categories of external files
Describe the structure of simple sequential files and multiple record type files
Distinguish between the MFDs for ISAM and VSAM interfaces

Code FOCUS MFD for the DB2 and SQL/DS interfaces
Code Access File Description to access SQL tables from FOCUS

Basic MODIFY Requests

Add, update and delete information in a database using the MODIFY process
Enter a MODIFY request and explain the results

Create a FIXFORM statement to read transaction data stored on a file
Create the PROMPT statement to read transaction data

Segment Modification

Test values
Recognize and understand three course databases
Test incoming transaction values
Test for existing incoming values
Compare incoming transaction values

Understand computations and the COMPUTE statement
Change incoming transaction values
Compute new values
Define incoming data fields
Understand course conventions in FOCUS

Complex MODIFY Requests

Understand course conventions in FOCUS
Recognize and understand three course databases
Compute new values

Define incoming data fields
Test incoming transaction values
Test for existing incoming values

Additional File Maintenance

Explain course databases
Code TYPE statements
Use a LOG statement
Use rejected transactions

Use the CASE statement
Manage branching with GOTO, PERFORM, and IF statements
Design an application

Dialogue Manager and FIDEL

Explain Dialogue Manager and FIDEL
Understand the two database systems that are used for examples and exercises

Use the Dialogue Manager to insert control statements in a FOCEXEC
Identify three types of fields on a FIDEL screen

More Features of FIDEL

Use automatic CRTFORMs for database maintenance
Use case logic in FIDEL

Read multiple occurrences of fields with a single CRTFORM
Create a menu driven application using Dialogue Manager

MAINTAIN Facility

Explain how MAINTAIN is used for database maintenance
Identify MAINTAIN language standards and concepts
Design a fully functional MAINTAIN procedure that performs maintenance functions for a database

Prepare a MAINTAIN procedure to include a grid so that multiple rows of data can be updated at once
Identify additional commands that are useful when developing MAINTAIN procedures

Completing a MAINTAIN Application

Understand the sample databases and conventions used in the course
Use the ADDPROD, CHGPROD, and DELPROD commands to develop Cases
Create a grid for your MAINTAIN application

Use FWDPROD, BWDPROD, ENDPROD, and TOP to manipulate Cases
Use additional commands to manipulate your MAINTAIN application

FOCUS Join over 1 million people who learn online, with these complete interactive computer training courses.

FOCUS
Join over 1 million people who learn online, with these complete interactive computer training courses.