Audience
The audience for this course includes End Users and Database Administrators. Learners should have prerequisite knowledge of database concepts including tables fields and records. In addition learners should have taken the first course in the series (13889).
Objective
- Identify the types of formulas and functions that are used in building reports and creating links.
- Insert and format sections in a report.
- Insert and customize Crosstab objects.
- Identify the procedures for creating maps and using Map Analyzer to zoom order map layers and resolve data mismatches.
- Identify how to use charts in reports.
Topics Include
Unit 1: Formulas and Links
- Match the types of Crystal Reports formulas with the situations in which they are used.
- Match Mathematical functions with the situations in which they are used.
- Match String functions with the situations in which they are used.
- Match Date/Time functions with the situations in which they are used.
- Match Programming shortcut functions with the situations in which they are used.
- Create a formula by using Formula Editor.
- Create a report alert by using the Report menu.
- Add data from a database to a report by using the menu bar.
- Link database tables by using the Visual Linking Expert window.
- Create a dictionary by using the Crystal Reports Tools menu.
- Create a SQL query by using the Create SQL Expert dialog box.
Unit 2: Sections and Cross-Tab Objects
- Insert a section in a report by using the Insert menu.
- Identify the properties used to format a section according to specific requirements.
- Create a cross-tab object in a report by using the Insert menu.
- Identify the options used to customize a cross-tab object according to specific requirements.
Unit 3: Maps and Charts
- Match the types of maps with the situations in which they are most appropriate.
- Create a map by using the Map Expert dialog box.
- Arrange the layers in a map in the specified order by using the Layer Control dialog box.
- Resolve data mismatches by using the Map Region Resolver dialog box.
- Match the types of charts with the situations in which they are used.
- Create a chart by using the Chart Expert dialog box.
- Identify the chart-formatting tab that is used to meet a specified requirement.
Duration
8
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
The network version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
CDROM
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada