Beginning

Intermediate

 Advanced

Module 1: Table Design. Navigate the Paradox Desktop, Design a Table, Enter Table Data, Edit Table Data, Insert and Delete Records, Restructure a Table, Use On-Line Help

Module 2: Modify Table View. Modify Table View (Directly), Change Table Properties, Create Custom Field Formats, Use Data-Dependent Properties, Use Table Filters, Format Text in Formatted Memo Fields

Module 3: Validity Checks. Set Minimum and Maximum Values, Set Default Values, Make a Field Required, Apply Validity Checks to Existing Data, Create Picture Formats, Create Formats with Repeats, Literals, and Groups

Module 4: Create Forms. Create a Form, Explore Layout Types, Modify Form Design, Modify Display Types, Use Forms for Input, Create a Calculated Field, Use the Form Expert

Module 5: Queries. Create a Query, Use Record Selection Criteria, Search for Ranges, Use AND Conditions, Use OR Conditions, Combine AND and OR Conditions

Module 6: Importing and Exporting. Use dBASE Files, Export to a Spreadsheet, Import a Spreadsheet File, Import a Delimited ASCII File, Import a Fixed Length ASCII File, Export to an ASCII File

Module 7: Relational Database. Establish a One-to-One Relationship, Establish a One-to-Many relationship, Use the Inclusion Operator, Define Joins with Multiple Relationships, Use Data Model to Define Query Joins, Use Data Modules Containing Joined Tables

Module 8: Reports. Create a report, Inspect and Modify Objects, Insert a Field Object, Work with Bands, Create Group Bands, Use Summary Fields, Use Report Expert and Quick Report

Module 9: Charting. Use Crosstabs, Create a Chart, Modify Chart Properties, Explore Chart Types, Use Charts with Percentages, Use Charts for Interval Data, Use Charts in Reports

Module 10: Intermediate Table Use. Use Table Utilities, Borrow a Table's Structure, Create Secondary Indexes, Use Picture Statements, Use Table Lookups, Establish Password Protection

Module 11: Multitable Queries. Use Pattern Matching, Specify Calculations, Use Insert Queries, Create Delete Queries, Use the CHANGETO Operator, Construct Multitable Queries

Module 12: Forms Using Linked Tables. Link a Data Module to a Form, Work with Multiple Designs, Use Table Frames, Explore Additional Properties, Work with Multi-Record Objects, Create Summary Fields

Module 13: Explore SQL Features. Write a SQL Query, Specify Query Conditions, Use Arithmetic and Functions in SQL, Group Records, Add and Delete Records, Modify Rows

Module 14: Use Graphics and OLE. Use Graphics in Forms, Insert Graphics into Tables, Embed an Existing Object, Link an Existing Object, Create a New OLE Object, Use OLE Field Types

Module 15: ObjectPAL Building Blocks. Understand Containership, Explore Objects and Properties, Understand Assignment Statements, Explore Built-In Methods, Use Run-Time Libraries

Module 16: Control Structures. Understand Logical Values, Use IF Statements, Use Immediate IF (IIF) Statements, Use SWITCH Statements, Use FOR Loops, Use WHILE Loops