Paradox, Level 1
This course introduces the new Paradox 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: Hard Disk Management
Outline:
Paradox 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
- Coedit mode
- Edit vs. coedit modes
- 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
- Instant report
Network Databases
- Network database editing
- Full lock
- Write lock
- Prevent write lock
- Prevent full lock
- Family lock
- Record lock
- Form lock
- Automatic locks
- Lock restrictions
- How locks are applied
http://dgl.com/px1.html
updated July 7, 1995
Copyright © 1995, Damar Group, Ltd., All Rights Reserved