Login 
Password
  
 


Free Exams!
Test your skills with one of our certification exams and see how you stack up right now.

Homepage
Visit our homepage and find out more about what NCSA can do for you.

Learn More About Us
Find out more about how our certifications can benefit you.

Course Descriptions
View a complete listing of certifications available through NCSA.

Access 2000
Excel 2000
Word 2000
PowerPoint 2000
Access 2002
Excel 2002
Word 2002
PowerPoint 2002
Office 2000
Office XP
Windows 2000 Pro
Windows 2000 Server
Visual C++
JavaScript
Computer Hardware
ColdFusion 4.5
HTML 4.0

HTML Tag Library
Visit our HTML tag library, a free reference we provide to our visitors.

Certificate Database
Lookup a certification in our online database.

Affiliate Program
Make money by helping people get the computer training and certification they need. Sign-up Here!

Support Center
If you have questions or concerns feel free to visit our online support center.


 


In addition to our training courses we also offer free online certification exams on several topics including Microsoft Office, Computer Hardware, HTML, PC Basics and more.

Click here for online certification exams.


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

  • Please visit our special offers page to view some superb offers from our partners on the web. To view our special offers click here.

    Or continue browsing our courses below.


    3D Studio Max
    A+ 2003
    Microsoft Access 2007
    Acrobat 4
    ActiveX and OLE
    Adobe Illustrator
    Adobe InDesign CS
    Adobe PhotoShop CS
    ASP .NET
    AutoCAD 2000
    C Programming
    C# Programming
    Cisco CCNA
    CompTIA Security+
    CorelDRAW 10
    Crystal Reports 8
    Delphi 6

    Exchange Server 2000
    Flash 5
    Frontpage 2000
    ICDL/ECDL
    IIS 5
    Java 2
    Linux 101
    Linux 102
    Lotus Notes 5
    MicroSoft .NET
    Network+ 2002
    Oracle 8iR2
    Outlook 2000
    Outlook XP
    PageMaker 6.5
    Paradox 8

    Perl 5
    PhotoDraw 2000
    PhotoPaint 8
    SQL Server 2000
    TCP/IP 4
    Unix
    Visio 2002
    VB .NET
    VBScript 5
    Visual FoxPro 6
    MCSE 2000
    Windows XP User
    WordPerfect 9
    WordPerfect 11
    XML
    ZenWorks 3.0

         

         


    Typing Speed Test
    Test your typing speed with our certified typing speed test today.

      
    HOME      EMPLOYERS    TESTING CENTERS    CERTIFICATION LIST    INSURANCE QUOTES    AFFILIATES    CONTACT US

    © 2002-2010 National Computer Science Academy, All Rights Reserved.