FOCUS Training Tutorials

Course List
Specials
Site Map
Free Training Tutorials





Computer Training Courses Catalog
(PDF Format)

You will receive Unlimited Access to all of the FOCUS tutorials listed below. Your online training courses will be available from anywhere you have internet access.

Summary:

This series 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.

This e-learning computer training series includes all of the online training tutorials listed below and is provided in an interactive e-learning format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit .

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisifed online learning customers in over 40 countries.

Certification: None

Includes:

FOCUS 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

• 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

• Discuss file declarations
• 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
• Discuss the FORMAT attribute
• Explain how to specify field length

• 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

• 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

• 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

• Test values
• 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
• Recognize and understand three course databases

• 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

• 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

• 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

• 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

• Recognize the general concepts of TED
• Add and delete material in TED
• Move and copy in TED
• Explain introductory material concerning the Terminal Operator Environment
• Describe the functions of the seven windows in TED
• Operate WINDOW commands in TED

• 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

• Understand the sample databases and conventions used in the course
• Use the ADDPROD, CHGPROD, and DELPROD commands to develop Cases
• Use FWDPROD, BWDPROD, ENDPROD, and TOP to manipulate Cases
• Create a grid for your MAINTAIN application
• Use additional commands to manipulate your MAINTAIN application

• 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
• 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
• Explain the various uses of the WHERE clause

• 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

• 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

• 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

• 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

• 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

• 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

Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit CEU credit.


Questions about FOCUS? We now offer 24x7 online support with access to real live experts! Get answers from real experts within minutes via our online chat service. For just $40.00 additional you add our Instant Mentoring service and get your FOCUS questions quickly answered anytime from anywhere.

FOCUS... ... $59.95
FOCUS + 1 Year Instant Mentoring... ... $99.95

You might also be interested in our Technical Package which includes all of the FOCUS training courses listed above plus over 1056 hours of additional courses.

About Us News Contact Us Features Certification

Reviews:

"this is a must have resource"
TheTechMag.com

"this is the Ultimate Career Development Package."
MidWest Technology Journal

Great Service and Excellent Training Product - Great People
Kenosha, WI

Excellent program, this is a real winner. Thanks. A+
Arlington, TX

Read more customer reviews about our e-learning training tutorials.