Office Programming Using Visual Basic for Applications

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  • Run macros and explain the basics of a Visual Basic Module.
  • Create relative and absolute recorded macros and assign macros to various objects in a workbook.
  • Write procedures that test conditions and then run only certain statements based on the results.
  • Write procedures that execute one or more lines of code repetitively.
  • Store Excel macros so they are available in any workbook.
  • Create macros in Word 2000.
  • Create macros that interact with the user.

Course content

Lesson 1: Introduction to Visual Basic for Applications

  • Running a macro
  • Recording a macro
  • Examining module design

Lesson 2: Assigning macros

  • Specifying the location of recorded macros
  • Assigning macros to menus, buttons, and toolbars

Lesson 3: Creating decision-making code

  • The If…Then decision structure
  • The If…Then…Else decision structure
  • The Select Case decision structure

Lesson 4: Using loop structures

  • Using a For…Next statement
  • Using a Do…Loop statement
  • Using a For Each…Next statement

Lesson 5: Macro management

  • Personal Macro Workbook
  • Assigning Sub procedures to run automatically

Lesson 6: Recording a macro in Word 2000

  • Running a macro
  • Recording a macro

Lesson 7: Interactive macros

  • Creating a custom message box
  • Creating a custom input box
  • Extracting data from Excel


PageMaker Basics

Lesson 1: Navigating in PageMaker

PageMaker Environment Elements

Navigating

Topic title

Lesson 2: Creating a Document

Document Setup

Saving

Using Text

Using Graphics

Importing Graphics

Lesson 3: Multi-Page Documents

Document Setup

Master Pages

Inserting Pages

Working with Text

Lesson 4: Working with Frames

Creating Frames

Placing Text within Frames

Lesson 5: Formatting Text

Character Formatting

Paragraph Formatting

Topic title

Lesson 6: Graphics

Importing Graphics

Text Wrap

Attaching Text to a Frame

Copying Items Between Documents

Printing


PageMaker Type Design

Lesson 1: Creating a Document

Preferences

Creating Automatic Page Numbers

Lesson 2: Using Styles

Applying Styles

Basing One Style on Another

Reverse Text Styles

Lesson 3: Adobe Table

Typing and Importing Text

Table Formatting

Text Formatting

Cell Borders and Shading

Exporting Tables

Embedding and Linking Tables

Lesson 4: The Story Editor

Checking Spelling

Changing Text

Lesson 5: Typography Techniques

Line Length

Choosing Typefaces

Paragraph Spacing

Hyphenation and Justification

Kerning

Tracking

Editing Tracking

Lesson 6: Type Effects

Pull Quotes

Drop Caps

Text Shadows

Horizontal Scale

Force Justify

Baseline Offset

Lesson 7: Tables of Contents

Marking Text

Creating a Table of Contents

PageMaker Production I

Course content

Lesson 1: Creating Templates

  • The Grid Manager Plug-In
  • Using Frames in Templates
  • Layers
  • Multiple Master Pages

Lesson 2: Using Templates

  • Using Text In a Template
  • Using Graphics In a Template

Lesson 3: Working with Graphics

  • Drawing Graphics
  • Manipulating Graphics

Lesson 4: Color

Lesson 5: Defining Colors

  • Applying Colors
  • Creating a Color Library

Lesson 6: Graphic Formats

  • Vector Graphics
  • Raster Graphics
  • Saving a Page as a Graphic

Lesson 7: Contrast and Halftones

Lesson 8: Printing

  • Linking Graphics
  • Publication Info
  • Printing Color Separations and Proofs
  • Sorting Pages
  • Building a Booklet
 

Adobe PageMaker 6.5: Production 2 (Windows 95)

Part #: 050 397

Course length: 1 day


Course content

Lesson 1: Document Setup

  • Structuring Your Document
  • Transforming Graphics
  • Colors
  • HTML Import
  • Scripts
  • Index and TOC

Lesson 2: Color Management

  • Setting Up a Color Management System
  • CMS Preferences
  • PageMaker Colors
  • Imported Image Profiles
  • Choosing Device Profiles When Printing

Lesson 3: Trapping

  • Trapping Overview
  • Performing Traps

Lesson 4: Advanced Printing

  • Printer Styles
  • Save for Service Provider Plug-In

Lesson 5: Electronic Publishing

  • Defining Purpose
  • Hyperlinks
  • Automatic Layout Adjustment

Lesson 6: Creating Acrobat PDF Files

  • Exporting PDF Files
  • PDF Options
  • Control Dialog Box
  • Viewing the PDF File

Lesson 7: HTML Export

  • HTML Overview
  • Modifying Publications for HTML
  • Exporting to HTML
 

PageMaker Production II

Course content

Lesson 1: Document Setup

  • Structuring Your Document
  • Transforming Graphics
  • Colors
  • HTML Import
  • Scripts
  • Index and TOC

Lesson 2: Color Management

  • Setting Up a Color Management System
  • CMS Preferences
  • PageMaker Colors
  • Imported Image Profiles
  • Choosing Device Profiles When Printing

