Office Administration
Automation

Responsible: Dr. E. Boroumand
Option I:
Duration: 180 hours
Registration Fee: $50.00
Tuition fee: $1550.00

Option II:
Duration: 80 hours
Registration Fee: $50.00
Tuition fee: $480.00

One computer per person
Free Internet access for all our students
Assignments are given at each class
Tax deductible
Supported by Emploi-Québec
Certificate is given upon completion

Windows XP/Vista: Introduction
Microsoft Word 2003/2007 Level I
Microsoft Word 2003/2007 Level II
Microsoft Word 2003/2007 Level III
Microsoft Excel 2003/2007 Level I
Microsoft Excel 2003/2007Level II
Microsoft Excel 2003/2007 Level III
Microsoft Access 2003/2007 Level I
Microsoft Access 2003/2007 Level II
Microsoft Access 2003/2007 Level III
Microsoft Publisher 2003/2007
Microsoft FrontPage 2003/2007
Microsoft Outlook Level I
Microsoft Outlook Level II
Microsoft PowerPoint 2007 Level I
Microsoft PowerPoint 2007 Level II
Website Design – Using Macromedia Dreamweaver
Fundamentals of Bookkeeping

Windows XP/VISTA: Introduction
Overview: Students will create a document, organize files, work with Windows Messenger,
create an efficient work environment, work with media, clean up their system, and find information
on the Internet.
Prerequisites:
• Introduction to Personal Computers Using Windows 98:
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will gain the skills needed to create a document, organize files, work with
Windows Messenger, create an efficient work environment, work with media, clean up their
system, and find information on the Internet.
Target student: The target student for this course is a user who has worked with basic computer
concepts and gained skills related to IBM and compatible computers.
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:
• You will create a document by using WordPad.
• You will organize the contents of your hard drive by using Windows Explorer.
• You will communicate instantly with others by using Windows Messenger.
• You will create an efficient work environment by using the Control Panel and Accessibility
programs.
• You will perform a variety of media tasks by using the Help and Support Center and
Media Player.
• You will clean up your system by using My Computer and the Recycle Bin.
• You will find information on the Internet by using Internet Explorer.
Course Content
Lesson 1: Creating a Document in Windows
Topic 1A: Launch a Program
Topic 1B: Create a Document
Topic 1C: Save a Document
Topic 1D: Preview and Print a Document
Topic 1E: Cut, Copy, and Paste Information
Lesson 2: Organizing Files
Topic 2A: Find Files
Topic 2B: Create Folders
Topic 2C: Move Files
Topic 2D: Create Shortcuts
Lesson 3: Working with Windows Messenger
Topic 3A: Create a Microsoft Passport Account
Topic 3B: Add Contacts
Topic 3C: Send and Receive Instant Messages
Topic 3D: Change Windows Messenger Options
Lesson 4: Creating an Efficient Work Environment
Topic 4A: Change Mouse Properties
Topic 4B: Change a Volume Property
Topic 4C: Change the Display Properties
Topic 4D: Switch Users
Topic 4E: Work with Accessibility Programs
Lesson 5: Researching and Using Windows Media Player
Topic 5A: Use Help and Support
Topic 5B: Create Your Favorites
Topic 5C: Play a Video
Topic 5D: Apply a Skin
Lesson 6: Cleaning Up Your System
Topic 6A: Check System Capacity
Topic 6B: Analyze Your Hard Drive
Topic 6C: Delete Your Files and Folders
Topic 6D: Empty the Recycle Bin
Lesson 7: Finding Information on the Internet
Topic 7A: Browse the Internet
Topic 7B: Move to Specific Internet Sites
Topic 7C: Use Favorites to Return to Internet Sites
Topic 7D: Shut Down Windows

Microsoft Word 2007: Level I
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:
• Identify the components of the application window and adjust some default settings;
create, save, and close a document; open an existing document; use simple editing
techniques; and search for help.
• Navigate in a large document by using the mouse and keyboard and locate specific
places and words in a document by using the Find, Replace, and Go To commands and
the Select Browse Object button.
• Edit a document by using more sophisticated techniques, including moving and copying
text within a document and between documents.
• Apply and remove character and paragraph formatting.
• Use tabs and create and modify a table and its structure.
• Adjust margins, add and delete page breaks, and create headers and footers.
• Use Word’s proofing tools, such as the spelling checker and thesaurus, and print a
document, envelope, and labels.
• Save an existing document as a Web page, add visual appeal to it, and preview it in a
browser.
Course description
Overview: Students will learn the basic skills necessary to begin using Word 2003/2007.
Prerequisites: Windows 95: Introduction, Windows 98: Introduction, Windows NT 4.0:
Introduction, or equivalent knowledge.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to create and edit documents and use character and paragraph
formatting.
Target student: Students enrolling in this course should understand the basic concepts involved
in working with a personal computer (PC). No prior knowledge of Word is assumed.
What's next: Word 2003/2007: Level 1 is the first course in this series. Word 2003/2007: Level 2, the
next course in this series, teaches students how to use intermediate features of Word 2003/2007.
Students who want to learn advanced features can take Word 2003/2007: Advanced.
Course content
Lesson 1: Word basics
• Introduction to Word
• Creating a new blank document and the basics of entering text
• The Save As command
• Opening and editing a document
• Getting help in Word
Lesson 2: Navigating in a document
Scrolling within a document
Searching a document
Lesson 3: Additional editing techniques
Using AutoCorrect
Techniques for selecting text
Moving text
Lesson 4: Character and paragraph formatting
Basic character formatting techniques
Additional character formatting techniques
Paragraph formatting
Working with indents, numbered lists, and bulleted lists
Line breaks and line spacing
Lesson 5: Introduction to tabs and tables
Working with tabs
Creating a table
Editing tables
Lesson 6: Controlling page appearance
Headers and footers
Modifying margins
Page breaks
Lesson 7: Tools and printing
Using proofing tools
Printing a document
Envelopes and labels
Lesson 8: Creating a Web page
Creating a Web page
Using themes and exiting Word

