Applications TrainingCourses > Applications Training

Crystal Reports XI Basic

 

 

Duration

 

2 days

 

 

Course Overview

 

Crystal Reports XI: Basic is the primary recommended course you should take if your job responsibilities require you to obtain output from databases. It is also the first course in the Crystal Reports XI series. In this course, you will build basic list and group reports that work with almost any database.

 

 

Target Audience

 

This course is designed for a person who needs output from a database. In some cases, database programs have limited reporting tools, and/or they may not have access to those tools. Students may or may not have programming and/or SQL experience.

 

 

Prerequisites

 

Before taking this course, students should be familiar with the basic functions of Windows, such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files. In addition, students should have taken Microsoft Office Access 2003: Level 1 or have equivalent experience with basic database concepts.

 

 

Course Objectives

 

Upon successful completion of this course, students will be able to:

 

·                Create a report by using data from an existing database.

·                Use a report to present specific data in the desired order.

·                Create groups to summarize report data.

·                Build formulas to calculate and display data.

·                Format reports.

·                Add and modify elements in a report.

·                Create single data series charts.

·                Distribute report data.

 

 

Course Content

 

Getting started

·                The Crystal Reports environment

·                Creating, viewing, and saving reports

·                Modifying report layout

·                The Help feature

 

Formatting

·                Absolute formatting

·                Introducing conditional formatting

 

Sorting and selecting records

·                Sorting records

·                Selecting records

 

Grouping and summarizing

·                Groups

·                Summaries

 

Formulas and functions

·                Formulas

·                Modifying formulas

·                Functions

 

Experts and wizards

·                The Database Expert

·                Report wizards

·                Cross-tab reports

 

Distributing reports

·                Exporting reports

·                Delivering reports

Microsoft Access 2003 Level 2

 

 

 Duration

 

1 day

 

 

Course Overview

 

As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.

 

 

Course Objectives

 

You will design and create a new Access database; improve queries, forms, and reports; and integrate Microsoft Office Access 2003 with other applications.


Target Audience

 

Microsoft Access 2003: Level 2 is designed for the student who wishes to learn intermediate-level operations of the Microsoft Access program. The Level 2 course is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft Word or Excel. This course is also designed for students pursuing the Microsoft Office Specialist Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.

 

 

Course Contents

 

Reports

Purpose of a Report

Creating a Report

Creating an Autoreport

Amending Report Design

 

Subforms

Using the Subform Wizard

Using an Existing Form as a Subform

Using the Form Wizard

 

Enhancing Form Presentation

Adding and Deleting Controls

Adding Text Labels

Changing Properties

Tab Order

Adding Command Buttons

 

Action Queries

Make Table Query

Calculated Fields in Queries

Using the Expression Builder

 

Parameter Queries

Microsoft Access 2003 VBA

 

 

Duration

 

2 days

 

 

Prerequisites

 

Delegates should have attended the appropriate introductory and advanced courses plus have several weeks of practice. No programming experience is required.

 

 

Course Content

 

Module 1

•           Getting Started

•           Introduction to Programming in Access

•           Why Program in Access?

•           Understanding the Development Environment

•           Using Visual Basic Help

 

Module 2

•           Working with Procedures and Functions

•           Understanding Modules

•           Creating a Standard Module

•           Understanding Procedures

•           Creating a Sub Procedure

•           Calling Procedures

•           Using the Immediate Window to Call Procedures

•           Creating a Function Procedure

•           Naming Procedures

•           Organizing Code and Procedures

•           Working with the Code Editor

 

Module 3

•           Understanding Objects

•           Understanding Classes and Objects

•           Navigating the Access Object Hierarchy

•           Understanding Collections

•           Using the Object Browser

•           Working with the Application Object

•           Understanding the Form Object

•           Working with Properties

•           Using the With Statement

•           Working with Methods

•           Understanding the DoCmd Object

•           Working with Events

•           Understanding the Order of Events

 

Module 4

•           Using Expressions, Variables, and Intrinsic Functions

•           Understanding Expressions and Statements

•           Declaring Variables

•           Understanding Data Types

•           Working with Variable Scope

•           Working with Variable Lifetime

•           Considering Variable Scope and Lifetime Together

•           Using Intrinsic Functions

•           Understanding Constants

•           Using Intrinsic Constants

•           Using Message Boxes

•           Using Input Boxes

 

Module 5

•           Controlling Program Execution

•           Understanding Control-of-Flow Structures

•           Working with Boolean Expressions

•           Using the If...End If Decision Structures

•           Using the Select Case...End Select Structure

•           Using the For...Next Structure

•           Using the For Each...Next Structure

•           Using the Do...Loop Structure

•           Guidelines for use of Branching Structures

 

Module 6

•           Working with Recordsets

•           Declaring and Creating Object Variables

•           Working with the ADODB Recordset Object

•           Specifying a Recordset Cursor Type

•           Locking Records for Updating

•           Specifying a Recordset Cursor Location - Optional

•           Using the CacheSize Property - Optional

•           Understanding Recordset Cursor Properties - Optional

 

Module 7

•           Debugging Code

•           Understanding Errors

•           Using Debugging Tools

•           Setting Breakpoints

•           Setting Break Expressions

•           Using Break Mode during Run Mode

•           Stepping through Code

•           Determining the Value of Expressions

 

Module 8

•           Handling Errors

•           Understanding Error Handling

•           Understanding VBA's Error Trapping Options

•           Trapping Errors with the On Error Statement

•           Understanding the Err Object

•           Writing an Error-Handling Routine

·            Working with Inline Error Handling

Microsoft Excel 2003 Level 1

 

 

Duration

 

1 day

 

 

Course Overview

 

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft Office Excel 2003 to manage, edit, and print data.

 

 

Target Audience

 

This course is designed for delegates who wish to gain the skills necessary to create, edit, format, and print basic Microsoft Excel 2003 worksheets.

Course Objectives

 

Upon successful completion of this course, students will be able to:

·                Create a basic worksheet.

·                Modify a worksheet.

·                Perform calculations.

·                Format a worksheet.

·                Develop a workbook.

·                Print the contents of a workbook.

·                Customize the layout of the Excel window.

 

 

Course Contents

 

The Excel Screen

The Concepts of Excel

 

Moving and Selecting Cells

Entering and Deleting Data

Changing Widths of Columns & Rows

Saving and Closing Workbooks

Creating and Opening Workbooks

 

Editing Data

Using Number Styles

Moving and Copying Data

Inserting Cells, Rows and Columns

 

Understanding Data Series

Creating a Data Series

Dates, Days and Months

Custom Lists

Fill Handle, Cross Hair

Menu Methods

 

Basic Formula

Add, Subtract, Multiply and Divide

Equal to – Not Equal To

Greater Than – Less Than

Mouse Methods

Keyboard Methods

AutoSum

 

Percentages