After completing FOCUS: Advanced Screening Techniques, the user should be able to:

	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

Course Conventions and Databases

	Course conventions
	Course databases

DECODE and EDIT

	The DECODE function
	The EDIT function

INCLUDES and EXCLUDES

INCLUDES/EXCLUDES

Screening on Masked Fields

Masked fields

Screening Accumulated Data

Sum of values

Additional Screening Procedures

	Compound logic with the IF statement
	Stored screening values

This course has the following features:

	A glossary
	A Skill Assessment

	FOCUS: Getting Started (FOCS01)
	FOCUS: Working with FOCUS (FOCS02)
	FOCUS: Basic Report Preparation (FOCS03)
	FOCUS: Creating Simple Reports (FOCS04)
	FOCUS: Creating Complex Reports (FOCS05)
	FOCUS: Additional Reporting Techniques (FOCS06)
	FOCUS: Fundamentals of Graphs (FOCS07)
	FOCUS: Advanced Graph Topics (FOCS08)
	FOCUS: Data Manipulation for Reporting (FOCS09)

	FOCUS: Creating File Definitions (FOCS11)
	FOCUS: Adjusting File Definitions (FOCS12)
	FOCUS: Accessing External Files (FOCS13)
	FOCUS: Basic MODIFY Requests (FOCS14)
	FOCUS: Segment Modification (FOCS15)
	FOCUS: Complex MODIFY Requests (FOCS16)
	FOCUS: Additional File Maintenance (FOCS17)
	FOCUS: Dialogue Manager and FIDEL (FOCS18)
	FOCUS: More Features of FIDEL (FOCS19)
	FOCUS: MAINTAIN Facility (FOCS20)
	FOCUS: Completing a MAINTAIN Application (FOCS21)