Lesson 3: Trapping

  • Trapping Overview
  • Performing Traps

Lesson 4: Advanced Printing

  • Printer Styles
  • Save for Service Provider Plug-In

Lesson 5: Electronic Publishing

  • Defining Purpose
  • Hyperlinks
  • Automatic Layout Adjustment

Lesson 6: Creating Acrobat PDF Files

  • Exporting PDF Files
  • PDF Options
  • Control Dialog Box
  • Viewing the PDF File

Lesson 7: HTML Export

  • HTML Overview
  • Modifying Publications for HTML
  • Exporting to HTML

 

PageMaker Type Design

Course content

Lesson 1: Creating a Document

  • Preferences
  • Creating Automatic Page Numbers

Lesson 2: Using Styles

  • Applying Styles
  • Basing One Style on Another
  • Reverse Text Styles

Lesson 3: Adobe Table

  • Typing and Importing Text
  • Table Formatting
  • Text Formatting
  • Cell Borders and Shading
  • Exporting Tables
  • Embedding and Linking Tables

Lesson 4: The Story Editor

  • Checking Spelling
  • Changing Text

Lesson 5: Typography Techniques

  • Line Length
  • Choosing Typefaces
  • Paragraph Spacing
  • Hyphenation and Justification
  • Kerning
  • Tracking
  • Editing Tracking

Lesson 6: Type Effects

  • Pull Quotes
  • Drop Caps
  • Text Shadows
  • Horizontal Scale
  • Force Justify
  • Baseline Offset

Lesson 7: Tables of Contents

  • Marking Text
  • Creating a Table of Contents

 

Microsoft Publisher

 

Course content

Lesson 1: The Publisher Environment

  • Creating a Document

Lesson 2: Creating a Document

  • Creating the Basic Layout
  • Text Frames
  • Picture Frames

Task 2C-1: Importing a Graphic

Lesson 3: MultiPage Documents

  • Creating a Multi-Page Document
  • Using the Background
  • Adding Text to Your Document

Lesson 4: Formatting Text

  • Character Formatting
  • Paragraph Formatting
  • Formatting Shortcuts
  • Indents

Lesson 5: Graphics and Final Touches

  • Using Graphics
  • Finishing the Document
  • Printing

PowerPoint Level 1

Performance-Based Objectives

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

  • manipulate an existing PowerPoint presentation.

  • begin creating a presentation.

  • format text slides.

  • add tables to a presentation.

  • chart data in a presentation.

  • modify objects on slides.

  • add images to a presentation.

  • prepare to deliver a presentation.


 

Course Content

 

Lesson 1: An Orientation to PowerPoint

Topic 1A: The PowerPoint Environment

Topic 1B: Orientation to Views

Topic 1C: Navigate Through a Presentation

Topic 1D: Edit Slide Text

Topic 1E: Save the Presentation

Topic 1F: Run a Slide Show

 

Lesson 2: Beginning a Presentation

Topic 2A: Create a New Presentation

Topic 2B: Change Background Color

Topic 2C: Add Slides to a Presentation

Topic 2D: Enter Text

Topic 2E: Create a Presentation from a Microsoft Word Outline

 

Lesson 3: Formatting Text Slides

Topic 3A: Apply Character Formats

Topic 3B: Align Text

Topic 3C: Change Line Spacing

Topic 3D: Change Indents

 

Lesson 4: Adding Tables to a Presentation

Topic 4A: Create a Table

Topic 4B: Format Tables

Topic 4C: Insert a Table from Microsoft Word

 

Lesson 5: Charting Data

Topic 5A: Create a Column Chart

Topic 5B: Edit Chart Data

Topic 5C: Change Chart Type

Topic 5D: Insert a Chart from Microsoft Excel

 

Lesson 6: Modifying Objects

Topic 6A: Resize Objects

Topic 6B: Copy and Duplicate Objects

Topic 6C: Move Objects

Topic 6D: Changing Object Orientation

Topic 6E: Format Objects

Topic 6F: Group and Ungroup Objects

Topic 6G: Change the Order of Objects

 

Lesson 7: Adding Images to a Presentation

Topic 7A: Add Clip Art

Topic 7B: Add a Picture from a File

Topic 7C: Draw Lines and Shapes

Topic 7D: Insert WordArt

 

Lesson 8: Preparing to Deliver a Presentation

Topic 8A: Spell Check

Topic 8B: Arrange Slides

Topic 8C: Add Transitions

Topic 8D: Create Speaker Notes

Topic 8E: Send a Presentation to Microsoft Word

Topic 8F: Print the Presentation

Topic 8G: Package a Presentation for CD

 

Appendix A: Microsoft Office Specialist Program

 


PowerPoint Level 2

 

Performance-Based Objectives

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

  • create a design template.

  • create organization charts and diagrams.

  • add special effects to a Microsoft® Office PowerPoint® 2003 slide.

  • create a Web-based Microsoft® Office PowerPoint® 2003 presentation.

  • use a Microsoft® Office PowerPoint® 2003 presentation for collaborative workgroup review.

  • use functionality that will enable you to deliver live, self-service, and online presentations.


 

