HomeAbout UsServicesClassesWhy PC FocusOn-Site TrainingContact UsSite Map
Microsoft Office Crystal Reports Project Management Accounting Database Development Sales CRM

Vista
&
Office 2007

Training is now available.  Call for more information.

717.396.9881

Custom CRM

$100 off if you order by September 31, 2007

PC Focus has a new product called Project Links.  More . . .

Call today for a free demonstration.

WBT
Web Based Training

Learning Methods.  See sample WBT and view one of the training methods that PC Focus delivers.  More...

Focused
Learning

What is focused learning?  Find out how this type of training can make you more productive - fast!!  More....

 

 

Using Microsoft Office 2003

Course Offerings, Descriptions & Cost

 

Class Name

Link to Class Description

Cost

Excel Level 1

Excel 2003 Level 1

See table for prices

Excel Level 2

Excel 2003 Level 2

Excel Level 3

Excel 2003 – Level 3

Excel Intro to Intro to VB

Excel Level 4 - Introduction to Visual Basic

Excel Productivity Tools

Excel Productivity Tools    New

Word – Level 1

Word – Level 1

Word – Level 2

Word – Level 2

Word – Level 3

Word – Level 3

PowerPoint- Level 1

PowerPoint- Level 1

PowerPoint- Level 2

PowerPoint- Level 2

Access- Level 1

Access- Level 1

Access- Level 2

Access- Level 2

Access- Level 3

Access- Level 3

Outlook 2003 Level 1

Outlook - Level 1

Outlook 2003 Level 2

Outlook - Level 2

FrontPage 2003 Level 1

FrontPage - Level 1

Project – Level 1

Project – Level 1

Project – Level 2

Project – Level 2

 

Experience our new 2-hour “Focused Learning” Classes.

 

The following classes are specific topics taken from our full day classes.  The benefits of these types of classes are that people can pick and choose topics that are applicable to them and their respective jobs.  The full day classes cover many topics and these are “topic” specific or “focused” on one topic.  These classes are designed for people with good Window and overall computer skills.  There is NO enrollment limit up to 15 people.

 

Excel Formulas

Formulas

$650/session

Excel Charts

Charts

$650/session

Excel Pivot Tables

Pivot Tables

$650/session

Excel Macros - Basics

Macros

$650/session

Excel Database Mgmt

Database Mgmt

$650/session

Word Mail Merge & Styles

Word Mail Merge & Styles

$650/session

Access Tables

Access Tables

$650/session

Access Queries

Access Queries

$650/session

Access Reports

Access Reports

$650/session

Outlook Tips & Shortcuts

Outlook Tips & Shortcuts

$650/session

Putting Pizzazz in PowerPoint Presentations

PowerPoint Pizzazz

$650/session

 


 

 

 

Focused Learning - Excel Pivot Tables – 2 hours

  • Understanding Pivot Tables

  • Examining a pivot table

  • Creating a pivot table by using the Pivot Table Wizard

    • Adding a field to a pivot table

    • Deleting a field from a pivot table

    • Using the pivot table

    • Changing the organization of data in a pivot table

  • Subtotal summary functions

  • Refreshing Linked data to the pivot table from the source data

  • Creating a pivot chart

    • Changing the organization of data in a pivot chart

 

Focused Learning - PowerPoint – Putting Pizzazz in Presentations – 2 hours

Tips and Shortcuts

  • Putting Pizzazz in your presentations

    • Design Templates

      • Custom templates

    • Color Schemes

    • Diagram Gallery

    • Interactive Slides

      • Action Buttons

    • Hyperlinks

    • Custom Animation

    • Slide Transitions

    • Using WinZip

    • Presentation “Shows”

    • Package to CD

Focused Learning - Word Mail Merge & WordArt – 2 hours

  • Creating a Mail Merge Document

  • Creating a data source and removing fields from the header row

    • Adding a new field and renaming an existing one

    • Completing the Data Source 

  • Complete a Main Document

    • Inserting Merge field and text into the main document

  • Merging the Data Source with the main document

  • Sorting and Filtering Merges 

    • Sorting a Data Source 

    • Sorting a data source using query options

    • Selecting Specific Data for the Merge 

    • Filtering Data in Mail Merge 

    • Clearing Query Options 

  • Using Outlook Contacts to Create Mailing Labels and letters

  • Creating WordArt

  • Modify WordArt using the WordArt toolbar

Focused Learning - Outlook 2003 – Tips and Shortcuts – 2 hours

  • Mail merge using Outlook

  • Contacts

    • v-cards

    • activities w/contacts

    • distribution lists

    • importing contact lists

    • exporting contact lists

  • Calendar

    • multiple calendars

    • sharing calendars

    • color-code events/meetings, etc.

    • viewing schedules of invitees

    • rescheduling events/meetings

  • Mail

    • color-code incoming mail

    • creating rules for filtering mail

    • Outlook Today (customizing Outlook desktop)

 Focused Learning - Excel Macros - 2 hours

This session is designed for an Excel user who wants to maximize Excel.  We will learn how to create and edit macros.  Visual Basic will be covered since it is the programming language that macros are stored in.  We will also write some routines in the VB editor.  We will test and edit (debug) our code.     We will also learn how to create a Macro Toolbar to make executing macros much faster.  Tips and shortcuts will be used throughout the class.

 

Focused Learning - Charts - 2 hours

This session is designed for an Excel user who wants to go beyond the basics of worksheet setup and design and learn about charting.  We will create and modify all types of charts from column to pie charts.  You will learn how to create a chart using the Chart Wizard and on the fly.  We also link charts with PowerPoint & Word. Everything you want to know about charts will be covered in this class.  Tips and shortcuts will be used throughout the class.

 

Focused Learning - Database Management - 2 hours

This session is designed for an Excel user who wants to go beyond the basics of worksheet setup and design and learn how to use Excel to manage lists of all kinds.  You will learn how to sort and filter the lists.  You will also learn how to create how to manage auto filters and advanced filters using select criteria.  If you work with any type of list this is the Excel class for you.  Tips and shortcuts will be used throughout the class.

 

Focused Learning - Formulas - 2 hours

This session is designed for an Excel user who wants to learn more about formulas.  We will learn how to write If statements and create look up tables.  Also we will learn various editing formulas which will save time and redundancy in entering data.  There are many “Formula Helpers” to be considered when creating and using formulas.  .  Tips and shortcuts will be used throughout the class.

Focused Learning - Access Tables – 2 hours

Establishing Table Relationships

  • Identify Table Relationships

  • Identify Primary and Foreign Keys in the Relationships Window

  • Work with Subdatasheets

Focused Learning - Access Queries – 2 hours

Querying the Database

  • Create a Select Query

  • Add Criteria to a Query

  • Add a Calculated Field to a Query

  • Perform a Calculation on a Record Grouping

Focused Learning - Access Reports – 2 hours

Producing Reports

  • Create an AutoReport

  • Create a Report by Using the Wizard

  • Examine a Report in Design View

  • Add a Calculated Field to a Report

  • Modify the Format Properties of a Control

  • AutoFormat a Report  and Adjust the Width of a Report

 

Microsoft® Office Outlook® 2003: Level 1

Course Description

This course is the first in a series of three Microsoft® Office Outlook® courses. It will provide you with the skills you need to start sending and responding to email in Microsoft® Outlook® 2003, as well as maintaining your Calendar, scheduling meetings, and working with tasks and notes.

Performance-Based Objectives

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

  • identify the components of the Outlook environment and compose and respond to a simple message.

  • compose messages.

  • use folders to manage mail.

  • schedule appointments.

  • schedule meetings.

  • manage contacts and contact information.

  • create and edit tasks.

  • create and edit notes.

Course Content

Lesson 1: Getting Started with Outlook

Topic 1A: Log On to Outlook

Topic 1B: The Outlook Environment

Topic 1C: Compose and Send a Simple Message

Topic 1D: Open a Message

Topic 1E: Reply to a Message

Topic 1F: Print a Message

Topic 1G: Delete a Message

Lesson 2: Composing Messages

Topic 2A: Address a Message

Topic 2B: Format a Message

Topic 2C: Check Spelling and Grammar

Topic 2D: Attach a File

Topic 2E: Forward a Message

Lesson 3: Managing Mail

Topic 3A: Open and Save an Attachment

Topic 3B: Flag a Message

Topic 3C: Create a Folder

Topic 3D: Move Messages to a Folder

Topic 3E: Copy Messages to Folders

Topic 3F: Delete a Folder

Lesson 4: Scheduling Appointments

Topic 4A: The Outlook Calendar

Topic 4B: Schedule an Appointment

Topic 4C: Assign a Category to an Appointment

Topic 4D: Update Calendar Entries

Lesson 5: Scheduling Meetings

Topic 5A: Schedule a Meeting

Topic 5B: Reply to a Meeting Request

