focus tutorial, online focus training

focus tutorial

FOCUS Tutorial
Info and Order

FOCUS Tutorial Courses

distance learning

The self-paced focus tutorial is exceptional. Online focus tutorial with award winning content and engaging instructions. Courses meet or exceed certification exam objectives, teaching precisely what you need to know.

FOCUS
A+ Certification
Microsoft Certification Tutorial
MCSE Certification
MOUS Certification
A+ Training
Exchange Server
IIS4 Training
SQL Server
TCP/IP Training
Windows NT
Windows 2000
Windows 2000 Server
Access 2000
Excel 2000
Excel 2000 Expert
Word 2000
Word 2000 Expert
PowerPoint
Office 2000
Office 97
Cisco CCNA
Cisco CCDA
Oracle 8i
E-Commerce
Novell CNE
Lotus Notes
Visual Basic
FrontPage Tutorial
Java
HTML
Visual InterDev
PowerBuilder
UNIX
Sybase
PhotoShop
S.A.S.
QuickBooks
MS Works
Estate Planning
Interview Skils
Investing
Resumess Writing
Home Business
Management Training

Click Here

This focus courses are for data processing and business professionals who will be using FOCUS.

After completing this course, the student should be able to:

  • Explain what FOCUS is
  • Identify FOCUS concepts and terminology
  • Access FOCUS
  • Identify the parts of a Master File Description
  • Describe available FOCUS facilities
  • Use the optional FOCUS text editor, TED
  • Use a multi-window environment with TOE
  • Create simple reports using FOCUS verbs and basic sorting techniques
  • Specify record selection criteria
  • Customize report requests with
  • Use FOCUS Hot Screen to view report output
  • Utilize ACROSS and other advanced techniques to sort data
  • Customize report output with additional formatting techniques, including ACROSS, subtotaling operations and WHEN conditions
  • Use the JOIN and MATCH commands to report from more than one file at a time
  • Save report output using the HOLD, PCHOLD, SAVE and SAVB options
  • Utilize alternate file views and TABLEF to change the way FOCUS retrieves data
  • Use the GRAPH request to specify bar charts, histograms, connected point plots or scatter diagrams
  • Describe parameters that specify graph type and the general appearance of the graph
  • Control the scaling of the horizontal and vertical axes
  • Define graphs with single or multiple variables
  • Describe alternate display devices
  • Add headings and footings to graphs
  • Use techniques to create graphs with special formats
  • Describe the different kinds of expressions
  • Use prefix operators to perform calculations on individual fields
  • Create new fields for reporting with COMPUTE and DEFINE commands
  • Manipulate the information in a file using the DECODE and EDIT functions
  • Perform advanced techniques for screening data
  • Describe external files with a Master File Description
  • Identify external file types
  • Explain external file interfaces
  • Define files
  • Identify the parts of a Master File Description (MFD)
  • Use the MFD to specify information about the structure of the file
  • Explain the rules for formatting the file, segment and field declarations
  • Discuss how the MFD and data files are named and stored based on the operating system
  • Discuss the TITLE, DESCRIPTION and ACCEPT attributes
  • Create temporary fields in an MFD
  • Discuss a sample application of an MFD
  • Describe the CHECK command
  • Explain how MODIFY requests are used for database maintenance
  • Identify what happens after a MODIFY request is executed
  • Use the FIXFORM, FREEFORM, PROMPT and CRTFORM statements to read and describe the transactions
  • Write MODIFY requests that add, update and delete information in the root segment of files
  • Code MODIFY requests that modify unique segments and multilevel descendent segments
  • Use MODIFY requests for
  • Performing calculations
  • Validating transaction values
  • Displaying messages
  • Logging transactions
  • Construct a complex MODIFY request using case logic
  • Employ Dialogue Manager statements to control the execution of FOCEXECs
  • Use Dialogue Manager to include variables in FOCEXECs and assign values to these variables when the FOCEXEC is executed
  • Invoke FIDEL and create full-screen data entry forms or forms for displaying data
  • Design FIDEL screens that include multiple field types
  • Test for PF keys
  • Use a variety of screen options
  • Display screen attributes
  • Control the cursor placement
  • Use FIDEL in MODIFY to combine FIXFORM & CRTFORM input
  • Generate automatic CRTFORMs
  • Write multiple screen procedures
  • Write requests with case logicOBJ@include repeating groups of fields
  • Validate transaction values
  • Use FIDEL with Dialogue Manager to develop a menu-driven application using multiple FOCEXECS
  • Explain how MAINTAIN is used for database maintenance
  • Identify MAINTAIN language standards and concepts
  • Develop a fully functional MAINTAIN procedure that performs maintenance functions for a database
  • Modify 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

All courses are included in "Tech General Pack"