FoxPro, Level 1

This course introduces the new FoxPro user to the functions of this popular database management program. Database construction, structure modification, and information management will be presented. Participants will create personal databases, enter data, index records, and print reports.

Prerequisite: Hard Disk Management

Outline:

Database Management

• Database examples
  
• Record
  
• Field
  
• Field types
  

  Getting Started

• Starting FoxPro
  
• Control Panel
  
• Clearing the screen
  
• Using a database file
  
• Viewing a record
  
• Record numbers
  
• Goto record number
  
• Displaying all records
  
• Listing records
  
• Display all vs. list
  
• Closing the database
  

  Entering & Deleting Data

• Appending records
  
• Saving the database
  
• Appending multiple records
  
• Editing records
  
• Browsing records
  
• Moving to the ends
  
• Deleting records
  
• Packing the database
  

  Using Selected Fields

• Browsing selected fields
  
• Deleting specific records
  
• Recalling specific records
  
• Editing specific records
  
• Hiding deleted records
  
• Revealing deleted records
  
• Undeleting records
  

  Creating A Database

• Planning the structure
  
• Creating the structure
  
• Modifying the structure
  

  Informal Reports

• Listing to screen
  
• Listing to print
  
• Additional listing
  
• Displaying structure
  

  Relational & Logical Operators

• Logical .AND. operator
  
• Logical .OR. operator
  

  Indexing

• Multiple field index
  
• Closing all
  
• Using a database and index
  
• Using another index
  

  Formal Reports

• Creating
  
• Printing
  

Return to DGL homepage