Microsoft Word 2007: Level II
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:
Use section breaks to format a document and format text in columns.
Create, modify, and use tables as page layout elements and embed, link, and sort table data.
Merge documents and data sources using merge fields to make variations of one document.
Students will be able to sort and filter data as well as merge an Excel spreadsheet into
mailing labels.
Create, modify, and use styles to affect a document’s appearance. Students will also create
and delete AutoText entries.
Create and use templates, including the fax template.
Run and edit existing macros, add them to toolbars, and use the Organizer to share them
with other documents.
Discuss Internet/Web and Word’s email features, as well as create and edit a Web page by
inserting hyperlinks, picture bullets, and clip art.
Course description
Overview: Students will learn intermediate features of Word 2007.
Prerequisites: Windows 95: Introduction, Windows 98: Introduction, Windows NT 4.0:
Introduction, or equivalent knowledge, and Word 200: Level 1.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to create and control section breaks, tables, merges, styles,
templates, macros, and Web pages.
Target student: Students enrolling in this course should understand the basic concepts involved
in working with a personal computer (PC). For example, students should be familiar with such
terms as computer memory, data files, and program files. Students should also be acquainted
with the hardware components that make up a PC—input, output, and storage devices, for
instance. Completion of Ziff-Davis Education’s Word 200P: Level 1 class is assumed.
What's next: Word 2007 : Level 2 is the second course in this series. Students who would
like to expand their knowledge of styles, learn how to create forms, use graphical effects, and
manage and share large documents can take Word 2007: Advanced.
Course content
Lesson 1: Working with Sections
Creating Sections
Newspaper Columns
Using Sections to Change Page Orientation
Lesson 2: Managing Tables and Table Data
Creating and Formatting Tables
Working with Table Data
Drawing Your Own Table
Link and Embed Excel Data
Lesson 3: Using Mail Merge
Creating a Mail Merge Document
Completing a Main Document
The Merge
Sorting and Filtering Merges
Using an Alternative Data Source to Create Mailing Labels
Lesson 4: Styles and AutoText
Applying and Displaying Styles
Creating Custom Styles
Making Changes to Styles
Using Heading Styles to Organize a Document
AutoText Entries
Lesson 5: Introduction to Templates
Templates at a Glance
Using Templates
Creating a New Fax Cover Sheet Based on a Template
Lesson 6: Introduction to Macros
Running and Recording Macros
Working with Existing Macros
Custom Toolbars
Lesson 7: The Internet and the Web
About the Internet, the Web, and Email
Creating a Web Page Based on a Template
Adding Hyperlinks to a Web Page
Adding Graphical Elements to a Web Page

Microsoft Word 2007: Level III
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:
• Use the AutoFormat feature, link styles within a document, and find and replace styles
and non-printing characters.
• Create forms as well as protect, test, and update them.
• Create drop caps, watermarks, WordArt, and drawn objects.
• Create and modify a table of contents; discuss master documents; insert, modify, and
delete bookmarks, cross-references, endnotes, and footnotes; create and use a
concordance file to generate an index; and prepare a long document for printing.
• Create multiple versions of a document; track changes made to documents; apply
highlighting and insert comments; compare documents; review and incorporate changes;
and merge documents.
• Add hyperlinks to internal and external bookmarks; view and edit intranet documents; and
insert multimedia elements into Web pages.
Course description
Overview: Students will learn advanced features of Word 2007 .
Prerequisites: Windows 95: Introduction, Windows 98: Introduction, or Windows NT 4.0:
Introduction and Word 2007 : Level 1 and Word 2007 : Level 2, or equivalent knowledge.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to AutoFormat a document, use advanced Find And Replace
skills, create forms, use form fields, add graphics, work with large documents, share documents,
and prepare documents as intranet Web pages.
Target student: Students enrolling in this course should understand the basics of Windows.
They should already have experience working with Word 2007 . Specifically, students should
know how to create styles, templates, and save documents as Web pages.
What's next: Word 2007 : Level 3 is the last course in this series. Students may be interested
in taking Microsoft Office: Document Integration or the FrontPage 2007 : Introduction course
next.
Course content
Lesson 1: Advanced Styles
• The AutoFormat Feature
• Linking Styles
• Replacing Styles and Other Items
Lesson 2: Creating a Form Template
• Forms and Fields
• Protecting and Using a Form Template
Lesson 3: Using Graphic Effects
• Working with Dropped Capital Letters and Clip Art
• Inserting and Editing WordArt
• Drawing in a Document
Lesson 4: Working with Large Documents
• Creating a Table of Contents
• Footnotes and Endnotes
• Bookmarks
• Cross-references
• Using a Concordance File to Index
• Preparing to Print
Lesson 5: Managing Document Changes
• Using Different Versions of a Document
• Tracking Changes to a Document
• Using Highlights and Comments
• Comparing Similar Documents
Lesson 6: Preparing Word Documents for an Intranet
• Creating Hyperlinks
• Viewing and Editing a Web Page
• Inserting Multimedia Elements into Your Web Pages
Microsoft Excel 2007: Level I
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:
• Identify the disadvantages of paper spreadsheets and the advantages of electronic
spreadsheets by exploring both.
• Create a basic worksheet by entering text, values, and formulas.
• Create formulas by using Excel’s built-in functions.
• Move and copy data by using shortcut menus, drag-and-drop editing, and toolbar
buttons.
• Change the appearance of worksheet data by using a variety of formatting techniques.
• Prepare a document for printing by using the spell checking feature and a variety of
printing options.
• Use the three-dimensional aspect of the Excel workbook environment by creating
formulas that refer to cells on multiple worksheets.
• Save an Excel workbook as a Web page.
Course description
Overview: Students will learn basic worksheets skills and how to work with data in worksheets.
Prerequisites: Windows 98: Introduction, or equivalent knowledge.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to use an electronic spreadsheet to create basic data reports.
Target student: Students enrolling in this course should understand how to use Windows 98.
What's next: Excel 2007 : Worksheets is the first course in this series. Excel 2007 :
Charting and Organizing Data, the next course in this series, teaches students how to use the
charting and list management capabilities in Excel. Students who want to learn advanced
features can take Excel 2007 : Advanced.
Course content
Lesson 1: Excel basics
• The paper spreadsheet
• The Excel program
• The workbook environment
Lesson 2: Entering data and navigating in a worksheet
• Entering and correcting data
• Saving a file
• Using formulas
• Opening a second file
• Navigation and movement techniques
Lesson 3: Modifying a workbook
• Working with ranges
• Working with functions
• Editing cell contents
Lesson 4: Moving and copying data
• Inserting rows and ranges
• Moving data
• Copying data
• Absolute references
• Using the Fill Series feature
Lesson 5: Formatting a worksheet
• Formatting a worksheet
• Number formats and text alignment
• Copying and pasting formats
• Special and custom formatting
Lesson 6: Printing a worksheet
• Checking spelling
• Using the Print Preview command
• Printing a large worksheet
• Additional print options
Lesson 7: Introduction to the workbook environment
• Using a multiple-sheet workbook
• Creating a chart
• Outlining
• Spreadsheet solutions
Lesson 8: Creating Excel Web pages
• Using Excel as a Web tool

