Microsoft Office TrainingCourses > Microsoft Office 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.This course is available on our new V-Learning platform or as an onsite/closed event.  Please call for details.

 

 

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.This course is available on our new V-Learning platform or as an onsite/closed event.  Please call for details.

 

 

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 VBA

 

 

Duration

 

1 day

 

 

Course Overview

 

In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development.

You will use VBA to create macros for automating repetitive tasks in Excel 2003. This course is available on our new V-Learning platform or as an onsite/closed event.  Please call for details.

 

 

Target Audience

 

Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data

 

 

Course Content

 

Visual Basic Editor

•      Visual Basic for Applications

•      Object Programming

•      The Object Browser

 

Programming basics

•      Data

•      Scope of variables

•      Scope of procedures

 

Control structures

•      Decision structures

•      Loop structures

 

Custom dialog boxes

•      User forms

•      Events

 

Debugging and error-handling

•      Errors

•      Debugging

•      Error-handling

 

 

What did attendees think of the course?

 

"The training was excellent and very well presented" - A.W. Operations Intelligence Analyst