Course outline for
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?

Step-By-Step

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

Step-By-Step

Skill Sharpener

Lesson 1.3: Creating a Database

Creating a Blank Database

Creating a Basic Table

Entering Data

Editing Data

Deleting Data

Step-By-Step

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

Step-By-Step

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

Step-By-Step

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

Step-By-Step

Skill Sharpener

Lesson 2.2: Working With Records

Adding and Deleting Table Records

Adding Data to a Record

Modifying Record Data

Deleting Record Data

Step-By-Step

Skill Sharpener

Lesson 2.3: Editing Tables

Adding Fields to an Existing Table

Changing the Table View

Using Undo

Navigating in a Table

Step-By-Step

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

Step-By-Step

Skill Sharpener

Lesson 2.5: Editing Table Relationships

Understanding Relationships

Creating a Relationship

Removing Relationships

Applying Rules to Relationships

Step-By-Step

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

Step-By-Step

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

Step-By-Step

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

Step-By-Step

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

Step-By-Step

Skill Sharpener

Lesson 3.5: Reports, Part 1

Creating and Saving a Report

Moving Data Fields and Headings

Grouping Data

Summarizing Data by Function

Step-By-Step

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

Step-By-Step

Skill Sharpener

Section 3: Case Study

Section 3: Review Questions

Index