Microsoft Excel 2000: Level 1
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:
• Identify the disadvantages of paper spreadsheets and the advantages of electronic spreadsheets by exploring both.
• Create a basic worksheet by entering text, values, and formulas.
• Create formulas by using Excel’s built-in functions.
• Move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons.
• Change the appearance of worksheet data by using a variety of formatting techniques.
• Prepare a document for printing by using the spell checking feature and a variety of printing options.
• Use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets.
• Save an Excel workbook as a Web page.
Course description

Overview: Students will learn basic worksheets skills and how to work with data in worksheets.

Prerequisites: Windows 98: Introduction, or equivalent knowledge.

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

Benefits: Students will learn how to use an electronic spreadsheet to create basic data reports.

Target student: Students enrolling in this course should understand how to use Windows 98.

What's next: Excel 2000: Worksheets is the first course in this series. Excel 2000: Charting and Organizing Data, the next course in this series, teaches students how to use the charting and list management capabilities in Excel. Students who want to learn advanced features can take Excel 2000: Advanced.

Course content
Lesson 1: Excel basics
• The paper spreadsheet
• The Excel program
• The workbook environment
Lesson 2: Entering data and navigating in a worksheet
• Entering and correcting data
• Saving a file
• Using formulas
• Opening a second file
• Navigation and movement techniques
Lesson 3: Modifying a workbook
• Working with ranges
• Working with functions
• Editing cell contents
Lesson 4: Moving and copying data
• Inserting rows and ranges
• Moving data
• Copying data
• Absolute references
• Using the Fill Series feature
Lesson 5: Formatting a worksheet
• Formatting a worksheet
• Number formats and text alignment
• Copying and pasting formats
• Special and custom formatting
Lesson 6: Printing a worksheet
• Checking spelling
• Using the Print Preview command
• Printing a large worksheet
• Additional print options
Lesson 7: Introduction to the workbook environment
• Using a multiple-sheet workbook
• Creating a chart
• Outlining
• Spreadsheet solutions
Lesson 8: Creating Excel Web pages
• Using Excel as a Web tool

Microsoft Excel 2007: Level II
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:
• Create charts that graphically represent worksheet data.
• Modify charts.
• Customize charts by applying formatting.
• Enhance worksheets and charts by using the drawing tools to add graphic objects.
• Sort information in a list by using the Data, Sort command.
• Locate information quickly in a list that meets specified conditions by using the Advanced
filter feature.
Course description
Overview: Students will learn the skills and concepts necessary to create charts and to use the
list management capabilities of Excel 2007 .This course meets the Microsoft Proficiency
Guidelines for Excel 2007 at the Expert level.
Prerequisites: Windows 98: Introduction and Excel 2007 : Worksheets, or equivalent
knowledge.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to represent data graphically and maintain and manage lists.
Target student: Students enrolling in this course should understand data types (text, numbers,
and formulas) and the use of the menu system for copying data and for opening and saving files.
What's next: Excel 2007 : Advanced is the third course in this series. Students can take
Excel 2007 : Advanced to learn advanced features.
Course content
Lesson 1: Creating Charts
• Creating a Chart Sheet
• Creating an Embedded Chart
• Comparing Chart Sheets with Embedded Charts
Lesson 2: Modifying Charts
• Chart Types
• Modifying Embedded Charts
• Adding and Deleting Chart Items
• Moving and Sizing Chart Items

Lesson 3: Formatting a Chart
• Formatting Chart Text
• Formatting Labels
• Formatting the Chart
• Printing a Chart Sheet
Lesson 4: Using Graphic Objects
• Adding Graphic Objects
• Formatting Graphic Objects
• Using Graphic Objects to Enhance Worksheets and Charts
Lesson 5: Sorting Data
• Single-level Sorting
• Multiple-level Sorting
• Sorting Options
• Importing Data
• Design Considerations
Lesson 6: Filtering Data
• Filtering a List
• Custom Criteria
• Multiple-condition Criteria
• Managing a Filtered List
Appendix A: Additional Topics
• Database Functions
• Excel Web Pages and the Internet or an Intranet