Topic 5C: Propose a New Meeting Time

Topic 5D: Track Meeting Responses

Topic 5E: Update a Meeting Request

Topic 5F: Cancel a Meeting Request

Topic 5G: Print the Calendar

Lesson 6: Managing Contacts

Topic 6A: Add a Contact

Topic 6B: Sort Contacts

Topic 6C: Find a Contact

Topic 6D: Generate a Map

Topic 6E: Edit a Contact

Topic 6F: Delete a Contact

Topic 6G: Print Contacts

Lesson 7: Managing Tasks

Topic 7A: Create a Task

Topic 7B: Edit a Task

Topic 7C: Update a Task

Lesson 8: Using Notes

Topic 8A: Create a Note

Topic 8B: Edit a Note

Topic 8C: Copy a Note

Appendix A: Microsoft Office Specialist Program

Microsoft® Office Outlook® 2003: Level 2

Course Description

If you have been using Microsoft® Office Outlook® 2003 as a communications tool, then you know how to send a mail message; schedule appointments and meetings; and create contacts, tasks, and notes. This course is the second in a series of three Microsoft Outlook courses. It provides you with the necessary skills to customize your Outlook environment, your calendar, and your mail messages so that they meet your specific needs. You will also learn how to track, share, assign, and quickly locate various Outlook items.

Performance-Based Objectives

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

  • track work activities using the Outlook Journal.

  • customize the calendar by setting various calendar options.

  • modify message options.

  • make folder information available to other Outlook users.

  • assign and track tasks.

  • customize the Outlook environment.

  • sort, find and color-code items in your mailbox and calendar.

Course Content

Lesson 1: Tracking Work Activities Using the Journal

Topic 1A: Record a Journal Entry Automatically

Topic 1B: Manually Record a Journal Entry

Topic 1C: Modify a Journal Entry

Lesson 2: Setting Calendar Options

Topic 2A: Set Work Days and Times

Topic 2B: Display Other Time Zones

Topic 2C: Set Free/Busy Options

Lesson 3: Setting Message Options

Topic 3A: Modify Message Settings

Topic 3B: Modify Delivery Options

Topic 3C: Modify Message Formats

Topic 3D: Notify Others that You will be Out of the Office

Topic 3E: Create and Modify a Distribution List

Topic 3F: Insert a Hyperlink

Lesson 4: Sharing Folder Information

Topic 4A: Specify Folder Permissions

Topic 4B: Access Another User's Folder

Topic 4C: Delegate Access To Folders

Lesson 5: Managing Tasks

Topic 5A: Assign a Task

Topic 5B: Reply to a Task Request

Topic 5C: Send a Task Update

Topic 5D: Track Assigned Tasks

Lesson 6: Customizing Outlook

Topic 6A: Customize the Toolbar

Topic 6B: Create a New Toolbar

Topic 6C: Customize the Menu

Topic 6D: Create a Folder Home Page

Lesson 7: Locating Outlook Items

Topic 7A: Sort Messages Using Multiple Criteria

Topic 7B: Find Messages

Topic 7C: Find Messages Using Multiple Criteria

Topic 7D: Filter Messages

Topic 7E: Organize Messages

Topic 7F: Manage Junk Email

Appendix A: Using Public Folders

Excel 2003: Level 1 – 6 hours in full or 2 half-days

Course Description

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.

Course Objective: You will create and edit basic Microsoft® Office Excel 2003 worksheets and workbooks.

Performance-Based 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 Content

Lesson 1: Getting Started with Excel

·         Topic 1A: An Overview of Excel

·         Topic 1B: Navigate in Excel

·         Topic 1C: Select Data

·         Topic 1D: Enter Data

·         Topic 1E: Save a Workbook

·         Topic 1F: Obtain Help

Lesson 2: Modifying a Worksheet

·         Topic 2A: Move and Copy Data Between Cells

·         Topic 2B: Fill Cells with Series of Data

·         Topic 2C: Edit Cell Data

·         Topic 2D: Insert and Delete Cells, Columns, and Rows

·         Topic 2E: Find, Replace, and Go To Cell Data

·         Topic 2F: Spell Check a Worksheet

Lesson 3: Performing Calculations

·         Topic 3A: Create Basic Formulas

·         Topic 3B: Calculate with Functions

·         Topic 3C: Copy Formulas and Functions

·         Topic 3D: Create an Absolute Reference

Lesson 4: Formatting a Worksheet

·         Topic 4A: Change Font Size and Type

·         Topic 4B: Add Borders and Color to Cells

·         Topic 4C: Change Column Width and Row Height

·         Topic 4D: Merge Cells

·         Topic 4E: Apply Number Formats

·         Topic 4F: Create a Custom Number Format

·         Topic 4G: Align Cell Contents

·         Topic 4H: Find and Replace Formats

·         Topic 4I: Apply an AutoFormat

·         Topic 4J: Apply Styles

Lesson 5: Developing a Workbook

·         Topic 5A: Format Worksheet Tabs

·         Topic 5B: Reposition Worksheets in a Workbook

·         Topic 5C: Insert and Delete Worksheets

·         Topic 5D: Copy and Paste Worksheets

·         Topic 5E: Copy a Workbook

Lesson 6: Printing Workbook Contents

·         Topic 6A: Set a Print Title

·         Topic 6B: Create a Header and a Footer

·         Topic 6C: Set Page Margins

·         Topic 6D: Change Page Orientation

·         Topic 6E: Insert and Remove Page Breaks

·         Topic 6F: Print a Range

Lesson 7: Customizing Layout

·         Topic 7A: Split a Worksheet

·         Topic 7B: Arrange Worksheets

·         Topic 7C: Freeze and Unfreeze Rows and Columns

·         Topic 7D: Hide and Unhide Worksheets


 

 Excel 2003: Level 2 - 6 hours in full or 2 half-days

Course Description

In Microsoft® Office Excel 2003: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft® Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Prerequisites: To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft® Excel 2003. Students can obtain this level of skill by taking the following Element K course:

Performance-Based Objectives

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

  • create and apply templates.

  • create and modify charts.

  • work with graphic objects.

  • calculate with advanced formulas.

  • sort and filter data.

  • use Excel with the Web.

Course Content

Lesson 1: Creating and Applying Templates

·         Topic 1A: Create a Workbook from a Template

·         Topic 1B: Create a Custom Template

·         Topic 1C: Working with Comments

·         Topic 1D: Create a Hyperlink

·         Topic 1E: Use Web-based Research Tools

Lesson 2: Creating and Modifying Charts

·         Topic 2A: Create a Chart

·         Topic 2B: Format Chart Items

·         Topic 2C: Change the Chart Type

·         Topic 2D: Create a Diagram

·         Lesson 3: Working with Graphic Objects

·         Topic 3A: Insert Graphics

·         Topic 3B: Create AutoShapes

·         Topic 3C: Format Graphic Objects

·         Topic 3D: Change the Order of Graphic Objects

·         Topic 3E: Group Graphic Objects

·         Topic 3F: Move, Copy, and Resize Graphic Objects

Lesson 4: Calculating with Advanced Formulas

·         Topic 4A: Create and Apply a Name for a Range of Cells

·         Topic 4B: Calculate Across Worksheets

·         Topic 4C: Calculate with Date and Time Functions

·         Topic 4D: Calculate with Financial Functions

·         Topic 4E: Calculate with Statistical Functions

·         Topic 4F: Calculate with Lookup and Reference Functions

·         Topic 4G: Calculate with Logical Functions

Lesson 5: Sorting and Filtering Data

·         Topic 5A: Sort Data Lists

·         Topic 5B: Filter Data Lists

·         Topic 5C: Create and Apply Advanced Filters

·         Topic 5D: Calculate with Database Functions

·         Topic 5E: Add Subtotals to a Worksheet

Lesson 6: Using Excel with the Web

·         Topic 6A: Export Excel Data

·         Topic 6B: Publish a Worksheet to the Web

·         Topic 6C: Import Data from the Web

 


 

Excel 2003: Level 3 – 6 hours in full or 2 half-days

Course Description

You have used Microsoft® Office Excel 2003 to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. In this course, you will do all of these things.

Course Objective: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Prerequisites: To ensure your success, we recommend you first take the following Element K courses or have equivalent knowledge:

  • Microsoft® Office Excel 2003: Level 1

  • Microsoft® Office Excel 2003: Level 2

Performance-based Objectives

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

  • Customize workbooks.

  • Collaborate with others using workbooks.

  • Audit worksheets.

  • Analyze data.

  • Work with multiple workbooks.

  • Import and export data.

  • Structure workbooks with XML.

Course Content

Lesson 1: Streamlining Workflow

·         Topic 1A: Create a Macro

·         Topic 1B: Edit a Macro

·         Topic 1C: Customize Access to Excel Commands

