Course Syllabus

 

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 is 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


  • Completely Online
  • Self-Paced
  • Printable Lessons
  • Full HD Video  
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 

Learning Outcomes

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

Assessment Guide

Assessment Points
Course Introduction and Goals 1 points
Exam 1 10 points
Exam 2 10 points
Exam 3 9 points
Exam 4 10 points
Exam 5 10 points
Exam 6 10 points
Exam 7 10 points
Exam 8 10 points
Exam 9 10 points
Exam 10 10 points
Exam 11 10 points
Exam 12 10 points
Exam 13 10 points
Exam 14 10 points
Exam 15 10 points
Exam 16 10 points
Exam 17 10 points
Exam 18 10 points
Final Exam 89 points
Ultimate Excel Training Bundle
Ultimate Excel Training Bundle
Microsoft Word Courses
Microsoft Word Courses
Microsoft Office 2021: Word, Excel, PowerPoint and Outlook
Microsoft Office 2021: Word, Excel, PowerPoint and Outlook
How to Work with Items (Products and Services) in QuickBooks Online Version
How to Work with Items (Products and Services) in QuickBooks Online Version
Advanced Excel 2019
Advanced Excel 2019
Business Writing Courses
Business Writing Courses
QuickBooks Courses
QuickBooks Courses
How to Track Time and Mileage in QuickBooks Online
How to Track Time and Mileage in QuickBooks Online
Google Docs
Google Docs
Microsoft Publisher 2021
Microsoft Publisher 2021
Operations Management Courses
Operations Management Courses
How to Use the IF Function in Excel 2019
How to Use the IF Function in Excel 2019
How to Maintain Worksheets in Excel 2016
How to Maintain Worksheets in Excel 2016
Microsoft Excel Courses
Microsoft Excel Courses
Microsoft Project 2021
Microsoft Project 2021
How to Start Using VBA in Excel 2019
How to Start Using VBA in Excel 2019
How to Import Media and Audio into Adobe Captivate
How to Import Media and Audio into Adobe Captivate
Communications Courses
Communications Courses