Paradox, Level 3

This course introduces the experienced Paradox user to advanced functions using one of the most powerful database management programs. Database structure customization, preferred information management styles, advanced Query By Example, multiple-page data entry screens, and advanced report generation will be practiced. Scripts and the Paradox Application Language will be introduced. Network Paradox applications will also be discussed. Participants will create multi-table business databases, enter and manage information, transfer information, and generate reports.

Prerequisite: Paradox, Level 2

Outline:

Review

• Table creating
  
• Tools
  
• Form design
  
• View
  
• Validity checks
  
• Multi-record forms
  

  Multitable Forms

• Unlinked tables
  

  Forms

• Exercise
  

  Linked Tables

• Examples
  
• Exercise
  

  Viewing Linked Tables

• Exercise
  
• Hints
  

  Reports

• Report generator
  
• Lookup fields
  
• Linking multiple tables
  

  Advanced Queries

• Inclusion operator
  
• Calculations
  
• Calc
  
• Example elements
  
• Summary operator
  

  Scripts

• Begin record
  
• End record
  
• Play
  
• Script edit
  
• Instant scripts
  
• Play instant script
  
• Miniscripts
  
• Hot keys
  
• Init script
  
• Testing the init script
  

Return to DGL homepage