Corel Paradox X3 Course Outline

Corel Paradox X3

Section 1: Database Basics

Lesson 1.1: Understanding Databases

What is a Database?

How is a Database Organized?

What is a Primary Key?

What is an Index?

Why Use Related Tables?

Why Use Validation Rules?


Skill Sharpener

Lesson 1.2: Getting Started

Common Database Applications

Opening the Database Application

Understanding the Interface

Showing and Hiding Toolbars

Getting Help

Closing the Application


Skill Sharpener

Lesson 1.3: Creating a Database

Creating a Blank Database

Creating a Basic Table

Entering Data

Editing Data

Deleting Data


Skill Sharpener

Lesson 1.4: Working With Database Files

Creating a New Database

Saving Database Tables

Opening Databases

Closing Database Files without Closing the Application


Skill Sharpener

Lesson 1.5: Printing Database Files

Printing a Report

Using Print Preview

Printing a Form

Changing Page Size and Page Orientation for a Report

Printing a Table


Skill Sharpener

Section 1: Case Study

Section 1: Review Questions

Section 2: Working With Tables

Lesson 2.1: Table Basics

Creating a Table

Specifying Data Types

Saving and Closing a Table


Skill Sharpener

Lesson 2.2: Working With Records

Adding and Deleting Table Records

Adding Data to a Record

Modifying Record Data

Deleting Record Data


Skill Sharpener

Lesson 2.3: Editing Tables

Adding Fields to an Existing Table

Changing the Table View

Using Undo

Navigating in a Table


Skill Sharpener

Lesson 2.4: Designing a Table

Defining a Primary Key

Creating a Secondary Index

Changing Field Formats

Creating Validation Rules

Changing Column Width

Moving Columns


Skill Sharpener

Lesson 2.5: Editing Table Relationships

Understanding Relationships

Creating a Relationship

Removing Relationships

Applying Rules to Relationships


Skill Sharpener

Section 2: Case Study

Section 2: Review Questions

Section 3: Advanced Database Skills

Lesson 3.1: Working With Forms, Part 1

Opening an Existing Form

Creating a Form

Saving a Form

Closing and Saving a Form

Deleting a Form


Skill Sharpener

Lesson 3.2: Working With Forms, Part 2

Changing the View of a Form

Navigating Records in a Form

Modifying Records with a Form

Changing the Form Color

Adding Buttons

Making the Form Buttons Functional


Skill Sharpener

Lesson 3.3: Searching For Information

Searching in a Field

Sorting Data

Using Filters

Creating and Saving a Query

Creating a Two-Table Query

Editing a Query


Skill Sharpener

Lesson 3.4: More on Queries

Editing a Query Field

Sorting Query Data

Running a Query

About QBE Queries

Deleting a Query

Saving a Query

Saving and Closing a Query


Skill Sharpener

Lesson 3.5: Reports, Part 1

Creating and Saving a Report

Moving Data Fields and Headings

Grouping Data

Summarizing Data by Function


Skill Sharpener

Lesson 3.6: Reports, Part 2

Changing the Report View

Closing and Saving a Report

Changing Report Layout

Printing a Report

Deleting a Report


Skill Sharpener

Section 3: Case Study

Section 3: Review Questions


Download this course as a demo

Complete the form below and we'll email you an evaluation copy of this course:

What You Get with Velsoft Courseware