·         Topic 1D: Apply Conditional Formatting

·         Topic 1E: Add Data Validation Criteria

·         Topic 1F: Update a Workbook's Properties

·         Topic 1G: Modify Excel's Default Settings

Lesson 2: Collaborating with Others

·         Topic 2A: Protect Files

·         Topic 2B: Share a Workbook

·         Topic 2C: Set Revision Tracking

·         Topic 2D: Review Tracked Revisions

·         Topic 2E: Merge Workbooks

·         Topic 2F: Adjust Macro Settings

·         Topic 2G: Administer Digital Signatures

Lesson 3: Auditing Worksheets

·         Topic 3A: Trace Cell Precedents

·         Topic 3B: Trace Cell Dependents

·         Topic 3C: Locate Errors in Formulas

·         Topic 3D: Locate Invalid Data and Formulas

·         Topic 3E: Watch and Evaluate Formulas

·         Topic 3F: Group and Outline Data

Lesson 4: Analyzing Data

·         Topic 4A: Create a Trendline

·         Topic 4B: Create Scenarios

·         Topic 4C: Perform What-If Analysis

·         Topic 4D: Develop a PivotTable© Report

·         Topic 4E: Develop a PivotChart© Report

·         Topic 4F: Perform Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

·         Topic 5A: Create a Workspace

·         Topic 5B: Consolidate Data

·         Topic 5C: Link Cells in Different Workbooks

·         Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data

·         Topic 6A: Export to Microsoft Word

·         Topic 6B: Import a Word Table

·         Topic 6C: Import Text Files

Lesson 7: Structuring XML Workbooks

·         Topic 7A: Develop XML Maps

·         Topic 7B: Import, Add, and Export XML Data

·        Topic 7C: Manage XML Workbooks

·         Topic 7D: Apply XML View Options


 

Excel 2003: Level 4 – ‘Introduction to Visual Basic’ – 6 hours in full or 2 half-days

Course Description

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. In Excel 2003: Introduction to VBA you apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks you learned in Excel 2003: Level 1 and Excel 2003: Level 2.

Course Objective: You will use VBA to create macros for automating repetitive tasks in Excel 2003.

Prerequisites: To ensure your success, we recommend you first take the Excel 2003: Level 2 Element K course or have equivalent knowledge.

Performance-Based Objectives

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

  • Develop macros.

  • Format worksheets.

  • Create an interactive worksheet.

  • Work with multiple worksheets.

  • Perform calculations.

Course Content

Lesson 1: Developing Macros

Topic 1A: Create a Macro with the Macro Recorder

Topic 1B: Edit a Macro

Topic 1C: Debug a Macro

Topic 1D: Customize Toolbars, Menus, and Hotkeys

Lesson 2: Formatting Worksheets

Topic 2A: Sort Data

Topic 2B: Insert Rows and Columns

Topic 2C: Insert Text

Topic 2D: Format Text

Topic 2E: Duplicate Data

Topic 2F: Generate a Report

Lesson 3: Creating an Interactive Worksheet

Topic 3A: Determine Dialog Box Type

Topic 3B: Capture User Input

Lesson 4: Working with Multiple Worksheets

Topic 4A: Insert, Copy, and Delete Worksheets

Topic 4B: Rename Worksheets

Topic 4C: Modify the Order of Worksheets

Topic 4D: Print Worksheets

Lesson 5: Performing Calculations

Topic 5A: Create User-defined Functions

Topic 5B: Automate SUM Functions


 

Excel 2003 Productivity Tools  New

Course Description

Course Objective: You will apply visual elements, manipulate large amounts of data efficiently and add  advanced formulas to a worksheet to display data in various formats.

Target Student: The target students for this course are students who desire to gain the skills necessary to create various charts, sort and filter data, analyze data, and work with multiple worksheets and workbooks.

Prerequisites: Good working knowledge of Excel

Performance-Based Objectives

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

·         create and modify charts

·         calculate with advanced formulas

·         sort and filter data

·         analyze data with pivot tables and pivot charts

·         create and run a macro

Course Content

Lesson 1: Creating and Modifying Charts

·         Create a Chart

·         Format Chart Items

·         Change the Chart Type

Lesson 2: Advanced Formulas

·         Create and Apply a Name for a Range of Cells

·         Formula Helpers

·         Editing Functions

·         Calculate with Date and Time Functions

·         Calculate with Financial Functions

·         Calculate with Statistical Functions

·         Calculate with Lookup and Reference Functions

·         Calculate with Logical Functions

Lesson 4: Sorting and Filtering Data

·         Sort Data Lists

·         Filter Data Lists

·         Create and Apply Advanced Filters

·         Calculate with Database Functions

·         Add Subtotals to a Worksheet

Lesson 5: Pivot Tables and Chart Reports

·         Develop a PivotTable© Report

·         Develop a PivotChart© Report

Lesson 6: Creating and Applying Macros

·        Create a Macro

·         Run a Macro


 

Microsoft® Office Word 2003: Level 1 - 6 hours in full or 2 half-days

Course Description

Word processing is the use of computers to create, revise, and save documents for printing and future retrieval. This course is the first in a series of three Microsoft® Office Word 2003 courses. It will provide you with the basic concepts required to produce basic business documents.

Course Objective: You will create, edit, and enhance standard business documents using Microsoft® Office Word 2003.

Target Student: Persons with a basic understanding of Microsoft Windows who need to learn how to use Microsoft® Word 2003 to create, edit, format, lay out, and print standard business documents complete with tables and graphics. This course is intended for persons interested in pursuing Microsoft Office Specialist certification in Microsoft® Word 2003.

Prerequisites: This course assumes that you are familiar with using personal computers and have used a mouse and keyboard (basic typing skills are recommended). You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. One of the following courses or equivalent knowledge is required:

  • Windows XP Professional: Level 1

  • Windows XP Professional: Level 2

  • Windows XP: Introduction

  • Windows 2000: Introduction

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Performance-Based Objectives

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

  • create a basic document.

  • edit documents by locating and modifying text.

  • format text.

  • format paragraphs.

  • use Word tools to make your documents more accurate.

  • add tables to a document.

  • add graphic elements to a document.

  • control a document's page setup and its overall appearance.

Course Content

Lesson 1: Creating a Basic Document

Topic 1A: The Word Environment

Topic 1B: Get Help Using Word

Topic 1C: Enter Text

Topic 1D: Save a New Document

Topic 1E: Preview a Document

Topic 1F: Print a Document

Lesson 2: Editing a Document

Topic 2A: Navigate in a Document

Topic 2B: Insert Text

Topic 2C: Select Text

Topic 2D: Create an AutoText Entry

Topic 2E: Move and Copy Text

Topic 2F: Delete Blocks of Text

Topic 2G: Undo Changes

Topic 2H: Find and Replace Text

Lesson 3: Formatting Text

Topic 3A: Change Font and Size

Topic 3B: Apply Font Styles and Effects

Topic 3C: Change Text Color

Topic 3D: Highlight Text

Topic 3E: Copy Formats

Topic 3F: Clear Formatting

Topic 3G: Find and Replace Text Formatting

Lesson 4: Formatting Paragraphs

Topic 4A: Set Tabs

Topic 4B: Change Paragraph Alignment

Topic 4C: Indent Paragraphs

Topic 4D: Add Borders and Shading

Topic 4E: Apply Styles

Topic 4F: Create Lists

Topic 4G: Change Spacing Between Paragraphs and Lines

Lesson 5: Proofing a Document

Topic 5A: Use the Thesaurus

Topic 5B: Check Spelling and Grammar

Topic 5C: Create a New Default Dictionary

Topic 5D: Check Word Count

Topic 5E: Modify a Document in Print Preview

Lesson 6: Adding Tables

Topic 6A: Create a Table

Topic 6B: Enter Data in a Table

Topic 6C: AutoFormat a Table

Topic 6D: Convert Text into a Table

Lesson 7: Inserting Graphic Elements

Topic 7A: Insert Symbols and Special Characters

Topic 7B: Insert a Clip Art Picture

Topic 7C: Add a Watermark

Lesson 8: Controlling Page Appearance

Topic 8A: Set Page Orientation

Topic 8B: Change Page Margins

Topic 8C: Apply a Page Border

Topic 8D: Add Headers and Footers

Topic 8E: Insert a Page Break


 

Microsoft® Office Word 2003: Level 2 - 6 hours in full or 2 half-days

Course Description

In the first course in this series, Microsoft Word 2003 : Level 1, you gained all the basic skills that you need to create a wide range of standardized business documents. If you use Microsoft® Office Word 2003 on a regular basis, then once you have mastered the basic skills, the next step is to improve your proficiency. To do so, you can customize and automate the way Microsoft® Word 2003 works for you, and you can improve the quality of your work by enhancing your documents with customized Microsoft® Word 2003 elements. In this course, you will increase the complexity of your Microsoft® Word 2003 documents by adding components such as customized lists, tables, charts, and graphics. You will also create personalized Microsoft® Word 2003 efficiency tools.

