This course is provided by Wintrac.
Wintrac
provides one stop shopping for all your IT training needs. Wintrac’s course catalog
of over two thousand courses includes courses on
Desktop Application Software
training,
database
training,
E-Mail/Groupware training,
Office Suite training,
Operating Systems training,
Presentations training,
Spreadsheets training,
Web Browsers training and
Word Processing training
Overview:
Students will learn what a relational-database management system is; how to create tables, forms, queries, and reports; and data-entry techniques. They will also learn good database design techniques.
Prerequisites:
Windows 98: Introduction or equivalent knowledge.
Target Student:
Students enrolling in this course should understand how to use Windows 98.
What's next:
Paradox 9.0: Introduction is the first course in this series. Paradox 9.0: Advanced, the next course in this series, teaches student how to normalize their data, link tables, and automate common tasks.
Performance-Based Objectives:
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
- Define database terminology and identify Paradox objects.
- Create a table structure by using the Table Expert and the Create Table dialog box.
- Update and maintain tables by adding, editing, locating, and deleting records, and by restructuring a table.
- Create, modify, and use a form, and change form properties by using the Form Design window.
- Sort fields, select records, and perform calculations on data by creating and using queries.
- Create reports by using the Report Expert and a data model.
Delivery Method:
Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
Hardware/Software Requirements:
To run this course you will need a 486 processor (a Pentium is recommended), a minimum of 16 megabytes (MB) of Random Access Memory (RAM), and 75 MB of hard disk space to install Paradox. You will need more memory if you install additional Corel WordPerfect Office 2000 Professional applications.
This course was developed using Corel WordPerfect Office 2000 Professional Edition. If you use the stand-alone version of Paradox, you might notice differences. See your reference manual for hardware considerations that apply to your specific hardware setup.
In addition, you will need printers if you want to print the reports created in the course.
Course duration:
1 Day(s)
Course outline:
Lesson 1: Overview of Paradox 9.0
- Introduction to Database Concepts and Terminology
- An Introduction to Paradox 9.0
- Database Planning and Design
Lesson 2: Creating Tables
- Examining Tables
- Planning the Table Design
- Creating a Table by Using the Table Expert
- Creating a Table by Using the Create Table Dialog Box
Lesson 3: Entering Data and Modifying Table Design
- Adding Records to a Table
- Finding and Editing Records
- Deleting and Copying Records and Values
- Modifying a Table Structure
- Using the Project Viewer to Manage Files
Lesson 4: Creating and Using Forms
- Creating and Modifying a Form
- Changing the Properties of Form Objects
Lesson 5: Using Queries
- An Orientation to Query Concepts
- Selecting and Sorting Fields
- Editing Table Data by Using Live Query View
- Introduction to Using Calculations in Queries
- Introduction to Multi-table Queries
Lesson 6: Creating and Using Reports
- Creating a Report by Using the Report Expert
- Creating Reports by Using a Data Model
- Modifying a Report Design
Appendix A: Paradox Experts
