Welcome to the Paradox tutorial

Paradox is a powerful, yet easy to use database management program that gives you the tools to store and manipulate data in a variety of ways.

This tutorial was designed to provide new users of Paradox with the skills needed to create a database. By following each of the lessons in order, you will learn how to use the many features of Paradox. These features will help you quickly and easily create a database designed to meet your personal or business needs.

The lessons in this tutorial are based on a fictitious company named Training-By-Design Corporation (TBD). TBD provides training services and sells a variety of software products and training videos to a growing customer base. The business requires an automated database to store and track information pertaining to their customers, the courses offered, the products they sell, product orders, and their employees. You can install the tutorial sample files used to support the TBD application. For more information about installing the tutorial sample files, see "Installing the Paradox Classic (MAST) sample and tutorial files."

In this tutorial, you'll notice that there are words and phrases that are underlined. When you click a word or phrase underlined with a single line, you'll get additional information about the buttons or flyouts you are using, or you'll see a pop-up graphic of what your database object should look like. When you click a word or a phrase underlined with a double line, you will jump to a new topic.

You can easily navigate through the tutorial by clicking the following buttons:

  Contents
  
  Back
  
  Print
  
  Backward
  
  Forward
  
  Next Lesson
  
  Previous Lesson
  
If you need additional help for procedures or concepts that you learn using the tutorial, consult the Paradox online Help.

Before you begin

Before you begin the lessons, you should be familiar with Microsoft Windows 95, Microsoft Windows 98 or Windows NT on which Paradox runs. You should know how to open and close Windows applications, how to browse for files, how to use a mouse, and how to use standard Windows menus and dialog boxes. For more information about Windows, see the Microsoft Windows documentation.

You should also know the basic concepts and terminology that apply to database design. 

Once you have completed the lessons in this tutorial, you will have a clear idea of how to organize your own information in a database, how to use forms and special features to maintain that information, and how to generate the reports you need based on your data.

Using the tutorial lessons

The eight lessons in this tutorial will help you learn the concepts and basic skills required to create and work with Paradox databases. Lessons 1 to 7 will walk you through essential concepts in the creation of a simple database, and teach you how to use basic features of the program. Lesson 8 will show you how to tie all these basic features together. After you complete the lessons, you'll have the knowledge and the confidence to create your own database application. Here's what you'll learn:

Database Concepts:

Lesson 1: Exploring Paradox

In this lesson, you'll examine the elements of the Paradox Application Window. You'll learn about basic Paradox database objects, explore options available from the Welcome screen, set your current working directory to the sample files provided with the program, and navigate through files using the Project Viewer.

Lesson 2: Creating a table

In this lesson, you'll learn the basic steps used to create a table, and define table properties using the Table Restructure dialog box.

Lesson 3: Linking your tables

In this lesson, you'll learn how to use the Visual Database Designer to link your tables together. You will also learn how to create referential integrity relationships.

Lesson 4: Working with forms

In this lesson, you'll learn how to create and customize a form. You will also learn how to create lookup tables. You will then use the form and the lookup tables to enter and edit data in your tables.

Lesson 5: Entering Data

In this lesson, you'll learn how to create forms and lookup tables to enter data into the tables in your database.

Lesson 6: Working with reports

In this lesson, you'll learn how to create and customize a report based on a data model, and how to use the report design to print the data you require.

Lesson 7: Working with queries

In this lesson, you'll learn how to construct queries using the Visual Query Builder to retrieve a variety of information from your database and how to edit, insert, and delete data using queries.

Lesson 8: Using the Launcher Expert

In this lesson, you'll learn how to tie all your objects together using the Launcher Expert, which creates a small tabbed form that you can use to open or launch selected forms, reports, and queries.