Microsoft Excel 2007: Level III
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:
• Customize toolbars and create styles and templates.
• Create decision-making functions.
• Analyze worksheet data by creating pivot tables.
• Compare and contrast workbook files and file links.
• Outline and consolidate worksheets and analyze worksheet data by using the Scenario
Manager.
• Display and protect worksheet data by locking cells.
• Record and modify macros by using the Visual Basic Editor.
• Create and work with interactive Web documents.
Course description
Overview: Students will learn various advanced techniques for analyzing and manipulating data
in Excel 2007 . This course meets the Microsoft Proficiency Guidelines for Excel 2007 at
the Expert level.
Prerequisites: Windows 98: Introduction and Excel 2007 : Worksheets, or equivalent
knowledge.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to work with advanced features of Excel 2007 .
Target student: Students enrolling in this course should understand the basic concepts involved
in using Excel 2007 . For example, they should be familiar with data types (text and values),
copying data, basic formulas and functions, and opening and saving files.
What's next: Excel 2007 : Advanced is the last course in this series.
Course content
Lesson 1: Customizing the Work Area
• Working with Built-in Toolbars
• Using Custom Toolbars
• Creating and Using Styles
• Using Templates
Lesson 2: Advanced Formula Construction
• Using Names
• Using the IF Function
• Using the VLOOKUP Function
• Using IS Functions and the Auditing Features
Lesson 3: Using Pivot Tables
• Creating Pivot Tables
• Modifying Pivot Tables
• Grouping and Summarizing Data in a Pivot Table
• Creating Interactive Pivot Tables for the Web
Lesson 4: Working with Multiple Worksheets
• Working with Workbooks
• Linking Cells in Different Workbooks
• Workbook Versus Links and Workspaces
• Sharing and Merging Workbooks
Lesson 5: Consolidating and Analyzing Data
• Consolidating Data from More Than One Worksheet
• Using the Goal Seek and Solver Utilities
• Using Scenario Manager to View a Worksheet with Different Input
Values
Lesson 6: Using Protection and Display Options
• Using Comments
• Protecting Workbooks
• Using Custom Views
Lesson 7: Introduction to Macros
• Running Macros
• Recording a Macro
• Viewing and Editing VBA Code
Lesson 8: Working with Interactive Excel Web Documents
• Saving Excel Worksheets as Web Documents
• Spreadsheet Web Components

Microsoft Access 2007 : Level I
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:
• Understand database concepts and terminology in Access 2007 .
• Design and create tables.
• Enter and manipulate data in tables.
• Use Access queries to select and analyze information in a table.
• Create data forms for viewing and inputting data.
• Create reports that summarize and group data.
• Perform database maintenance procedures.
Course description
Overview: Students will learn the basic skills necessary to begin using Access 2007 . They
will design and create databases, tables, queries, forms, and reports. This course contributes
toward the Microsoft Proficiency Guidelines for Access 2007 .
Prerequisites: Windows 95: Introduction; Windows 98: Introduction; or 98: Making the Transition,
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to create and use database objects, including tables, queries,
forms, and reports.
Target student: Students enrolling in this course should understand the basic concepts involved
in working with a personal computer (PC). For example, students should be familiar with terms
such as computer memory, data files, and program files. Students should also be familiar with the
components that make up the PC, including input, output, and storage devices. Students should
also be fairly comfortable working in the Windows environment. No prior knowledge of databases
or Access is assumed.
What's next: Access 2007 : Level 1 is the first course in this series. Level 2 database designs
by using the principles of normalization and table relationships. Students also learn how to query
multiple tables for data that is used in customized forms and reports. Students who want to learn
advanced features can take the third course in this series, Access 2007 : Advanced. In that
course, students learn to create advanced queries, create more efficient forms and reports, and
work with macros. The final course in this series, Introduction to Application Design applications.
Course content
Lesson 1: Overview of Access 2007
• Introduction to Database Concepts and Terminology
• Introduction to Access 2007
• Database Planning and Design

Lesson 2: Creating Tables
• Examining a Table
• Creating a Table With the Table Wizard
• Creating a Table in Design View
• Types of Primary Keys
Lesson 3: Working with Tables
• Modifying a Table Using Design View
• Finding and Editing Records
• Filtering and Sorting Records
Lesson 4: Creating and Using Select Queries
• Creating a Select Query to View Specific Fields
• Specifying Criteria in a Query to View Specific Records
• Using Queries to Perform Calculations
• Joining Tables in a Query
Lesson 5: Creating and Using Forms
• Creating a Form With the Form Wizard
• Modifying the Form Design
• Using a Form to Locate and Organize Information
• Multiple-Table Forms
Lesson 6: Creating and Using Reports
• Creating a Report With the Report Wizard
• Creating a Report That Contains Totals
Lesson 7: Creating and Maintaining a Database
• Creating a Database
• Managing a Database and Its Objects
• Database Maintenance

