|
|
|
|
COURSE TITLE:
Corel Paradox Training UK
LEVEL:
Introduction : Advanced
COURSE LENGTH:
1 day
COURSE PRICES:
*All prices quoted exclude VAT
COURSE OVERVIEW:
Paradox is a database management system (DBMS) offering strong compatibility with Microsoft Access, dBASE and other ODBC-compliant databases, for using and sharing data. |
| |
|
The course outlines below set out the full range of topics you can choose to cover during your on-site training course, and you can build your course around your exact training requirements, or any specific projects you or your staff are working on at present.
You will find that this approach makes our courses the most effective and productive use of your training budget available today. |
Introduction Level
Introduction To Databases
What Are Databases?
An Overview Of Manual Databases
A Comparison With Computerised Databases
Planning Your Database
Components Of A Database
Tables
Forms
Reports
Indexes
Queries
Graphs
CrossTabs
ObjectPAL
Paradox Basics
Starting Paradox
Closing Paradox
The Interface
Creating A Table
Field Names
Field Types
Naming Rules
Paradox Temporary Tables
Paradox Key Fields
Secondary Indexes
Creating Tables
Adding Fields
Saving Tables
Entering Data
Moving Through A Table
Editing Data In A Table
Formatting The Table
Restructuring The Table
Importing And Exporting Data
Supported Formats
Sorting And Using Indexes - Dynamic
How Indexes Work
Setting Up A Primary Key Field
Working With Multiple Tables
Designing Tables
Relational Database
Definition
Creating A Relational Model
Different Types Of Links
Primary Key Fields
Referential Integrity
Defining Referential Integrity Rules
Forms
Using The Quick Form
Designing A New Form
Designing A Single Table Form Using The Expert
Tabular Forms
Multi-Table Forms
Creating Multi-Table Forms
Forms Design Tools
Query By Example
Filters
Types Of Queries
The Query Form
Selecting Fields
Query Criteria
Reporting
Tabular Reports
Single Record Reports
Merge Letters
Multi-Record
Using The Quick Report
The Screen Preview
Creating Reports
Report Designer
The Toolbar
The Report Bands
The Page Header Band
The Page Footer Band
The Report Band
The Records Band
Groups In Reports
Printing A Report
Saving The Report
Options During Installation
Installing The Correct Import Filters
Selecting Dictionaries
Selecting Postscript Printing Devices
Setting CMS Device Profiles
Determining Optimum Resolution
Defining Filters Upon Installation
Selecting The Correct Filters Initially
Selecting And Installing Dictionaries
What Is Postscript Printing?
What Is CMS?
What Is A PPD?
Options During Installation
Installing The Correct Import Filters
Selecting Dictionaries
Selecting Postscript Printing Devices
Setting CMS Device Profiles
Determining Optimum Resolution
Defining Filters Upon Installation
Selecting The Correct Filters Initially
Selecting And Installing Dictionaries
What Is Postscript Printing?
What Is CMS?
What Is A PPD?
|
Advanced Level
Relationships
Single-Valued And Multi-Valued Relationships
Referential Integrity
Creating Self-Referential Integrity
Restructuring Tables With Referential Integrity
CrossTabs
Creating Quick CrossTabs
CrossTab Expert
Adding A CrossTab
To A Form Or Report
Design Mode
The Rulers
Editing CrossTab Objects
Changing Object Properties
Lookup Tables
Creating And Using A Table Lookup
Modifying And Erasing A Table Lookup
Advanced Queries
Set Queries
Groupby Checkmark
Defining A Set
Set Comparison Operators: Only Set, No Set, Every Set And Exactly Set
Set Queries Involving Several Sets
Summary Operators
Inclusive Link
Operator
Linking To All Records
Retrieving Records
Using The Inclusion Operator In A Query With A Calculation Using Both Inclusive And Exclusive Links In A Query
Rules For Linking Tables
Data Modelling
Creating A Data Model As Part Of A Form Or Report
Creating A Data Model From A Query
Using The Data Model Designer Window
Opening An Existing Data Model
Complex Forms
Form Design
Creating A New Form Using: The Form Expert, A Data Model Or Layout Diagram
Objects
Toolbar, Ruler And Grid
Adding A Field To A Form
Understanding And Defining A Field Object
Using Calculated Fields
Calculating With: Regular Fields, A Field And A Constant, Alphanumeric Strings
Using Pages
Using The Form Window Properties Dialog Box
Complex Reports
The Report Expert
What Are Report Bands?
Creating Labels Using The Mailing Label Expert
Creating A Group Or Summary Report Using The Report Expert
Report Design
Creating A Report Using A Data Model Or Layout Diagram
Toolbars
Object Explorer
Object Properties
Band Properties
Resizing A Band
Adding A Group Band
Group Band Properties
Adding A Field
Inserting And Deleting Page Breaks
Calculating With Summary Field Values
Object Linking And Embedding
Paradox As A Server Or A Container
Using The Graphic Tool To Add An OLE Object
Using The OLE Tool To Add An OLE Object
OLE Type Fields In A Table
Export And Import
Export Formats
Import Formats
Exporting And Importing Data
Security
Password Security
Adding, Changing And Deleting Passwords
The Enter Password Dialog Box
Utilities
Object Utilities
Renaming A Database Object
Copying A Database Object
Deleting A Database Object
Copying Referential Integrity
Appending Records From One Table To Another
Subtracting Records From A Table
|
|
|
BACK TO TOP |
|
|
|
"I would just like to say how pleased we were with the way in which ABC Dee Training handled our training requirements....." Vicky Farrow, Kent Fire & Rescue
"My experience with this company has been a positive one and
I would happily recommend ABC Dee Training to others."
Anna Faithfull, London Film
|
| |
