Universal Class: Over 500 Online Certificate Courses
 

Online Class: Crystal Reports


$70.00
no certificate
- OR -
$95.00
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
 
 
 

Course Description

Crystal Reports is a user-friendly report creation tool created and distributed by SAP.  The program is run on the Windows operating system.  It allows users to easily create and design detailed reports using data from various data sources, such as Excel spreadsheets, Oracle databases, Microsoft Access databases, MySQL server databases, and even local files.   The data that Crystal Reports gathers can be used in a multitude of report types, including list reports, mailing label reports, customer letters, financial analysis, activity, summaries, and much more.

This course was created for anyone who wants to learn Crystal Reports.  It doesn't matter if you already have experience with Crystal Reports or are a complete newbie to the software.   We will teach you the program from beginning to end so that anyone, regardless of experience, learns all that they need to know to successfully use the program. 

You will learn how to:

·    Connect to data sources such as Access and MySQL databases and Excel spreadsheets.

·    Add tables and views from data sources to be used in Crystal Reports

·    Create a report

·    Add data fields to a report

·    Format, align, and move data fields and headers to begin to customize a report

·    Add special data fields to a report

·    Add non-data objects to a report

·    Sort and filter data in a report

·    Organize data into groups

·    Add grand total and sub-total fields

·    Create and work with parameter fields

·    Create and use formula fields

·    Insert charts into a report

·    Link multiple tables together

·    Export and distribute reports

·    And more


Course Requirements

This course will not require you to have previous experience in any particular area but you should have the following:

-Crystal Reports 2013 (recommended) *
- a high school reading level.


No books will be required.

*students interested can download the free trial version of the current version of  Crystal Reports for this course. 

Course Goals

You will learn how to:

·        Connect to data sources such as Access and MySQL databases and Excel spreadsheets.

·        Add tables and views from data sources to be used in Crystal Reports

·        Create a report

·        Add data fields to a report

·        Format, align, and move data fields and headers to begin to customize a report

·        Add special data fields to a report

·        Add non-data objects to a report

·        Sort and filter data in a report

·        Organize data into groups

·        Add grand total and sub-total fields

·        Create and work with parameter fields

·        Create and use formula fields

·        Insert charts into a report

·        Link multiple tables together

·        Export and distribute reports

·        And more

Course Materials

All course material will be provided in the lessons and netlinks. There are no required materials to purchase before taking the class. In order to fully benefit from this course, though, you do need access to Crystal Reports.

Grading Policy

Each lesson will include a lesson review exam along with an assignment. Students will successfully complete this course with 70% or better.

Learning Outcomes

By successfully completing this course, students will be able to:
  • Describe what Crystal Reports is and what it can do for you.
  • Know formatting techniques in Crystal Reports.
  • Identify special data fields in Crystal Reports.
  • Identify non-data object in Crystal Reports.
  • Know sorting data techniques in Crystal Reports.
  • Know filtering data techniques in Crystal Reports.
  • Know grouping data techniques in Crystal Reports.
  • Know adding data summary fields in Crystal Reports.
  • Know working with parameter fields.
  • Know working with formulas, charts, and the report card wizard.
  • Know exporting and distributing reports, and
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 

Assessment Guide

Assessment Points
Exam 110
Exam 210
Exam 39
Exam 410
Exam 510
Exam 610
Exam 710
Exam 810
Exam 910
Exam 1010
Exam 1110
Exam 1210
Exam 1310
Exam 1410
Exam 1510
Exam 1610
Exam 1710
Exam 1810
Final Exam89
Total Points:268

Related Articles

Follow Us Online
  • Follow us on FaceBook Follow us on Twitter Follow us on YouTube
UniversalClass.com
© Copyright 1999-2020 Universal Class™ All rights reserved.