Microsoft Access 2007 : Level II
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:
• Normalize tables through fifth normal form.
• Establish relationships between tables and enforce referential integrity.
• Maintain data integrity in tables by setting properties, creating a Lookup list, and creating
indexes.
• Use queries to calculate expressions and extract data from multiple tables.
• Improve form designs by adding bound controls, calculated fields, and a combo box.
• Create and modify data access pages, and integrate data with other applications.
• Create and modify reports with the Report Wizard and Design view, add a subreport. And
add a calculated control.
Course description
Overview: Students will learn how to enhance database designs by using the principles of data
normalization, table relationships, and referential integrity; by querying multiple tables for data
used in customized forms, reports, and subreports; and by creating data access pages. This
course meets many of the Microsoft Proficiency Guidelines for Access at the Expert level.
Prerequisites: The prerequisite for this course is Access 2007 : Level 1 or equivalent
knowledge.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to take the guesswork out of creating databases by using data
normalization techniques. They will learn how to take advantage of relational database efficiency
to maintain data by establishing relationships and enforcing referential integrity. In addition,
students will save data entry time by using sound table design techniques to control data entry
and automate tasks. Students will also benefit by becoming familiar with Access features that will
enable them to customize forms and reports, and to share data over an intranet or the Internet by
creating and using data access pages.
Target student: Students enrolling in this course should have a basic level of understanding of
the Access 2007 interface, and should have experience designing tables, simple queries,
forms, and reports.
What's next: Access 2007 : Level 2 is the second course in this series. Access 2007 :
Advanced, the next course in this series, teaches students how to use a variety of query
techniques, and how to create more efficient forms and reports, and macros. After taking the
Advanced course, students who want to learn how to develop an application and tie the objects
together into a cohesive system by using macros and Visual Basic for Applications code can take
Access 2007 : Introduction to Application Development.
Course content
Lesson 1: Principles of Table Design
• Normalizing Data
• Normalizing Data for Fourth and Fifth Normal Forms
Lesson 2: Principles of Table Relationships
• Analyzing Table Relationships
• Establishing and Testing Referential Integrity
Lesson 3: Table Design Techniques
• Data Validation Techniques
• Indexing Techniques
Lesson 4: Designing Select Queries
• Using Calculated Fields in Queries
• Creating Multiple-Table Queries
Lesson 5: Customizing Form Designs
• Customizing the Form Design
• Performing Calculations on a Form
• Adding Combo Boxes to a Form
• Adding Unbound Controls
Lesson 6: Working with Data Access Pages
• Creating Data Access Pages
• Integrating with Other Applications
Lesson 7: Customizing Reports
• Customizing a Report Created by the Report Wizard
• Working with Subreports
• Creating a Report in Design View

Microsoft Access 2007 : Level III
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:
• Make select queries more versatile and useful by using parameters; use action queries to
update data values and add or delete records.
• Generate different query types by creating various types of joins between tables; use
crosstab queries to summarize data.
• Use advanced form features including properties, functions, and design tools to facilitate
data entry and improve accuracy in forms; display table information that has a one-tomany
relationship by creating forms that contain subforms.
• Automate tasks by creating macros to open forms and control form properties.
• Make forms more functional by using macros to provide user interaction and automate
data entry.
• Make reports more concise and easier to understand by using properties and functions in
report controls.
• Use Internet-related Access tools by inserting hyperlinks and using the Web toolbar;
integrate Access data with other Office 2007 applications.
Course description
Overview: Students will learn how to use a variety of complex query techniques, create more
efficient forms and reports, and create and use macros to automate their forms. In addition,
students will gain experience with Internet-related features, including hyperlinks and the Web
toolbar. This course meets the Microsoft Proficiency Guidelines for Microsoft Access at the Expert
level.
Prerequisites: Access 2007 : Level 1 and Access 2007 : Level 2 or equivalent
knowledge.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to analyze data by creating complex queries, make forms and
reports more efficient, speed repetitive tasks by creating macros, and become familiar with
Internet-related Access tools.
Target student: Students enrolling in this course should be able to work with Access at an
intermediate level and understand Access terminology.
What's next: Access 2007 : Introduction to Application Development, the next course in this
series, teaches students how to develop custom applications by using Access.
Course content
Lesson 1: Parameter and Action Queries
• Creating Parameter Queries
• Creating Action Queries
Lesson 2: Query Joins and Crosstab Queries
• Joining Tables and Working with Join Properties
• Creating Crosstab Queries
• Editing Limitations in Query Datasheets
Lesson 3: Using Advanced Form Techniques
• Organizing Field Placement
• Using Functions to Control Data Entry
• Adding an Option Group to a Form
• Using a Form as the User Interface
• Creating a Form that Contains a Subform
Lesson 4: Creating Basic Macros to Automate Forms
• Macro Basics
• Attaching a Macro to a Command Button
• Revising a Macro
Lesson 5: Using Macros to Provide User Interaction and Automate Tasks
• Using a Macro to Provide User Interaction
• Using a Macro to Automate Tasks
• AutoKeys and AutoExec Macros
Lesson 6: Using Advanced Report Techniques
• Customizing the Appearance and Functionality of a Report
Lesson 7: Web Capabilities and Data Integration
• Using Hyperlinks
• Data Integration

Microsoft Publisher 2007
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:
• Navigate in the Microsoft Publisher environment.
• Create new multi-page documents.
• Import text and graphics from other applications.
• Format text using fonts, sizes, type styles, and line spacing.
• Use alignments, tabs, and indents to align text.
• Create common elements such as page numbers and design guides that will appear on
each page of a document.
• Create documents containing multiple columns.
• Flow several independent stories throughout a document.
• Wrap text around graphics.
Course description
Overview: Students will learn to use Microsoft Publisher to create a multiple-page document.
Prerequisites: Basic knowledge of the Windows operating system.
Delivery method: Instructor-led in live classroom, or through ZDU.
Benefits: Students will learn to create customized documents from scratch. Students will create a
multi-page document, import and format text and graphics, and create the document's layout.
Target student: This course is designed for students who have little or no experience using
Microsoft Publisher 2007 , but who have a basic understanding of how to use their computer's
operating system to launch and work with programs in order to create documents.
What's next: Microsoft Publisher 2007 for Windows is the only course in this series.
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

