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

	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 FOCUS files
	Code MODIFY requests that modify unique segments and multilevel descendent segments

Overview
Gives an overview of how MODIFY procedures are used to maintain FOCUS database files.  Displays a diagram, explanation and Master File Description for each database used in the course.
 

	The MODIFY Process Purpose of MODIFY requests.  Tasks performed by MODIFY requests.
	The MODIFY Request Elements of a simple MODIFY request.  Events after a request is executed.
	Course Databases Description of the databases used in the course.

Transaction Data
Covers the four statements that read and describe transactions:  FIXFORM, FREEFORM, PROMPT and CRTFORM.
 

Types of Transaction Data

Four statements that read incoming data.  Where the statements are coded within a MODIFY request.
 

	The FIXFORM Statement How to use a FIXFORM statement in a MODIFY request.
	The FREEFORM Statement How to use a FREEFORM statement in a MODIFY request.
	The PROMPT Statement How to use a PROMPT statement in a MODIFY request.
	The CRTFORM Statement How to use a CRTFORM statement in a MODIFY request.

Root Segment Modification
Presents the basics about the MATCH statements.  Focuses on using the MATCH statement to add, update and delete segment instances in the root segment of a FOCUS database.
 

	The MATCH Statement The function and format of the MATCH statement.  MATCH actions.  Rules for coding the MATCH statement.
	Adding Segment Instances How FOCUS handles an add situation.  How to add segment instances in the root segment of a FOCUS database.
	Updating Segment Instances How FOCUS handles an update situation.  How to update segment instances in the root segment of a FOCUS database.
	Deleting Segment Instances How FOCUS handles a delete situation.  How to delete segment instances in the root segment of a FOCUS database.

Descendent Segment Modification
Explains how to modify segment instances in unique descendent segments and multilevel descendent segments in a FOCUS database.
 

	Unique Segments How to modify unique segments in a FOCUS database.
	Multilevel Descendent Segments How to modify multilevel descendent segments in a FOCUS database.