Course Objective: You will add complexity to Microsoft® Office Word 2003 documents and create personalized efficiency tools in Microsoft® Word 2003.

Target Student: This course was designed for persons who can create and modify standard business documents in Microsoft® Word 2003, and who need to learn how to use Microsoft® Word 2003 to create or modify complex business documents as well as customized Word efficiency tools. It will be helpful for persons preparing for the Microsoft Office Specialist exams for Microsoft® Word 2003.

Prerequisites: Students should be able to use Microsoft® Word 2003 to create, edit, format, save, and print basic business documents that contain text, basic tables, and simple graphics. Students can obtain this level of skill by taking the following Element K course:

  • Microsoft Word 2003: Level 1

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Performance-Based Objectives

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

  • manage data in lists.

  • customize tables and charts.

  • customize formatting.

  • work with custom styles.

  • modify pictures in a document.

  • create customized graphic elements.

  • control text flow.

  • automate common tasks.

  • automate document creation.

  • perform mail merges.

Course Content

Lesson 1: Managing Lists

Topic 1A: Sort a List

Topic 1B: Restart a List

Topic 1C: Create an Outline Numbered List

Topic 1D: Customize List Appearance

Lesson 2: Customizing Tables and Charts

Topic 2A: Sort a Table

Topic 2B: Modify Table Structure

Topic 2C: Merge or Split Cells

Topic 2D: Position Text in a Table Cell

Topic 2E: Apply Borders and Shading

Topic 2F: Perform Calculations in a Table

Topic 2G: Create a Chart from a Word Table

Topic 2H: Modify a Chart

Lesson 3: Customizing Formatting

Topic 3A: Modify Character Spacing

Topic 3B: Add Text Effects

Topic 3C: Control Paragraph Flow

Lesson 4: Working with Custom Styles

Topic 4A: Create a Character or Paragraph Style

Topic 4B: Modify an Existing Style

Topic 4C: Create a List Style

Topic 4D: Create a Table Style

Lesson 5: Modifying Pictures

Topic 5A: Set Picture Contrast or Brightness

Topic 5B: Crop a Picture

Topic 5C: Wrap Text Around a Picture

Lesson 6: Creating Customized Graphic Elements

Topic 6A: Draw Shapes and Lines

Topic 6B: Insert WordArt

Topic 6C: Insert Text Boxes

Topic 6D: Create Diagrams

Lesson 7: Controlling Text Flow

Topic 7A: Insert Section Breaks

Topic 7B: Insert Columns

Topic 7C: Link Text Boxes

Lesson 8: Automating Common Tasks

Topic 8A: Run a Macro

Topic 8B: Create a Macro

Topic 8C: Modify a Macro

Topic 8D: Customize Toolbars and Buttons

Topic 8E: Add Menu Items

Lesson 9: Automating Document Creation

Topic 9A: Create a Document Based on a Template

Topic 9B: Create a Document by Using a Wizard

Topic 9C: Create or Modify a Template

Topic 9D: Change the Default Template Location

Topic 9E: Insert a MacroButton Field in a Template

Lesson 10: Performing Mail Merges

Topic 10A: The Mail Merge Process

Topic 10B: Perform a Merge on Existing Documents

Topic 10C: Merge Envelopes and Labels

Topic 10D: Use Word to Create a Data Source


 

Microsoft® Office Word 2003: Level 3 - 6 hours in full or 2 half-days

Course Description

You know how to use Microsoft® Office Word 2003 to create and format typical business documents. But you need to work on more complex documents. In this course, you will learn how to use Word to create, manage, revise, and distribute long documents, forms, and Web pages.

Course Objective: You will create, manage, revise, and distribute long documents, forms, and Web pages.

Target Student: This course was designed for persons with a basic understanding of Microsoft Windows who can create and modify standard business documents in Microsoft® OfficeWord 2003, and who need to learn how to use the more advanced features of Word 2003 to create, manage, revise, and distribute long documents, forms, and Web pages. This course is intended for persons interested in pursuing Microsoft Office Specialist certification in Microsoft® Word 2003.

Prerequisites: Students should be able to use Microsoft® Office Word 2003 to create, edit, format, save, and print business documents that contain text, tables, and graphics. Students should also be able to use a Web browser and an email program. A basic understanding of XML would also be helpful. In order to understand how Word interacts with other applications in the Microsoft Office System, students should have a basic understanding of how worksheets and presentations work. To ensure your success, we recommend you first take the following Element K courses or have equivalent knowledge:

  • Microsoft® Office Word 2003: Level 1

  • Microsoft® Office Word 2003: Level 2

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Certification

Microsoft® Office Word 2003: Level 3 is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.

Hardware Requirements

For this course, you will need one computer for the classroom to run Windows Server 2003 Standard Edition and Exchange Server 2003 that meets the following system requirements:

  • Pentium III 133 MHz (550 MHz recommended)

  • 256 MB RAM (512 MB recommended)

  • 10 GB disk space plus 700 MB for Exchange Server 2003

  • CD-ROM or DVD drive

  • VGA or higher video adapter and monitor

  • Keyboard and Microsoft mouse or other input device

For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware components:

  • A 233 MHz Pentium-class processor if you use Windows XP Professional as your operating system. 300 MHz is recommended.

  • A 133 MHz Pentium-class processor if you use Windows 2000 Professional as your operating system.

  • 128 MB of RAM.

  • A 5 GB hard disk or larger if you use Windows XP Professional as your operating system. You should have at least 600 MB free hard-disk space available for the Office installation.

  • A 3 GB hard disk or larger if you use Windows 2000 Professional as your operating system. You should have at least 600 MB free hard-disk space available for the Office installation.

  • A floppy-disk drive.

  • A CD-ROM drive.

  • A mouse or other pointing device.

  • An 800 x 600 resolution monitor.

  • Network cards and cabling for local network access.

  • Internet access (see your local network administrator).

  • A printer (optional).

  • A projection system to display the instructor's computer screen.

Platform Requirements

  • Windows

Software Requirements

  • Microsoft Windows Server 2003, Enterprise Edition.

  • Microsoft Exchange Server 2003.

  • Either Windows XP Professional with Service Pack 1a or later or Windows 2000 Professional with Service Pack 4 or later.

  • Microsoft® Office Professional Edition 2003.

Performance-Based Objectives

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

  • Use Word with other programs.

  • Collaborate on documents.

  • Add reference marks and notes to a document.

  • Make long documents easier to use.

  • Secure documents and document information.

  • Create Web pages.

  • Create a form.

  • Use XML in Word.

Course Content

Lesson 1: Using Microsoft Office Word 2003 with Other Programs

Topic 1A: Link to a Microsoft® Office Excel 2003 Worksheet

Topic 1B: Link a Chart to Excel Data

Topic 1C: Send a Document Outline to PowerPoint

Topic 1D: Extract Text from a Fax

Topic 1E: Save a Document as a Different File Format

Topic 1F: Look Up Information Using Research Sites

Topic 1G: Send a Document as an Email Attachment

Lesson 2: Collaborating on Documents

Topic 2A: Modify User Information

Topic 2B: Create a New Version of a Document

Topic 2C: Delete Old Versions

Topic 2D: Send a Document for Review

Topic 2E: Use Comments

Topic 2F: Compare Document Changes

Topic 2G: Merge Document Changes

Topic 2H: Review a Document

Lesson 3: Adding Reference Marks and Notes

Topic 3A: Insert Bookmarks

Topic 3B: Insert Footnotes and Endnotes

Topic 3C: Add Captions

Topic 3D: Insert Cross-references

Lesson 4: Making Long Documents Easier to Use

Topic 4A: Mark Text for Indexing

Topic 4B: Insert an Index

Topic 4C: Insert a Table of Figures

Topic 4D: Mark Text for a Table of Authorities

Topic 4E: Insert a Table of Authorities

Topic 4F: Insert a Table of Contents

Topic 4G: Create a Master Document

Topic 4H: Automatically Summarize a Document

Lesson 5: Securing a Document

Topic 5A: Update a Document's Properties

Topic 5B: Save a Document without Personal Information

Topic 5C: Hide Text

Topic 5D: Limit Formatting Choices in a Document

Topic 5E: Select Regions of a Document that Can Be Modified

Topic 5F: Add a Digital Signature to a Document

Topic 5G: Require a Password to Open a Document

Lesson 6: Creating Web Pages

Topic 6A: Create a Web Page

Topic 6B: Insert Hyperlinks

Topic 6C: Insert a Movie Clip into a Web Page

Topic 6D: Apply a Theme to a Web Page

Topic 6E: Create a Framed Web Page