Microsoft FrontPage 2007: Level I
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:
• Create a new FrontPage web.
• Create links between and within web pages.
• Apply formatting to characters and paragraphs and apply themes
• Insert, size, align, and link images
• Create, modify, and enhance a table
• Perform basic web page management techniques
Course description
Overview: Students will learn how to create documents with an HTML format, connected by
hypertext, for use on the World Wide Web or on a corporate intranet.
Prerequisites: Windows 98: Introduction or Windows 98: Making the Transition. Microsoft Word
2007 : Level 1 and Microsoft Word 2007 : Level 2. Internet Explorer 4.0: Introduction.
Recommended but not required: HTML 4.0 Programming: Level 1. It is also recommended that
students have Web surfing experience.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to create and edit webs and web pages; apply paragraph and
character formatting to web pages; create links between and within pages; create links to the
World Wide Web; create a Navigation bar; insert and create links from images; insert and format
tables; and import, rename, delete, and publish a web.
Target student: Students enrolling in this course should understand the Windows environment,
word processing, and how to use a Web browser.
What's next: FrontPage 2007 : Introduction is the first course in this series. FrontPage
2007 : Advanced, the next course in this series, teaches students how to use the advanced
features of FrontPage 2007 and other Web-based components.
Lesson 1: Introduction to FrontPage
• Viewing a Completed Web
• Overview of the FrontPage Environment
• Creating a Web Page
Lesson 2: Linking Web Pages
• Creating Internal Links
• Creating External Links
• Creating a Navigation Bar

Lesson 3: Enhancing Web Pages
• Formatting Text on a Web Page
• Applying Themes
Lesson 4: Adding Pictures to a Web Page
• Inserting Pictures
• Using Pictures with Hyperlinks
Lesson 5: Working with Tables
• Creating a Table
• Modifying a Table
• Enhancing a Table
Lesson 6: Introduction to Web Page Management
• Importing a Web
• Viewing and Organizing Web Site Documents
• Keeping a Web Site Up-to-date
• Publishing Your Webs

Microsoft Outlook 2007: Level I
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:
• Identify the elements of the Outlook application window and explore Outlook
components.
• Send, receive, and act on mail messages.
• Use additional message-handling options, insert text into a message, and create multiple
Signatures.
• Create personal folders and organize Outlook 2007 folders.
• Create, edit, and categorize single appointments and recurring appointments and create
events.
• Create, send, and manage meeting requests.
• Create, edit, and assign tasks, and create and edit contacts.
Course description
Overview: Students will learn the fundamentals of using Outlook 2007 to coordinate mail,
appointments, events, meetings, tasks, and contacts.
Prerequisites: Windows 95: Introduction, Windows 95: Making the Transition, Windows NT
Workstation 4.0: Orientation, Windows 98: Introduction, Windows 98: Making the Transition, or
equivalent knowledge.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to send and receive mail, schedule appointments, insert
events, schedule meetings, create and manage tasks, and organize contacts.
Target student: Students enrolling in this course should be familiar with Windows 95, Windows
98, or Windows NT Workstation 4.0.
What's next: Outlook 2007 : Level 1 is the first course in this series. Outlook 2007 : Level
2, the next course in this series, teaches students advanced mail, contacts, and journal features;
how to create forms and templates; how to customize the Outlook 2007 environment; and
how to use remote mail and the Internet features of Outlook 2007 . Students who want to
learn advanced features can take Outlook 2007 : Level 2.

Course content
Lesson 1: Getting Started with Outlook 2007
• Overview of Outlook 2007
• Overview of Outlook Today

Lesson 2: Using Mail
• Creating and Sending Messages
• Acting on Messages
• Working with Address Books
• Recalling and Printing
Lesson 3: Handling Messages
• Message Handling Options
• Inserting Text into a Message
• Creating Signatures
Lesson 4: Managing Folders
• Creating and Using Personal Folders
• Using the Organize Page
Lesson 5: Working with Appointments and Events
• Scheduling Appointments
• Assigning Categories
• Editing Appointments
• Inserting Events
Lesson 6: Scheduling and Managing Meetings
• Creating and Sending Meeting Requests
• Working with Meeting Requests
• Managing Meeting Responses
Lesson 7: Managing Tasks and Contacts
• Managing Tasks
• Adding and Editing Contacts
Appendix A: Internet Features
• Viewing Web Pages in Outlook
• Publishing Your Calendar as a Web Page

Microsoft Outlook 2007: Level II
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:
Manage and arrange Outlook items by sorting, filtering, and using the Advanced Find feature; by
displaying custom views; and by creating custom forms. Students will also be able to set rules in
a folder by using the Rules Wizard.
Customize the Outlook environment by creating custom toolbars and menu items to add to the
Outlook Bar. Students will be able to share contacts with other users, send a fax to a contact,
automatically record items associated with contacts in the Journal by setting options, and use
notes.
Create and use templates and forms.
Integrate Outlook 2007 with Office applications by importing and exporting Office documents,
creating an Office document in Outlook, and sending an Outlook message from Office
applications.
Share information with other Outlook users by creating, replying to, and editing posts in public
folders; creating and posting to Net Folders; and granting other Outlook users folder permissions.
Investigate Internet and remote mail features by accessing Internet Explorer from Outlook,
creating Outlook items in Internet Explorer, creating messages in HTML format, adding
hyperlinks, and discussing Microsoft NetMeeting, the Outlook Newsreader, and remote mail
options.
Course description
Overview: Students will learn how to sort, filter, and group items; use and create Outlook
templates and forms; and share information by using public folders and Net Folders. Students will
also learn how to share and fax contacts, automatically record activities in the Journal, and
customize the Outlook environment. This course meets the Microsoft Proficiency Guidelines for
Outlook 2007 at the Expert level.
Prerequisites: Windows 95: Introduction, Windows 95: Making the Transition, Windows 98:
Introduction, or Windows NT Workstation 4.0: Orientation; Internet Explorer 4.0: Introduction;
Outlook 2007 : Level 1, or equivalent knowledge.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to use more in-depth features of Outlook, including rules,
templates, folders, customization, and recording entries in the Journal.
Target student: Students enrolling in this course should have a basic understanding of the
Internet and the basic features of Outlook 2007 , including how to create and send email
items, schedule meetings, and create personal folders. Students should also have the
background to work comfortably in the operating system.

