Paradox for Windows, Level 2

This course introduces the intermediate Paradox for Windows user to common business database management functions using one of the most powerful database management programs. Database structure alteration, advanced information management, benefits of multiple keyed fields, Query By Example, personalized data entry screens, and custom report generation will be emphasized.

Prerequisite: Paradox for Windows, Level 1

Outline:

Review

• Objective
  
• Database review
  
• Table creation
  
• Data entry
  
• Table and form view
  

  Paradox Tools

• Tools menu
  
• Rename
  
• Copy
  
• Info
  
• More
  
• Empty
  

  Restructuring Tables

• Table structure
  
• Key fields
  
• Creating key fields
  
• Modifying structure
  

  Forms

• Form usage
  
• Form creation
  
• Borders
  
• Form heading
  
• Field placement
  
• Form color
  
• Moving fields
  

  Validity Checks

• Picture formats
  
• Alternative values
  
• Minimum value
  
• Maximum value
  
• Default value
  
• Table lookup
  
• Detailed pictures
  

  Query By Example

• QBE
  
• Selecting fields
  
• Ditto
  
• Comparison operators
  
• Example elements
  
• Special operators
  
• Check
  
• Check plus
  
• And
  
• Or
  
• Query save
  

  Reporting

• Tabular reports
  
• Table band
  
• Free form reports
  
• Grouping
  
• Printing reports
  
• Report summary field
  

Return to DGL homepage