[Who is Akersoft] [Akersmart Library] [Akersoft Customers] [Why CBT]

This course introduces you to the design and use of relational databases using Paradox for Windows. You will learn how to create and work with tables, how to use validity checks and utility commands, how to index and sort tables, and how to use the powerful Paradox Queries. You will also learn how to create and customize Paradox reports and on-screen forms.

This course contains 11 sections (grouped in 5 lesson units) and 1 test.

Sect. 1 - The Control Panel, Using Lesson Help, Foundations and the Lesson Glossary, Using the Help Search Feature, Using Lesson Map Features, Using the Go To Page Feature, Section Summary

Sect. 2 - Looking at a Sample Database, Using a Database Management System, Relational Databases, A Multiple-Table Database, Key Fields, The Structure of a Table, Paradox Field Types, The Structure of the Job Orders Table, Object-oriented Applications, Major Paradox Objects, Section Summary

Sect. 3 - Starting Paradox for Windows, The Working Directory, Paradox Aliases, Defining an Alias, Displaying Paradox Aliases, Opening a Paradox Table, Viewing Data in a Table, Locating a Record by Number, Locating a Record by Value, Section Summary

Sect. 1 - The Project Viewer, Reviewing the Structure of a Table, Changing the Row Height, Changing the Column Widths and Positions, Saving a Table View, Changing Grid Properties, The Current Record Marker, The Paradox Help Feature, Help on Performing Tasks, The Help Glossary, Inspecting an Object from the Project Viewer, Section Summary

Sect. 2 - Getting Started, Linking the Tables, Creating a Paradox Table, Creating the Table Structure, Entering Additional Fields, Date and Money Data Types, Saving the Table Structure, Entering Data in a Table, Completing the Data Entry Process, Section Summary

Sect. 1 - Using Related Tables to Produce a Report, Many-to-one Relationships, Other Types of Relationships, The Required Field Validity Check, Setting Default Data Values, The Picture Assist Feature, Using a Sample Picture, Creating a Data Values List, Using a Data Values List, Section Summary

Sect. 2 - The Maximum and Minimum Validity Checks, Using a Key Violation Table, Copying Records, Deleting a Table, Inserting a Record, Memo Fields, Deleting a Record, Setting Up a Table Lookup, Using Table Lookup, Section Summary

Sect. 1 - Creating a Paradox Report, Creating a Data Model, Linking Additional Tables, Saving a Data Model, Selecting the JOBORDS Fields, Selecting Fields from Other Tables, The Report Band, Creating a Text Box, The Page Band, Adding a Field to the Page Band, Editing a Column Header, Viewing and Saving the Report, Section Summary

Sect. 2 - Locating a Value, Using the Scroll Lock Feature, The Need for Wildcard Operators, Using the .. Wildcard Operator, Turning Scroll Lock Off, Creating a Secondary Index, Using a Secondary Index, Creating a Composite Index, Using a Composite Index, Sorting a Table, Section Summary

Sect. 1 - Creating a Query, Displaying Selected Fields, Comparison Operators, Using the AND Operator in a Field, Using the .. Wildcard to Display a Range, Using AND with Two Fields, Using the OR Operator in a Field, Using the @ Wildcard, Using OR with Two Fields, Using the NOT Operator, Section Summary

Sect. 2 - Creating a Paradox Form, Selecting the Fields, The Color Palette, The Frame Style Palette, Using Floating Palettes, Creating a Text Box, Entering the Form Title, Using the Form, Verifying the Data, Saving the Form, Section Summary

Test - Comprehensive final exam

[Who is Akersoft] [Akersmart Library] [Akersoft Customers] [Why CBT]

To find out more about Akersoft's educational products, please contact Akersoft at: