After completing this course, the student should be able to:
|define FOCUS 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|
Describing the File
Explains the Master File Description and its purpose. Introduces the databases used for examples throughout the course. Describes the attributes used in the file declaration.
|The Master File Description|
The Master File Description and its purpose. Three types of declarations that make up a MED. Rules for coding MFDs and FOCUS commands.
Description of the databases used in this course.
How to identify the file with the FILENAME attribute. How to identify the type of file with the SUFFIX attribute.
Covers the attributes used in the segment declaration.
How to identify a group of related data fields with the SEGNAME attribute. How to code the appropriate PARENT attribute for the desired data structure.
How to sequence instances of data in the segment with the SEGTYPE attribute.
Covers the attributes used in the field declaration. Explains the edit options available for numeric fields and the formatting and use of date fields.
How to identify the fields in a file with the FIELDNAME attribute. How to provide an alternate name for a field with the ALIAS attribute.
How to characterize a field's data with the FORMAT attribute.
|Types of FORMAT Values|
How to specify a field's type, length and edit options with the FORMAT attribute.
|Edit Options for Numeric Fields|
How to assign edit options for numeric fields using the FORMAT attribute.
Edit options that affect the display of dates. How FOCUS stores data in date fields.
Describing Fields: Additional Features
Covers other attributes used in the field declaration. Covers creating and using temporary fields.
|TITLE and DESCRIPTION Attributes|
How to override the default column title with the TITLE attribute. How to document the meaning of a field with the DESCRIPTION attribute.
|ACCEPT and Other Attributes|
How to use the ACCEPT attribute to validate incoming data values. The MISSING, FIELDTYPE and HELPMESSAGE attributes.
How to create temporary fields with the DEFINE attribute. Using temporary fields.
Creating an MFD
Ties together concepts covered in the course with a sample application of a Master File Description. Describes the CHECK command.
|A Sample Application|
Coding a simple MFD based on hypothetical data.
|The CHECK Command |
How to use the CHECK command to verify MFD coding.
To take this course, you need the following materials:
Student, Administrator and Installation Guides
Presentation Systems Available