Topic 6F: Save a Web Page to a Web Server

Lesson 7: Creating Forms

Topic 7A: Add Form Fields to a Document

Topic 7B: Protect a Form

Topic 7C: Save Form Data as Plain Text

Topic 7D: Automate a Form

Lesson 8: Using XML in Word

Topic 8A: Tag an Existing Document

Topic 8B: Save a Document as XML

Topic 8C: Transform an XML Document


 

Microsoft® Office PowerPoint® 2003: Level 1 - 6 hours in full or 2 half-days

Course Description

In the past, you have used paper-based overhead systems to give presentations. Now, you want to upgrade those presentations to an electronic format. You can use Microsoft® Office PowerPoint® 2003 to give electronic presentations.

Course Objective: You will create effective basic Microsoft® Office PowerPoint® 2003 presentations for delivery in front of an audience.

Target Student: This course is designed for students who are interested in learning the fundamentals needed to create and modify basic Microsoft® PowerPoint® 2003 presentations. This course is also intended for students who wish to pursue their Microsoft Office Specialist certification in PowerPoint 2003.

Prerequisites: To ensure your success, we recommend you first take one of the following Element K courses or have equivalent knowledge:

  • Windows XP: Introduction

  • Windows XP Professional: Levels 1 and 2

  • Windows 2000: Introduction

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Certification

This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Hardware Requirements

For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware components:

  • A 233 MHz Pentium-class processor if you use Windows XP Professional as your operating system. 300 MHz is recommended.

  • A 133 MHz Pentium-class processor if you use Windows 2000 Professional as your operating system.

  • 128 MB of RAM.

  • A 5 GB hard disk or larger if you use Windows XP Professional as your operating system. You should have at least 600 MB of free hard disk space available for the Office installation.

  • A 3 GB hard disk or larger if you use Windows 2000 Professional as your operating system. You should have at least 600 MB of free hard disk space available for the Office installation.

  • A floppy disk drive.

  • A mouse or other pointing device.

  • An 800 x 600 resolution monitor.

  • Network cards and cabling for local network access.

  • Internet access (see your local network administrator).

  • A printer (optional).

  • A projection system to display the instructor's computer screen.

Platform Requirements

  • Windows

Software Requirements

  • Either Windows XP Professional with Service Pack 1, or Windows 2000 Professional with Service Pack 3.

  • Microsoft® Office Professional Enterprise Edition 2003.

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


 

Microsoft® Office PowerPoint® 2003: Level 2 - 6 hours in full or 2 half-days

Course Description

As a Microsoft® Office PowerPoint® 2003 user familiar with the basics, you're able to convey information clearly without much glitz. That's okay, but you can do better—audiences expect more than the basics. In this course, you will enhance presentations with features that will transform basic presentations into those with a powerful means of communication.

Course Objective: You will use Microsoft® Office PowerPoint® 2003 features that draw, animate, and format presentations with professional-quality content such that they may be communicated to a wide variety of live, remote, and self-service audiences.

Target Student: This course is designed for students who desire to gain the skills necessary to work with design templates, organizational charts, special effects, Web presentations, collaboration functionality, and advanced presentation delivery, or students who desire to prepare for the Microsoft Office Specialist exam in Microsoft® PowerPoint® 2003 and who already have knowledge of the basics of Microsoft® PowerPoint® 2003, including slide formatting, working with tables, images, and objects, charting data, and presentation preparation.

Prerequisites: To ensure your success, we recommend that you have taken the Element K courses or possess equivalent knowledge.

  • Windows XP: Introduction

  • Windows 2000: Introduction

  • Microsoft PowerPoint 2003: Level 1

Web browsing experience is also strongly recommended.

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Certification

This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Hardware Requirements

For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware components:

  • A 233 MHz Pentium-class processor if you use Windows XP Professional as your operating system (300 MHz is recommended).

  • A 133 MHz Pentium-class processor if you use Windows 2000 Professional as your operating system.

  • 128 MB of RAM.

  • A 5 GB hard disk if you use Windows XP Professional as your operating system. You should have at least 600 MB of free hard disk space available for the Office installation.

  • A 3 GB hard disk if you use Windows 2000 Professional as your operating system. You should have at least 600 MB of free hard disk space available for the Office installation.

  • A floppy disk drive.

  • A mouse or other pointing device.

  • An 800 x 600 resolution monitor.

  • Network cards and cabling for local network access.

  • Internet access (see your local network administrator).

  • A printer (optional).

  • A projection system to display the instructor's computer screen.

Platform Requirements

  • Windows XP Professional or Windows 2000 Professional

Software Requirements

  • Either Windows XP Professional with Service Pack 1 or Windows 2000 Professional with Service Pack 3.

  • Microsoft® Office Professional Enterprise Edition 2003.

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


 

Microsoft® Office Access 2003: Level 1 - 6 hours in full or 2 half-days

Course Description

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database by using the Microsoft® Office Access 2003 relational database application and its information management tools.

Course Objective: You will be introduced to the features of the Access 2003 application.

Target Student: This course is designed for students who wish to learn the basic operations of the Access 2003 database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications.

Prerequisites: To ensure the successful completion of Microsoft® Office Access 2003: Level 1, we recommend completion of one of the following Element K courses, or equivalent knowledge from another source:

  • Windows 2000: Introduction

  • Windows XP: Introduction

  • Windows XP Professional: Level 1

  • Windows XP Professional: Level 2

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Performance-based Objectives

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

  • Examine the Microsoft® Office Access 2003 database application.

  • Manage the data in a database.

  • Examine existing table relationships.

  • Query the database.

  • Design simple forms.

  • Create and modify Access reports.

 

Course Content

Lesson 1: An Overview of Access 2003

Topic 1A: Understand Relational Databases

Topic 1B: Examine the Access Environment

Topic 1C: Open the Database Environment

Topic 1D: Examine an Access Table

Lesson 2: Managing Data

Topic 2A: Examine an Access Form

Topic 2B: Add and Delete Records

Topic 2C: Sort Records

Topic 2D: Display Recordsets

Topic 2E: Update Records

Topic 2F: Run a Report

Lesson 3: Establishing Table Relationships

Topic 3A: Identify Table Relationships

Topic 3B: Identify Primary and Foreign Keys in the Relationships Window

Topic 3C: Work with Subdatasheets

Lesson 4: Querying the Database

Topic 4A: Create a Select Query

Topic 4B: Add Criteria to a Query

Topic 4C: Add a Calculated Field to a Query

Topic 4D: Perform a Calculation on a Record Grouping

Lesson 5: Designing Forms

Topic 5A: Examine Form Design Guidelines

Topic 5B: Create a Form Using AutoForm

Topic 5C: Create a Form Using the Form Wizard

Topic 5D: Modify the Design of a Form

Lesson 6: Producing Reports

Topic 6A: Create an AutoReport

Topic 6B: Create a Report by Using the Wizard

Topic 6C: Examine a Report in Design View

Topic 6D: Add a Calculated Field to a Report

Topic 6E: Modify the Format Properties of a Control

Topic 6F: AutoFormat a Report

Topic 6G: Adjust the Width of a Report

Appendix A: Microsoft Office Specialist Program


 

Microsoft® Office Access 2003: Level 2 - 6 hours in full or 2 half-days

Course Description

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 Objective: You will design and create a new Access database; improve queries, forms, and reports; and integrate Microsoft® Office Access 2003 with other applications.

Target Student: 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.

Prerequisites: To ensure the successful completion of Microsoft Access 2003: Level 2, we recommend completion of the following courses, or equivalent knowledge (basic familiarity with Access tables, relationships, queries, forms, and reports) from another source:

  • Microsoft Access 2003: Level 1

A basic understanding of Microsoft® Excel and Microsoft® Word would also be helpful, but is not required.

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Performance-Based Objectives

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

  • follow the steps required to properly design a simple database.

  • create a new database with related tables.

  • control data entry by modifying the design of a table to streamline data entry and maintain data integrity.

  • find and retrieve desired data by using filters and joins between tables and within a single table.

  • create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries.

  • enhance the appearance, data entry, and data access capabilities of your forms.

  • customize reports to better organize the displayed information and produce specific print layouts such as mailing labels.

  • use Access data in other applications, including Microsoft Word and Excel.

Course Content

Lesson 1: Planning a Database

Topic 1A: Design a Relational Database

Topic 1B: Identify Database Purpose

Topic 1C: Review Existing Data

Topic 1D: Determine Fields

Topic 1E: Group Fields into Tables

Topic 1F: Normalize the Data

Topic 1G: Designate Primary and Foreign Keys

Lesson 2: Building the Structure of a Database

Topic 2A: Create a New Database

Topic 2B: Create a Table Using a Wizard

Topic 2C: Create Tables in Design View

Topic 2D: Create Relationships between Tables