Course content
Lesson 1: Arranging Messages and Applying Rules
• Sorting, Finding, and Filtering Messages
• Setting Rules in a Folder by Using the Rules Wizard
• Working with Views
Lesson 2: Customizing the Outlook Environment
• Customizing the Outlook Bar
• Customizing Menus and Toolbars
Lesson 3: Working with Contacts, the Journal, and Notes
• Sharing Contact Information
• Contact Activity Tracking
• Overview of the Outlook Journal
• Using the Notes Feature
Lesson 4: Using Templates and Forms
• Using Templates and Forms
• Creating Custom Forms
Lesson 5: Integrating Outlook Components and Other Office Applications
• Integrating Outlook Components
• Importing and Exporting Data from Office Applications
• Integrating Office Documents and Outlook
Lesson 6: Sharing User Information by Using Folders
• Overview of Public Folders
• Overview of Net Folders
• Working with Permissions
Lesson 7: Internet and Remote Mail Options
• Internet Explorer 5.0 Integration
• Folder Home Pages
• Creating a Message in HTML Mail Format and Inserting a Hyperlink
• Communicating on the Internet with NetMeeting

Microsoft PowerPoint 2007: Level I
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:
• Start the PowerPoint program, identify on-screen features, and navigate through a
presentation.
• Create and edit bullet slides.
• Use PowerPoint’s drawing tools to create a slide.
• Incorporate clip art and WordArt objects in a slide.
• Create and enhance organization charts, and create and edits charts by using Microsoft
Graph.
• Change the overall appearance of a presentation by using design templates and the
Slide Master.
• Run a slide show, become familiar with slide show options, and add notes to a slide.
• Preview and save a PowerPoint presentation as a Web page and open a locally stored
presentation in Internet Explorer.
Course description
Overview: Students will learn the basic skills necessary to begin effectively creating
presentations in Microsoft PowerPoint.
Prerequisites: Windows 95: Introduction; Windows 98: Introduction; or Windows NT 4.0:
Introduction, or equivalent knowledge.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to create and edit bullet slides, use PowerPoint’s drawing tools,
incorporate clip art and WordArt, create and enhance organization charts, and create and edit
charts by using Microsoft Graph.
Target student: Students enrolling in this course should understand the basic concepts involved
in working with a personal computer (PC). For example, students should be familiar with terms
such as computer memory, data files, and program files. Students should also be familiar with the
components that make up the PC, including input, output, and storage devices. No prior
knowledge of PowerPoint is assumed.
What's next: PowerPoint 2007 : Introduction is the first course in this series. PowerPoint
2007 : Advanced, the next course in this series, teaches students how to work with templates
and multimedia, how to customize toolbars, how to use the AutoCorrect and Style Check
features, and how to collaborate on the Web.
Course content
Lesson 1: Introduction to PowerPoint
• Opening a Presentation
• Exploring the PowerPoint Window
• Exploring Different PowerPoint Views
Lesson 2: Beginning a Presentation
• Creating Title and Bullet Slides
• Creating Slides in Outline View
• Modifying Slide Text
• Checking Spelling
Lesson 3: Drawing Tools
• Working with Drawing Tools
• Working with Text and Drawn Objects
• Enhancing Drawn Objects
Lesson 4: Clip Art and WordArt
• Using Clip Art
• Inserting a Table
• Using WordArt
Lesson 5: Organization Charts and Microsoft Graph
• Creating an Organization Chart
• Organization Chart Options
• Orientation to Microsoft Graph
• Editing a Column Chart
Lesson 6: Templates and the Slide Master
• Selecting a Template
• Changing Text and Bullets in the Slide Master
• Removing Slide Master Objects and Adding a Footer
Lesson 7: Slide Shows, Output, and Presentation Options
• Slide Show Options
• Adding Transitions and Animation to a Slide Show
• Running a Manual and an Automatic Slide Show
• Working with Notes
• Printing a Presentation
Lesson 8: Preparing Presentations for the Web
• Using the AutoContent Wizard
• Saving Presentations for Internet Delivery and Viewing

Microsoft PowerPoint 2007: Level II
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:
• Explore design and template presentations, create their own template, and use their own
template.
• Insert and modify clip art, customize object animations, and insert a movie and sound.
• Insert Office objects, create slides from an outline, and send slides to Microsoft Word.
• Customize PowerPoint toolbars, explore customization options, automate slide
production, and user AutoCorrect and the Style Checker.
• Create hyperlinks, create interactive objects, work with slide show options, and use the
Meeting Minder.
• Explore the concept of online meetings, explore broadcasting a presentation, and explore
delivering presentations.
Course description
Overview: Students will learn advanced features of PowerPoint, including customizing templates
and the PowerPoint environment and making a presentation interactive by using hyperlinks and
action buttons.
Prerequisites: Windows 95: Introduction, Windows 98: Introduction, or Windows NT 4.0, and
PowerPoint 2007 : Introduction, or equivalent knowledge.
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to enhance a presentation by using custom clip art, animation,
and movies and work with embedded and imported objects by using Microsoft applications.
Target student: Students enrolling in this course should have a working knowledge of
PowerPoint, as well as a basic understanding of word processing and spreadsheet concepts.
Course content
Lesson 1: Working with Templates
• Working with Presentations
• Creating a Template
• Working with a Design Template
Lesson 2: Working with Multimedia
• Working with Graphics and Multimedia
• Working with Animation
• Inserting Movies and Sound
Lesson 3: Working within the Office Suite
• Inserting Office Objects
• Creating Slides from an Outline
• Sending Slides to Microsoft Word
Lesson 4: Additional PowerPoint Features
• Customizing PowerPoint Toolbars
• Other Customization Options
• Automating Slide Production
• Using AutoCorrect and the Style Checker
Lesson 5: Building Interactive Presentations
• Creating Hyperlinks
• Creating Interactive Objects
• Working with Slide Show Options
• Using the Meeting Minder
Lesson 6: Collaborating on the Web
• Exploring Online Meetings
Broadcasting Presentations

