Paradox, Level 2

This course introduces the intermediate Paradox 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, Level 1

Outline:

Review

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

  Paradox Tools

• Tools menu
  
• Rename
  
• Copy
  
• Info
  
• More
  
• Tools 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
  
• Area move
  

  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