Lesson 3: Controlling Data Entry

Topic 3A: Restrict Data Entry with Field Properties

Topic 3B: Create an Input Mask

Topic 3C: Create a Lookup Field

Lesson 4: Finding and Joining Data

Topic 4A: Find Data with Filters

Topic 4B: Create Query Joins

Topic 4C: Join Unrelated Tables

Topic 4D: Relate Data Within a Table

Lesson 5: Creating Flexible Queries

Topic 5A: Set Select Query Properties

Topic 5B: Create Parameter Queries

Topic 5C: Create Action Queries

Lesson 6: Improving Your Forms

Topic 6A: Enhance the Appearance of a Form

Topic 6B: Restrict Data Entry in Forms

Topic 6C: Add Command Buttons

Topic 6D: Create a Subform

Lesson 7: Customizing Your Reports

Topic 7A: Organize Report Information

Topic 7B: Set Report Control Properties

Topic 7C: Control Report Pagination

Topic 7D: Summarize Information

Topic 7E: Add a Subreport to an Existing Report

Topic 7F: Create Mailing Labels

Lesson 8: Expanding the Reach of Your Data

Topic 8A: Publish Access Data as a Word Document

Topic 8B: Analyze Access Data in Excel

Topic 8C: Export Data to a Text File

Topic 8D: Merge Access Data with a Word Document

Appendix A: Microsoft Office Specialist Program


 

Microsoft® Office Access 2003: Level 3 - 6 hours in full or 2 half-days

Course Description

Your training in and use of Microsoft® Office Access 2003 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access 2003. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.

Course Objective: You will create complex Access databases using forms, reports, and macros.

Target Student: This course is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft® Office Access 2003 database program. The Level 3 course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft® Office Specialist Certification for Microsoft® Office Access 2003, and it is a prerequisite to taking more advanced courses in Microsoft® Office Access 2003.

Prerequisites: To ensure the successful completion of Microsoft® Office Access 2003: Level 3, we recommend completion of the following Element K courses, or equivalent knowledge (familiarity with basic and intermediate features of Access tables, relationships, queries, forms, and reports) from another source:

  • Microsoft® Office Access 2003: Level 1

  • Microsoft® Office Access 2003: Level 2

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Performance-Based Objectives

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

  • restructure an existing set of data to improve the design of a database.

  • use a variety of techniques to summarize and present data with queries.

  • create and revise basic Access macros.

  • create macros that improve data entry efficiency and integrity.

  • improve the effectiveness of data entry in forms.

  • improve the effectiveness of data displayed in reports.

  • maintain an Access database by using various utility tools.


 

Course Content

Lesson 1: Structuring Existing Data

Topic 1A: Import Data

Topic 1B: Analyze Tables

Topic 1C: Create a Junction Table

Topic 1D: Improve Table Structure

Lesson 2: Writing Advanced Queries

Topic 2A: Create Unmatched and Duplicates Queries

Topic 2B: Group and Summarize Records Using the Criteria Field

Topic 2C: Summarize Data with a Crosstab Query

Topic 2D: Create a PivotTable and a PivotChart

Topic 2E: Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros

Topic 3A: Create a Macro

Topic 3B: Attach a Macro to a Command Button

Topic 3C: Restrict Records Using a Where Condition

Lesson 4: Adding Interaction and Automation with Macros

Topic 4A: Require Data Entry with a Macro

Topic 4B: Display a Message Box with a Macro

Topic 4C: Automate Data Entry

Lesson 5: Making Forms More Effective

Topic 5A: Change the Display of Data Conditionally

Topic 5B: Display a Calendar on a Form

Topic 5C: Organize Information with Tab Pages

Lesson 6: Making Reports More Effective

Topic 6A: Cancel Printing of a Blank Report

Topic 6B: Include a Chart in a Report

Topic 6C: Arrange Data in Columns

Topic 6D: Create a Report Snapshot

Lesson 7: Maintaining an Access Database

Topic 7A: Link Tables to External Data Sources

Topic 7B: Back Up a Database

Topic 7C: Compact and Repair a Database

Topic 7D: Protect a Database with a Password

Topic 7E: Determine Object Dependency

Topic 7F: Document a Database

Topic 7G: Analyze the Performance of a Database

Appendix A: Microsoft Office Specialist Program
 

Microsoft Project 2003: Level 1 - 6 hours in full or 2 half-days

Course Description

Welcome to Microsoft Project 2003: Level 1. This course is the first in a series of two courses designed for individuals who will use Microsoft Office Project Professional 2003 as a tool to assist them in managing projects. The topics in this course cover the critical skills necessary to create and modify a project plan file that contains tasks, resources, and resource assignments.

Performance-Based Objectives

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

  • create a project plan file and enter task information.

  • create a work breakdown structure by organizing tasks and setting task relationships.

  • assign project resources.

  • finalize the project plan file.

Course Content

Lesson 1: Creating a Project Plan File

Topic 1A: Create a Project Plan File

Topic 1B: Create and Assign a Project Calendar

Topic 1C: Add Tasks to the Project Plan File

Topic 1D: Add a Project Summary Task

Topic 1E: Add a Recurring Task

Topic 1F: Enter Task Duration Estimates

Lesson 2: Creating a Work Breakdown Structure

Topic 2A: Outline Tasks

Topic 2B: Link Dependent Tasks

Topic 2C: Identify Deliverables in the Project Plan File

Topic 2D: Constrain Tasks

Topic 2E: Set a Task Deadline

Lesson 3: Creating and Assigning Resources

Topic 3A: Create Resources

Topic 3B: Create a Resource Calendar

Topic 3C: Assign Resources

Topic 3D: Assign Additional Resources to a Task

Topic 3E: Resolve Resource Conflicts

Lesson 4: Finalizing the Project Plan

Topic 4A: View the Critical Path

Topic 4B: Shorten the Project Duration

Topic 4C: Set a Baseline

Topic 4D: Display Project Summary Information


 

Microsoft Project 2003: Level 2 - 6 hours in full or 2 half-days

Course Description

Microsoft Project 2003: Level 2 is the second course in the Microsoft Project 2003 series. In Microsoft Project 2003: Level 1 , you used your project management skills to create a complete project plan. This course will build upon that knowledge, and give you the opportunity to work with a project plan once it has entered the project implementation phase.

Performance-Based Objectives

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

  • exchange project plan data with other applications.

  • update a project plan.

  • create custom reports.

  • re-use existing project plan information.

Course Content

Lesson 1: Exchanging Project Plan Data with Other Applications

Topic 1A: Import a Task List from an Excel File into a New Project Plan

Topic 1B: Create a Custom Import Map

Topic 1C: Export Project Plan Cost Data into Excel

Topic 1D: Copy a Picture into a Word Document

Topic 1E: Save Project Plan Information as a Web Page

Lesson 2: Updating a Project Plan

Topic 2A: Enter Task Progress Information

Topic 2B: View Task Progress

Topic 2C: Split a Task

Topic 2D: Reschedule a Task

Topic 2E: Filter Tasks in a Project Plan

Topic 2F: Save an Interim Project Plan

Topic 2G: Create a Custom Table

Topic 2H: Add Custom Columns to a Table

Topic 2I: Hyperlink Documents to Tasks

Lesson 3: Creating Custom Reports

Topic 3A: Create a Custom Report

Topic 3B: Modify a Custom Report's Header and Footer

Topic 3C: Add a Picture to a Report

Topic 3D: Modify a Custom Report's Margins

Topic 3E: Print a Custom Report

Lesson 4: Re-using Project Plan Information

Topic 4A: Create a Project Plan Template

Topic 4B: Create a Custom Combination View

Topic 4C: Make Custom Views Available to Other Project Plans

Topic 4D: Share Resources

Topic 4E: Create a Master Project Plan

Microsoft Office FrontPage 2003: Level 1

Course Overview:

As you begin this course, you should have the skills you need to work with Microsoft Office applications, especially Microsoft Word. This includes creating and editing documents that contain text, tables, and images. Now you’re ready to use a graphical application to create Web sites and Web pages. In this course, you will use Microsoft FrontPage 2003 to design, develop, and deploy Web sites that can be viewed on any Web-enabled computer around the world. FrontPage 2003: Level 1 is for someone who wants to create Web sites and Web pages in a graphical application. It is a prerequisite for taking the FrontPage 2003: Level 2 course.

Course Objective: In this course, you will create and publish a Web site using Microsoft FrontPage 2003.

Lesson: Course Introduction

Topic: Course Introduction

Topic Overview:

This will introduce you to the course content.

Topic Objective: In this topic, you will identify the relevance of the course-content.

Topics Covered:

 Identify the relevance of the course content

Lesson: Creating a Web

Topic: Lesson Introduction

Topic Overview:

This will introduce you to the lesson content.

Topic Objective: In this topic, you will identify the relevance of the lesson content.