Dreamweaver – Web Site Design
Adobe (formerly Macromedia) Dreamweaver is the industry standard for visual web development. It provides unrivalled facilities for the creation of sophisticated pages, while offering a user-friendly interface and excellent productivity tools.
Dreamweaver training courses at Canada College will teach you the most important and up to date skills and techniques, including stylesheets and how to begin optimising pages for accessibility and search engines. Our Dreamweaver courses range from introductory to advanced levels and training can be tailored to cover a wide range of related topics.

Course Outline:
Lesson 1
Sorting a Table
Modifying a Table
Exporting a Table
Using Images in a Table
Nesting Tables
Outlining a Table

Lesson 2
Designing for different screen sizes
How to use a Trace Image
Adding User Interactivity
Inserting a Rollover Image
Adding Behaviours
Swapping Multiple Images with One Event
Adding Behaviours to Image Maps
Editing Actions and Events

Lesson 3
Creating a Status-Bar Message
Checking the Browser
Opening a New Browser Window
Creating a Pop-up Menu
Managing Your Site
Using the Site Window
Integrated File Explorer
Adding New Folders and Files to a Site
Creating a Site Map
Viewing a Subset of the Entire Site

Lesson 4
Links in Site Map View
Modifying Pages from the Site Window
Connecting to a Remote Site
Uploading Files
Cloaking
Checking In and Checking Out
Using Design Notes
Testing Your Site
Checking Browser Compatibility
Checking Links in Your Site
Checking for Orphaned Files
Generating Reports for a Site

Lesson 5
Creating a Library Item
Placing Library Item on a Page
Recreating a Library Item
Modifying a Library Item
Updating Library References
Creating a Library Item Containing Behaviours
Modifying a Library Item Containing Behaviours
Using Templates
Creating Templates
Adding Editable Areas to a Template
Removing Editable Regions
Creating Optional Content
Inserting Repeating Regions

Lesson 6
Building Pages Based on a template
Controlling Optional Content
Adding Repeating Entries
Modifying a Template
Creating Editable Tag Attributes
Modifying an Editable Tag Attribute
Creating Nested Templates
Creating Frames
Creating a Frameset
Saving a Frameset
Resizing Frames in a Frameset
Specifying Frame Properties

Introduction to Bookkeeping
Performance Objectives:
Upon completion of the course, the student will be able to do the following:
• Describe the benefits, eligibility requirements, code of ethics, and maintenance requirements for the Certified Bookkeeper.
• Apply the concepts of accrual accounting to transactions that span fiscal periods.
• Trace the effect of accrual and deferral transactions to financial statements.
• Apply accounting concepts and the basic tools of financial analysis in identifying and correcting errors.
• Apply accounting principles in reconciling bank accounts.
• Apply accounting concepts in preparing payroll transactions, from paying wages to depositing and reporting taxes.
• Apply accounting concepts to depreciation transactions including various methods of calculating depreciation for book and tax purposes.
• Apply accounting concepts to valuing inventory, recording costs, making entries and reporting inventory on financial statements.

Course Outline:
I. Certified Bookkeeper Program
A. Eligibility requirements
B. Testing program
C. Code of ethics
D. Maintenance of certification

II. Accruals, Deferrals, and the Adjusted Trial Balance.
A. Why accruals, deferrals, and other adjustments are made
B. Accruing revenues and expenses
C. Recognizing revenues collected in advance
D. Recognizing expenses after a prepayment
E. Other adjusting entries
F. Unadjusted trial balance through the adjusted trial balance

III. Correction of Accounting Errors and the Bank Reconciliation
A. When and where accounting errors occur and how they are found
B. Performing the bank reconciliation
C. Finding and correcting errors on the unadjusted trial balance
D. Correcting current-period accrual and deferral errors

IV. Payroll
A. How to pay different kinds of employees
B. Federal and state wage-hour law
C. Paying employees under federal law
D. Employment records and payroll recordkeeping
E. Form W-4 and comparable state forms
F. Withholding and depositing federal taxes
G. Federal employment reporting forms and due dates
H. When wages become taxable
I. Other reporting rules
J. Payroll register and journal entries

V. Depreciation
A. The difference between book and tax depreciation
B. Depreciation under GAAP
C. Computing and allocating depreciation
D. Depreciation under federal tax depreciation rules
E. Tax depreciation of vehicles

VI. Inventory
A. General concepts of accounting for inventory
B. The perpetual method
C. The periodic method
D. Weighted-average and moving-average methods
E. First-in, first-out (FIFO) method
F. Last-in, last-out (LIFO) method
G. Lower of Cost or market (LCM) rule

Phone: 514-868-6262, 514-935-3106, 994-7976
Fax: 514-868-0869
E-mail: apply AT collegecanada.com