Paradox for Windows, Level 1

This course introduces the new Paradox for Windows user to functions of one of the most powerful database management programs. Database construction, structure alteration, and information management will be presented. Participants will create databases, enter data, key fields, sort tables, and print reports.

Prerequisite: Windows, Level 1

Outline:

Paradox for Windows Description

Getting Started

• Basic database terminology
  
• Introduction to menus
  
• Examining menu options
  
• Viewing a table
  
• Clearing the screen
  
• Returning to the menu
  

  Tables

• Viewing the table telebook
  
• Viewing multiple tables
  
• Field types
  
• Creating a table
  
• Saving the table structure
  

  Table Editing

• Adding new records
  
• Data entry mode
  
• Adding records with data entry mode
  
• Edit mode
  
• Changes to existing records
  
• Additional changes
  
• Undo a modification
  
• Saving changes
  
• Field edit
  
• Deleting a record
  
• Restoring a deleted record
  

  Other Views

• Form view
  
• Switch to form view
  
• Return to table view
  
• When to use form toggle
  
• Editing in form view
  
• Moving to the next record
  

  Changing Image Characteristics

• Adjusting table size
  
• Decreasing the displayed records
  
• Changing a column width
  
• Resizing the field
  
• Keepset
  
• Active image
  
• Rotating columns
  
• Changing field order
  

  Sorting

• Ascending
  
• Descending
  
• Defining the sort
  
• Executing the sort
  
• Comparing tables
  
• Sorting on multiple fields
  

  Restructuring Tables

• Restructure sales
  
• Structure change
  

  Key Fields

• Keying a field
  
• Queries
  
• Query by example
  
• Selecting all records
  
• Selecting fields
  
• Wild card operator
  
• Executing the query
  
• Selecting a range
  

  Reports

• Printing table information
  

Return to DGL homepage