Topics Covered:

 Identify the relevance of the lesson content

Topic: Overview of Web Development

Topic Overview:

You’re ready to start using FrontPage 2003 to create a Web site. Before you dive in, you’ll need to understand a few Web development concepts. In this topic, you’ll discover some of the basic principles of Web design and explore the FrontPage 2003 application environment.

Topic Objective: In this topic, you will list and describe the steps required to properly develop and deploy a Web site.

Topics Covered:

 List and describe the steps required to properly develop and deploy a Web site

Topic: Create a New Web Site

Topic Overview:

Now that you’ve explored the FrontPage environment and the Web creation process, you’re ready to apply your knowledge to start creating your own Webs. In this topic, you’ll use a FrontPage template to create a new FrontPage Web site.

Topic Objective: In this topic, you will create a new FrontPage web.

Topics Covered:

 Create a new FrontPage Web

Topic: Create and Format Web Page Text

Topic Overview:

You’ve created a FrontPage Web and a new Web page. The next logical step in the development process is to add some content to your Web page. In this section, you’ll add text to your Web pages.

Topic Objective: In this topic, you will add text to a Web page.

Topics Covered:

 Add text to a Web page

Topic: Create Pages

Topic Overview:

You’ve created a Web site and a Web page that contains formatted text. To facilitate the organization and presentation of more information, your site will probably need to contain more than one page. In this section, you’ll add pages to your site.

Topic Objective: In this topic, you will create a Web page.

Topics Covered:

 Create a Web page

Topic: Import Web Pages

Topic Overview:

You’ve created a Web site that contains several new pages. As you’re developing your Web site, you’re likely to discover that your co-workers or friends have created Web pages that you’d like to include in your site. In this topic, you’ll import existing Web pages into your FrontPage Web.

Topic Objective: In this topic, you will import existing Web pages into the FrontPage Web.

Topics Covered:

 Import existing Web pages into the FrontPage Web

Topic: Lab: Creating a New Web Site and Home Page

Topic Overview:

You will be given a scenario and high-level steps to create a new web site and home page.

Topic Objective: Create a new web site and home page.

Topics Covered:

 Create a new Web site and home page

Topic: Lesson Follow Up

Topic Overview:

You will review what you learned throughout this lesson.

Topic Objective: In this topic, you will summarize what you learned throughout this lesson.

Topics Covered:

Summarize what you learned throughout this lesson

Lesson: Adding Images

Topic: Lesson Introduction

Topic Overview:

This will introduce you to the lesson content.

Topic Objective: In this topic, you will identify the relevance of the lesson content.

Topics Covered:

 Identify the relevance of the lesson content

Topic: Add a Picture to a Web Page

Topic Overview:

Your ultimate goal is to create a complete Web site. Almost any Web site would be incomplete without graphics and pictures. In this topic, you’ll add a picture to a Web page.

Topic Objective: In this topic, you will add a picture to a Web page.

Topics Covered:

 Add a picture to a Web page

Topic: Edit a Picture

Topic Overview:

Now that you’ve added an image to a Web page, you’ll probably want to make some simple changes to the images appearance. In this topic, you’ll edit a picture in FrontPage.

Topic Objective: In this topic, you will use FrontPage to edit an image.

Topics Covered:

 Use FrontPage to edit an image

Topic: Add a New Drawing

Topic Overview:

You’ve added images to your Web pages and edited existing images. Next, you may want to create your own graphics to add to your site. In this topic, you’ll create a graphic right in FrontPage.

Topic Objective: In this topic, you will add a new drawing to a Web page.

Topics Covered:

 Add a new drawing to a Web page

Topic: Add a Photo Gallery

Topic Overview:

You’ve added pictures and graphics to your Web site. Next, you may want to create a photo gallery to display your pictures. In this topic, you’ll use a FrontPage tool to automatically create a photo gallery.

Topic Objective: In this topic, you will add a Photo Gallery to a Web page.

Topics Covered:

 Add a photo gallery to a Web page

Topic: Modify a Photo Gallery

Topic Overview:

You’ve used the FrontPage component tool to automatically create a photo gallery. Now, you’re likely to want to make some changes to the gallery. In this topic, you’ll modify an existing photo gallery.

Topic Objective: In this topic, you will modify a photo gallery.

Topics Covered:

 Modify a photo gallery

Topic: Lab: Adding Photos to a Web Site

Topic Overview:

You will be given a scenario and high-level steps to add photos to a web site.

Topic Objective: Add photos to a web site.

Topics Covered:

 Add photos

Topic: Lesson Follow Up

Topic Overview:

You will review what you learned throughout this lesson.

Topic Objective: In this topic, you will summarize what you learned throughout this lesson.

Topics Covered:

 Summarize what you learned throughout this lesson

Lesson: Creating Links

Topic: Lesson Introduction

Topic Overview:

This will introduce you to the lesson content.

Topic Objective: In this topic, you will identify the relevance of the lesson content.

Topics Covered:

 Identify the relevance of the lesson content

Topic: Add Hyperlinks

Topic Overview:

You have a Web site that includes pages with images and text. One characteristic of a Web site is that its pages are connected to each other through hyperlinks. Your next task is to link the pages of your site together by adding hyperlinks.

Topic Objective: In this topic, you will add hyperlinks to Web pages.

Topics Covered:

 Add hyperlinks to Web pages

Topic: Add Bookmark Links

Topic Overview:

You’ve added links that connect several of the pages in your Web site. Bookmark are another type of link that you are likely to use. In this topic, you’ll add bookmark links to a Web page.

Topic Objective: In this topic, you will add bookmark links.

Topics Covered:

 Add bookmark links

Topic: Link from an Image

Topic Overview:

Your Web pages now contain text links and bookmark links. The next type of link that you’ll want to employ is the image link. In this topic, you’ll add links to images.

Topic Objective: In this topic, you will add a link to an image.

Topics Covered:

 Add a link to an image

Topic: Lab: Connecting Pages in a Web Site

Topic Overview:

Connecting pages in a web site.

Topic Objective: Connect pages in a web site.

Topics Covered:

 Connect pages in a web site

Topic: Lesson Follow Up

Topic Overview:

You will review what you learned throughout this lesson.

Topic Objective: In this topic, you will summarize what you learned throughout this lesson.

Topics Covered:

 Summarize what you learned throughout this lesson

Lesson: Adding Tables

Topic: Lesson Introduction

Topic Overview:

This will introduce you to the lesson content.

Topic Objective: In this topic, you will identify the relevance of the lesson content.

Topics Covered:

 Identify the relevance of the lesson content

Topic: Insert a Table

Topic Overview:

Inserting a table is the first step in organizing content on a page. With a table, content such as text and pictures can be arranged however you want it.

Topic Objective: In this topic, you will add a table to a Web page.

Topics Covered:

 Add a table to a Web page

Topic: Set Table Properties

Topic Overview:

You have discovered that tables are a powerful tool for positioning items in a page. But tables can do more than position items on a page. Now you’re ready to manipulate the properties of a table in FrontPage.

Topic Objective: In this topic, you will set the properties of a table.

Topics Covered:

 Set the properties of a table

Topic: Set Cell Properties

Topic Overview:

You have added tables to your Web pages and manipulated the properties of a table. Because tables are composed of individual cells, the next step is to set the properties of the individual table cells.

Topic Objective: In this topic, you will set the properties of a table cell.

Topics Covered:

 Set the properties of a table cell

Topic: Edit Table Structure

Topic Overview:

You’ve created a table and modified the table and cell properties. There is more to manipulating tables than modifying the individual table components. The next task that you might want to attempt is to edit the structure of a table.

Topic Objective: In this topic, you will change the structure of a table.

Topics Covered:

 Change the structure of a table

Topic: Split Tables

Topic Overview:

You’ve succeeded in displaying Web page content in tables and in merging and splitting Web cells, rows, and columns. You may also want to manipulate entire tables in the same way. In this section, you’ll split a single table into two smaller, more manageable tables.

Topic Objective: In this topic, you will split a table into multiple tables.

Topics Covered:

 Split a table into multiple tables

Topic: AutoFormat a Table

Topic Overview:

You’ve created tables and manipulated individual table and cell properties. FrontPage also provides tools to configure tables in a single step. You’re ready to use FrontPage to create an auto-formatted table.

Topic Objective: In this topic, you will apply AutoFormat to format a table.

Topics Covered:

 Apply AutoFormat to format a table

Topic: Lab: Adding a Table to a Page

Topic Overview:

Adding a table to a page.

Topic Objective: Add a table to a page.

Topics Covered:

 Add tables

Topic: Lesson Follow Up

Topic Overview:

You will review what you learned throughout this lesson.

Topic Objective: In this topic, you will summarize what you learned throughout this lesson.

Topics Covered:

 Summarize what you learned throughout this lesson

