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

	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

Course Conventions and Databases
Reviews rules for coding FOCUS statements.  Covers the conventions and databases used in the course.
 

	Course Conventions Rules for coding FOCUS statements.  Standards used when showing the format of FOCUS commands, simulating FOCUS sessions, entering TABLE requests and displaying output.  Four ways to create reports in FOCUS.
	Course Databases Master File Descriptions and diagrams.

Simple Reports  
Discusses how to begin and end a report request.  Describes the FOCUS verbs PRINT, LIST, SUM, ADD, WRITE and COUNT.  Covers sorting fields with BY.
 

	The TABLE Request How to use the TABLE command to begin report requests.  Report request terminations using END and RUN.

4th Generation Languages
 

	PRINT and LIST Three types of verbs.  Format of a verb phrase.  How to list fields from a file using the ?F command.  Report requests using PRINT and LIST.
	SUM, ADD, WRITE and COUNT Report requests using SUM, ADD, WRITE and COUNT verbs.
	Basic Sorting Ascending and descending sort sequence.  Sorting fields with BY and BY HIGHEST.
	Additional Printing Techniques Changing field formats for reports.  Accessing FOCUS HELP.  Report request terminations using the QUIT command.  Using the RETYPE, ONLINE and OFFLINE commands.

Record Selection
Presents the use of WHERE and IF conditions to select a subset of records for printing.  
 

	WHERE and IF Conditions Format of the IF statement and the WHERE clause.  Multiple WHERE or IF conditions.  Strengths of WHERE over IF.
	Uses of the WHERE Clause Value comparison and range checking relations.  Combined relations range testing.  Character string screening using CONTAINS and OMITS.

Customizing Reports
Covers how to create customized report formats with line and page formatting options, headings, footings, subheadings and subfootings.
 

	Line and Page Options Determination of when control breaks occur.  Use of the ON clause to specify line and page options including UNDER-LINE, SKIP-LINE, FOLD-LINE, PAGE-BREAK and REPAGE.  Controlling page numbering with three SET commands: SET PAGE = ON, OFF and NOPAGE.
	Headings and Footings What headings and footings are.  How to distinguish between the two types of headings and footings.  Construction of headings and footings in report requests.
	Subheadings and Subfootings How to create subheadings and subfootings.
	Column Titles and Positioning Construction of custom column titles with the AS phrase.  Controlling  column titles over multiple lines.  Suppressing column titles.  Use of the IN clause to override the placement of column titles.  Use of the OVER clause to decrease report width.

FOCUS Hot Screen
Introduces Hot Screen, a facility to review report output.   
 

	Overview How to activate Hot Screen.  How to access HELP.  Terminating the Hot Screen environment.  Basic scrolling techniques using PF keys and commands.
	Additional Techniques Advanced scrolling methods using BY paneling and column scrolling.  Locating character strings.  How to repeat commands.  Saving report output for later use as HOLD and SAVE files.