This complete
training course for the Crystal Reports 8 includes 7 CD-ROM's and contains
over 10 hours of professional quality instructor led training. Multimedia
content allows you to quickly learn key concepts and the CD format lets
you quickly pause and review important areas. A detailed outline of the
course as well as a short introduction to the trainer are included below.
| Crystal
Reports 8 set of 7 (CD)
| $599.95
|
|
| Crystal
Reports 8 set of 7 (VHS)
| $599.95
|
|
|
Shipping (US only)
| FREE
| | |
About The
Trainer:
Alison Balter
is a highly experienced independent trainer and consultant, specializing
in Windows applications training and development. During her seventeen
years in the computer industry, she has trained and consulted with many
corporations and government agencies. Since Alison founded her company
in 1990, their client base has expanded to include major corporations
and government agencies such as Shell Oil, the Motion Picture Editors
Guild, the International Cinematographers Guild, Prudential Insurance,
Transamerica Insurance, Fox Broadcasting, the United States Navy, and
others. Alison's company, InfoTechnology Partners, Inc., is a Microsoft
Certified Partner and Alison was one of the first professionals in the
computer industry to become a Microsoft Certified Solutions Developer.
Alison is the author of over 400 internationally marketed computer training
videos. She travels throughout North America giving training seminars
in Visual InterDev, SQL Server, Microsoft Access, Visual Basic, and Visual
Basic for Applications. She is also featured regularly in the National
Technological University live satellite television broadcasts.
Alison is a regular
contributing columnist for Access/Office/Visual Basic Advisor as well
as other computer publications. She is also a regular on the Access and
Visual Basic national speaker circuit. She was one of four speakers on
the Visual Basic/Visual Studio World Tour, a seminar series co-sponsored
by Application Developers Training Company and Microsoft.
Alison is
the author of Alison Balters Mastering Access 2002 Desktop Development,
Alison Balters Mastering Access 2002 Enterprise Development, Alison Balter's
Mastering Access 2000 Development, Alison Balter's Mastering Access 97
Development, and Alison Balter's Mastering Access 95 Development. She
is also a co-author of three other Access books published by SAMS Publishing:
Essential Access 95, Access 95 Unleashed and Access 97 Unleashed. Alison's
firm, InfoTechnology Partners, Inc., is available for consulting work
and on-site training in Microsoft Access and Visual Basic, as well as
for Windows NT/2000, Windows 9x networking, and Microsoft Exchange Server.
Level
1 (1 Hr. 47 Min.)
The
Basics (17 Min.)
- Launching Crystal
Reports
- The Application
Window
- Exploring Sample
Reports
2.0 Creating
a Simple Report (29 Min.)
- Using the Create
Report Expert
- Previewing the
Report
- Designing a Report
from Scratch
- Inserting Fields
- Browsing Field
Data
- Moving & Sizing
Report Objects
- Placing Text
Objects on the Report
Managing
Reports (9 Min.)
- Saving a Report
- Closing a Report
- Modifying a Report
Description
- Opening an Existing
Report
- Switching Between
Open Reports
Getting Help
(8 Min.)
- On-line Help
& Searching for a Help Topic
- Context-Sensitive
Help
- Printing a Help
Topic
- Seagate Software
on the Web
Selecting
Records (17 Min.)
- The Select Expert
- Using Saved versus
Refreshed Data
- Expert Options
- Criteria Based
on More than One Field
- Removing a Report
Selection
Sorting,
Grouping, & Summarizing (27 Min.)
- Sorting Records
- Grouping Records
- Working with
Group Trees
- Deleting & Changing
Groups
- Inserting Summary
Calculation
- Defining Other
Summary Calculations
Level
2 (1 Hr. 57 Min.)
Reports
Based on More than One Table (24 Min.)
- Using the Create
Report Expert
- Modifying a Report
Created with the Expert
- Building a Multi-table
Report without the Expert
Enhancing
Your Report with Formatting (17 Min.)
- Changing the
Font of a Text or Field Object
- Adding Borders
& Drop Shadows
- Formatting Numeric
Data
- Changing Object
Alignment
Utilizing
Conditional Formatting (23 Min.)
- Absolute Formatting
- Conditional Formatting
- The Highlighting
Expert
- Modifying & Deleting
a Conditional Format
Creating
Formulas with Crystal Syntax (47 Min.)
- The Formula Editor
& Inserting Formulas
- Changing Numbers
to Words
- String Manipulation
- Date Calculations
- Creating Summary
Calculations & Totaling By Group
- Working with
Running Totals
- Running Sums
- If-Then-Else
Formulas
Creating
Formulas with Basic Syntax (6 Min.)
- Creating Formulas
& Entering Code
- Adding Comments
Crystal
Reports 8.0 Level 3 (2 Hrs.)
Parameter Fields
(19 Min.)
Creating Parameters
Fields
Working with Multiple
Parameter Fields
Adding a Parameter
Field to a Printed Report
Deleting Parameters
Formatting Report Sections (36 Min.)
- Changing the
Size of a Section
- Sizing a Section
Automatically
- Inserting &
Deleting Lines
- Using the Selection
Expert
Advanced
Grouping Techniques (16 Min.)
- Grouping &
Sort Direction & Custom Groups
- Sorting within
a Group
- Grouping on
Intervals
Finishing
Touches (17 Min.)
- Using the Style
Expert
- Creating Special
Fields
- Special Text
Object Features
- Working with
Lines & Boxes
- Adding Pictures
to Your Report
Including
Cross-Tabulations in Your Reports (32 Min.)
- Creating a
Cross-Tab Report Using the Cross-Tab Expert
- Creating a
Cross-Tab Report without an Expert
- Modifying the
Data included in a Cross-Tab Report
- Formatting
a Cross-Tab Report
Crystal
Reports 8.0 Level 4 (2 Hrs. 3 Min.)
Summary Reports
(19 Min.)
Building a Summary
Report
Allowing or Disallowing
Drill-downs
Running Totals
Reports (22 Min.)
Creating Running
Totals Overall
Creating Running
Totals for a Group
Creating Conditional
Running Totals
Creating Running
Totals with a One-to-Many Relationship Top N (10 Min.)
- Creating a
Report with the Top N Values
- Creating a
Report with the Bottom N Values
Working
with Subreports (20 Min.)
- Creating an
Unlinked Subreport
- Creating a
Linked Subreport
- On-demand Subreports
Advanced
Record & Group Selection (22 Min.)
- Setting up
Group Selection
- Creating a
Record or Group Selection Formula
Mailing
Labels (9 Min.)
- Creating Mailing
Labels
- Modifying the
Attributes of Mailing Labels
Form Letters
(21 Min.)
- Creating a
Form Letter with the Expert
- Modifying Attributes
of a Form Letter
- Creating a
Form Letter without the Expert
- Customizing
a Form Letter for Different Recipients
Crystal
Reports 8 Level 5 (1 Hr. 40 Min.)
Working with Data
(54 Min.)
Databases Overview
Aliases
Indexes
Relationships
SQL & SQL Databases
Server-side Processing
Mapping Database
Fields
Working with Different
Types of Data
Advanced Database
Features
Reporting on the
NT Event Log
Reporting on Exchange
or Outlook Data Using SQL (Structured Query Language)
(16 Min.)
- What is SQL?
& Creating a Report Based on an ODBC Datasource
- Building a
SQL Query
- Modifying SQL
Options
The Crystal
Query Designer (18 Min.)
- Why Use a Query
- Creating a
Query
- Modifying the
Query
- Creating a
Report from a Query
- Basing a Query
on a Query
Creating
a Data Dictionary (12 Min.)
- Why Use a Data
Dictionary?
- Creating a
New Data Dictionary
- Basing a Report
on a Dictionary
- Setting Dictionary
Options
Crystal
Reports 8 Level 6 (1 Hr. 58 Min.)
Advanced
Formula Techniques (51 Min.)
- Creating a
Complex Formula
- Using a Variable
- Assigning a
Value to a Variable
- Using Arrays
in Formulas
- Using Ranges
in Formulas
- Debugging Formulas
Charting
Your Report Data (1 Hr. 7 Min.)
- Creating a
Group Chart
- Creating a
Detail Formula Chart
- Creating a
Cross-tab Chart
- Modifying Chart
Options
- Drilling Down
on a Graph
- Re-entering
the Chart Expert
- Using a Graph
Template
Crystal
Reports 8 Level 7 (2 Hrs. 17 Min.)
Mapping
(44 Min.)
- Mapping on
Grouped Fields
- Modifying Map
Attributes
- Mapping on
Detail Fields
- Mapping on
Cross-tab Summaries
- Using the Map
Analyzer
OLE (27
Min.)
- OLE Introduced
- Adding OLE
Objects to a Report
- Working with
Static OLE Objects
- Embedded vs.
Linked Objects
External
Data Sources (25 Min.)
- Dbase/FoxPro
- The File System
- NT Event Log
- Exchange
- Outlook
Distributing
Reports (7 Min.)
- Exporting a
Report
- Mailing a Report
Distributing
Reports Over the Web (15 Min.)
- Saving a Report
as HTML
- Crystal Web
Report Server
- Building Active
Web Sites
Integrating
with Visual Basic (19 Min.)
- The Crystal
Report Engine API
- Crystal ActiveX
Controls
|