Lesson: Formatting a Web Page

Topic: Lesson Introduction

Topic Overview:

This will introduce you to the lesson content.

Topic Objective: In this topic, you will identify the relevance of the lesson content.

Topics Covered:

 Identify the relevance of the lesson content

Topic: Apply a Theme

Topic Overview:

You’ve created a variety of Web pages with different formatting. You’d probably like to make your pages look like they all belong to the same Web site. The simplest way to give your Web pages a common look-and-feel is to apply a theme.

Topic Objective: In this topic, you will apply a theme to a Web page.

Topics Covered:

 Apply a theme to a Web page

Topic: Customize a Theme

Topic Overview:

Now that you’ve added a theme to your pages, you may want to make some modifications to the theme. In this topic, you’ll create a custom theme.

Topic Objective: In this topic, you will customize an existing theme.

Topics Covered:

 Customize an existing theme

Topic: Creating and Formatting with Styles

Topic Overview:

You’ve used themes to specify your Web pages fonts and colors. CSS is another way of automatically formatting your pages fonts and colors. In this section, you’ll use CSS to apply your own fonts and colors to pages.

Topic Objective: In this topic, you will use CSS to format a paragraph.

Topics Covered:

 Use CSS to format a paragraph

Topic: Set the Background

Topic Overview:

You’ve used a theme to format the fonts and colors of your page. Although background colors are part of themes, you can set the background of a page without applying an entire theme. The next step in the development of your Web pages is to set the background color or image.

Topic Objective: In this topic, you will set the background.

Topics Covered:

 Set the background

Topic: Test in Multiple Browsers

Topic Overview:

You’ve created a wide range of Web pages. Given that your users may view these pages in a range of different computer environments, you may want to test your pages in different browsers. In this topic, you’ll test your pages in multiple browsers.

Topic Objective: In this topic, you will test Web pages in multiple browsers.

Topics Covered:

 Test Web pages in multiple browsers

Topic: Lab: Formatting a Web Page

Topic Overview:

Formatting a web page.

Topic Objective: Format a web page.

Topics Covered:

 Format a Web page

Topic: Lesson Follow Up

Topic Overview:

You will review what you learned throughout this lesson.

Topic Objective: In this topic, you will summarize what you learned throughout this lesson.

Topics Covered:

 Summarize what you learned throughout this lesson

 

Lesson: Designing Your Web Pages

Topic: Lesson Introduction

Topic Overview:

This will introduce you to the lesson content.

Topic Objective: In this topic, you will identify the relevance of the lesson content.

Topics Covered:

 Identify the relevance of the lesson content

Topic: Design a Web Page Layout

Topic Overview:

You have used several Web development techniques to develop pages that incorporate text, images, tables, and Web components. Next, you’ll explore techniques for bringing all of these elements together in a well-designed Web page layout.

Topic Objective: In this topic, you will design a Web page layout.

Topics Covered:

 Design a Web page layout

Topic: Lay Out a Web Page with Tables

Topic Overview:

You have just designed a page layout. Once you have a page layout in mind you’ll want to implement it in an actual Web page. In this section, you’ll use tables to implement your layout design in a Web page.

Topic Objective: In this topic, you will layout a Webpage using tables.

Topics Covered:

 Lay out a Web page using tables

Topic: Create and Apply a Dynamic Web Template

Topic Overview:

You’ve used a table to layout components in a Web page. While tables are one means of creating a repeatable layout, dynamic Web templates are a better way of creating a repeatable layout. The next task you’re likely to undertake is to create and apply a Dynamic Web Template.

Topic Objective: In this topic, you will create and apply a FrontPage template.

Topics Covered:

 Create and apply a FrontPage template

Topic: Lab: Laying Out a Page with a Table

Topic Overview:

Layout a page with a table.

Topic Objective: Layout a page with a table.

Topics Covered:

 Lay out a page with a table

Topic: Lesson Follow Up

Topic Overview:

You will review what you learned throughout this lesson.

Topic Objective: In this topic, you will summarize what you learned throughout this lesson.

Topics Covered:

 Summarize what you learned throughout this lesson

 

Lesson: Structuring a Web Site with Navigation View

Topic: Lesson Introduction

Topic Overview:

This will introduce you to the lesson content.

Topic Objective: In this topic, you will identify the relevance of the lesson content.

Topics Covered:

 Identify the relevance of the lesson content

Topic: Create a Navigation Structure

Topic Overview:

You have developed a range of Web pages in a Web site. A Web site has a natural hierarchical structure, starting with the home page. The first step in structuring your site is to create a navigation structure.

Topic Objective: In this topic, you will create a navigation structure for a Web site.

Topics Covered:

 Create a navigation structure for a Web site

Topic: Modify a Navigation Structure

Topic Overview:

You’ve created a site navigation structure that graphically displays the structure of your site. After you’ve created a navigation structure, you may need to make modifications to the navigation structure. In this section, you’ll change the navigation structure of your Web site.

Topic Objective: In this topic, you will change the navigation structure of a Web site.

Topics Covered:

 Change the navigation structure of a Web site

Topic: Remove a Web Page from a Webs Navigation Structure

Topic Overview:

You’ve created a navigation structure to help manage your site and you’ve modified your sites navigation structure. Although you add pages to a site over time, you may also need to delete pages from the site. Next, you’ll remove a page from the navigation structure.

Topic Objective: In this topic, you will remove a Web page from navigation structure.

Topics Covered:

 Remove a Web page from the navigation structure

Topic: Lab: Creating a Web Navigation View

Topic Overview:

Create a web navigation view

Topic Objective: Create a web navigation view.

Topics Covered:

 Create a Web navigation view

Topic: Lesson Follow Up

Topic Overview:

You will review what you learned throughout this lesson.

Topic Objective: In this topic, you will summarize what you learned throughout this lesson.

Topics Covered:

 Summarize what you learned throughout this lesson

 

Lesson: Publishing a Web

Topic: Lesson Introduction

Topic Overview:

This will introduce you to the lesson content.

Topic Objective: In this topic, you will identify the relevance of the lesson content.

Topics Covered:

 Identify the relevance of the lesson content

Topic: Prepare Your Web Site for Publishing

Topic Overview:

Your Web pages are almost ready for publishing. But before you can publish, there are a few tasks that you should take care of. In this section, you’ll prepare your Web site for publishing by checking spelling and using FrontPages smart find and replace.

Topic Objective: In this topic, you will prepare a Web for publishing.

Topics Covered:

 Prepare a Web for publishing

Topic: Publish Your Web

Topic Overview:

Now that your site has been spell-checked and finalized, you ready to make it available to your end users. Typically, this involves uploading the site to a Web server. In this section, you’ll publish your Web.

Topic Objective: In this topic, you will publish your Web a to Web server.

Topics Covered:

 Publish your Web a to Web server

Topic: Publish a Web Site from One Location to Another

Topic Overview:

Now that you’ve published your Web site to a Web server, you may need to publish it to a different location in order to create a backup copy of the site. In this section, you’ll publish a Web site from one location to another.

Topic Objective: In this topic, you will publish a Web site from one location to another.

Topics Covered:

 Publish a Web site from one location to another

Topic: Lab: Finalizing and Publishing a Web Site

Topic Overview:

Finalizing and Publishing a Web Site

Topic Objective: Finalizing and Publishing a Web Site

Topics Covered:

 Finalize and Publish a Web Site

Topic: Lesson Follow Up

Topic Overview:

You will review what you learned throughout this lesson.

Topic Objective: In this topic, you will summarize what you learned throughout this lesson.

Topics Covered:

 Summarize what you learned throughout this lesson

 

 

 

 

 


Custom CRM

$100 off if you order by January 31st, 2008

PC Focus has a new product called Project Links.  More . . .

Call today for a free demonstration.

717-396-9881

e-learning WBT
[Web Based Training]

Learning Methods.  See sample WBT and view one of the training methods that PC Focus delivers.  More...

Focused
Learning

What is focused learning?  Find out how this type of training can make you more productive - fast!!  More....

 

 

Office Suite 2013 ~ 2010  ~ 2007

Classes available!
 Learn
new features plus more......

YOU
customize the class
that is right for your organization!

Outlook
Excel
Word
PowerPoint
Access
Visio
Publisher
Microsoft Publisher

Instructor-led (at your location) and Online Classes
Personal Coaching and Support for Individuals

Crystal Reports X, XI & 2008

How to Maximize Use of your iPad & iPhone!  Call for custom class details.

Have you upgraded to Windows 7 and or Windows 8?
Windows 8

Windows 7 & 8 Classes

Call For Windows 8 Classes - 717.380.6934

P C  F o c u s
PO Box 10905

Lancaster, Pennsylvania 17605

717.380.6934 office

 

Mission Statement | Vision | Privacy Statement | Get a Quote | Links