Course Content

 

Lesson 1: Creating a Custom Design Template

Topic 1A: Define Design Template Characteristics

Topic 1B: Create a Custom Color Scheme

Topic 1C: Set Up a Slide Master

Topic 1D: Format Custom Bullets

Topic 1E: Add a Footer

Topic 1F: Modify the Notes Master

Topic 1G: Save a Custom Design Template

 

Lesson 2: Adding Organization Charts and Diagrams

Topic 2A: Working with Organization Charts

Topic 2B: Update an Organization Chart

Topic 2C: Applying a Chart Layout

Topic 2D: Create a Diagram

Topic 2E: Draw a Flowchart

 

Lesson 3: Adding Special Effects

Topic 3A: Add Sound and Movies

Topic 3B: Add Animation

Topic 3C: Emphasize Objects

Topic 3D: Set a Motion Path

Topic 3E: Set the Order of Effects

 

Lesson 4: Creating Web Presentations

Topic 4A: Create a Group Home Page with the AutoContent Wizard

Topic 4B: Hyperlink to a Web Page

Topic 4C: Publish as a Web Page

 

Lesson 5: Collaborating in PowerPoint

Topic 5A: Set Password Protection

Topic 5B: Work with Comments

Topic 5C: Send a Presentation for Review

Topic 5D: Merge Revision Copies

Topic 5E: Apply Reviewer Changes

 

Lesson 6: Delivering a Presentation

Topic 6A: Hyperlink Within PowerPoint

Topic 6B: Add an Action Button

Topic 6C: Set Up a Custom Show

Topic 6D: Annotate a Presentation

Topic 6E: Working with Narrations and Slide Timings

Topic 6F: Set Up a Slide Show to Repeat Automatically

 

Appendix A: Microsoft Office Specialist Program

SharePoint Portal Server 2003 Site Development and Customization in the .NET Framework

 Take your information sharing solution experience out of the box and into the real world

 Do your customers’ unique needs require fast and effective collaborative solutions beyond what standard information sharing products offer?  This intense technical two-day workshop presents skills, insights, and tools needed to design, build, and manage highly customized information sharing solutions using SharePoint Portal Server 2003 in the context of the .NET Framework.

 ABOUT THE TRAINING:

Students attending this workshop will learn how to create powerful, custom ASP .NET Web applications, ASP .NET Web Services, and .NET Windows-based Applications that utilize the Microsoft SharePoint Portal Server 2003 (SPS) and Windows SharePoint Services (WSS) .NET assemblies.  The hands-on exercises also illustrate how to develop, test, and deploy customized SharePoint portal sites using Visual C# or Visual Basic .NET.

 

TARGET AUDIENCE:

This course is intended primarily for Software Developers.

 

PREREQUISITES:

All students should have a basic understanding of the .NET framework, and be comfortable using Visual Studio.NET, in either C# or Visual Basic.NET.  It is recommended that students be familiar with application development in ASP.NET, and that students have a fundamental understanding of SharePoint Portal Server 2003.

COURSE AGENDA:
The course material is presented over a two-day period covering the following topics:

 

DAY 1

Morning

 

Afternoon

 DAY 2

Morning

Afternoon

 

Building and Deploying Collaboration Solutions with SharePoint Products & Technologies

 

Communicate.  Collaborate.  Grow.

 

In today’s fast-paced, information-driven society, the ability to quickly and efficiently share information has become a valuable commodity.  This technical two-day workshop presents skills, insights, and tools IT professionals need to create Windows SharePoint Server 2003 Communication and Collaboration solutions, which give their companies the collaborative, competitive edge, increasing internal productivity, and driving the business forward through cooperative action.

ABOUT THE TRAINING:

Students attending this workshop will learn how to utilize the Microsoft SharePoint Portal Server 2003 (SPS) and Windows SharePoint Services (WSS) engine to create and administer Internet-based sites which expand the paradigm of information sharing while simultaneously focusing individual users to the tasks at hand.  The hands-on exercises reinforce these concepts, allowing students to create, administer, and personalize SharePoint content.

 

TARGET AUDIENCE:

This course is intended primarily for IT professionals responsible for creating collaborative solutions.

 

PREREQUISITES:

All students should have a comfortable understanding of Windows 2003, particularly in the area of file/folder permissions.  Students should also be familiar with website administration.

COURSE AGENDA:
The course material is presented over a two-day period covering the following topics:

 

DAY 1 – Server Administration

 

Morning  SPS & WSS Overview

What is WSS?

WSS vs. SPS

Deployment Scenarios and Guidelines

 

Afternoon  SPS & WSS Administration

SharePoint Central Administration

Navigation in the WSS Interface

Site and Area Creation

Site and Area Security

 

DAY 2 – Content Administration

 

Morning – List Administration

List Creation

Uploading and Managing Document Lists with Office 2003

Securing Content

 

Afternoon – Content Personalization

Publishing Content

Search / Indexing

Web Parts Overview