These courses are hands-on and designed to provide participants with a solid understanding of Microsoft Access 2003. In the courses, participants will gain an understanding of the capabilities of Access and how they can be applied to solve common business problems. Included with all courses are course notes, a pad for note taking and telephone support following the class.
Duration: 2 Days - 9:00 A.M. until 4:00 P.M.
Cost: $425 plus HST
Creating a database including:
Database terminology
Planning and designing your database
Getting HELP
Creating your table
What is a Primary Key
Examining the structure & contents
Adding information
Controlling data entry
Formatting a table including:
Editing your information
Viewing all and selective information with filters
Finding specific information
Deleting information
Changing the contents of your table
Modifying the structure of your table
Sorting your information
Adding data through a form
Creating entry forms
Selecting your information including:
Specifying criteria
Retrieving information with a Select Query
Options for specifying information in a query
Saving and running your queries
Printing your information including:
Types of reports
The Report Wizard
Creating the report structure
Adding Totals to a report
Using a query to select the data for the report
Duration: 1 Day - 9:00 A.M. until 4:00 P.M.
Cost: $225 plus HST
More on queries including:
Testing for Empty Field Values
Creating and using calculated Fields
Parameter Queries
Make-Table, delete, append and update queries
Multiple-table queries
Customizing Forms/Screens including:
Creating a form with the Wizard
Customizing a form
Positioning fields on a form
Creating calculated fields
Adding buttons including combo boxes
Creating a form from more than one table
Expressions in reports including:
Creating calculated fields
Combining Text Values
Calculating Totals
More on report formatting
Working with sub-reports
More on tables including:
Analysing table relationships
Creating and deleting relationships
Establishing referential integrity
Data validation
Data Access Pages
Importing and exporting data
Duration: 1 Day - 9:00 A.M. until 4:00 P.M.
Cost: $225 plus HST
Creating and using the Switchboard:
Creating a menu driven application
Creating a Switchboard
Modifying Switchboard pages
Modifying Switchboard items
Using a Switchboard
Macros including:
What is a macro?
Creating, saving and running a macro
Using conditions
Troubleshooting
Advanced features including:
Advanced form techniques
Specifying conditions in macros
Building an event to trigger an activity
More on relationships including:
Many to Many
Using a Junction table
Referential Integrity
Database utilities including:
Compacting
Repairing
Encrypting
Adding passwords and user security
Access and the Internet including:
Saving a static html page for your web site
Access tools for working on the Internet
These courses are hands-on and designed to provide participants with a solid understanding of Microsoft Excel. Included will all courses are course notes, a pad for note taking and telephone support following the class. In the courses, participants will gain an understanding of the capabilities of Excel and how they can be applied to solve common business problems.
Duration: 1 Day - 9:00 A.M. until 4:00 P.M.
Cost $195 plus HST
Creating a worksheet including:
Moving around the display screen
Obtaining HELP
Entering words & numbers and building formulas
Editing words, numbers, & formulas
Clearing versus deleting cells
Copying, and moving words, numbers, & formulas
Formatting your numbers
Enhance the worksheet including:
Inserting & deleting cells, columns & rows
Increasing & decreasing the column width
Changing the appearance of your numbers
Aligning your text
Saving and retrieving your work
Viewing large worksheets
Adding lines and shading
Printing your work including:
Setting margins, headers and footers
Selecting the cells to print
Setting print titles
Previewing before printing
Miscellaneous features including:
Exploring the FUNCTIONS
Using the function wizard
Absolute and relative cell addressing
Filling in a series of values
Duration: 1 Day - 9:00 A.M. until 4:00 P.M.
Cost $195 plus HST
Working with multiple sheets including:
Creating multiple sheets
Moving between sheets
Naming your sheets
Inserting and deleting sheets
Creating formulas between sheets
Group mode
More Excel fundamentals including:
Making use of Paste Special
Using range names to streamline your work
Headers and footers
Printing all or portions of the spreadsheet
Charting including:
Planning and selecting the type of chart
Specifying the X-axis and data ranges
Setting the options for your chart
Changing the chart type
Adding a legend
Naming and printing your chart
Using graphic objects to enhance your chart
Database features including:
Sorting your information
Summing totals
Filtering your data with Auto filter
Filtering your data with Advanced options
Using a form
Creating calculations with the database functions
Duration: 1 Day - 9:00 A.M. until 4:00 P.M.
Cost $195 plus HST
Streamlining with macros including:
What is a macro
Creating and editing a macro
Documenting, invoking and cancelling a macro
Useful everyday macros
Assigning macros to the toolbar
Assigning macros to buttons and quick keys
Saving your macros
Advanced formula creation including:
Using the IF function
Using vertical and horizontal lookups
Working with date functions
Using auditing features
Testing for NA
Customizing the work area including:
Customizing the toolbars
Creating your own toolbars
Creating styles
Creating templates
Protecting your worksheets
Using Data validation
Creating lookups
Miscellaneous features including:
Creating pivot tables
Creating pivot table from multiple ranges
Modifying your pivot table
Creating scenarios
Using goal seek and solver
Tips and tricks
Excel and the Internet
These courses are hands-on and are designed to provide participants with a solid understanding of FrontPage 2003. Class runs a day in length from 9:00 until 4:00. Included with all course are course notes, a pad for note taking and telephone support following the class.
In the course, participants will gain an understanding of the capabilities of FrontPage and how they can be applied.
Introduction
Starting out including:
Web basics and concepts
Starting out in the FrontPage Explorer
Understanding the Views in Explorer
Adding and linking pages
Applying a theme
Working with pages
Adding text and images to a page
Formatting text
Saving your work
Defining hyperlinks including:
Creating an automatic hyperlink
Text-based links
E-mail, bookmarks, and URL links
Creating an image map
Creating image hotspots
Page editing features including:
Inserting tables and frames
Inserting bullet and numbered lists
Placing text over images
Adding an active element
Creating feedback forms
Previewing your work
Publishing your web including:
The folders view
Spell checking and verifying hyperlinks
Publishing the personal web
These courses are hands-on and are designed to provide participants with a solid understanding of PowerPoint 2003. Each class runs a day in length from 9:00 until 4:00. Included with all courses are course notes, a pad for note taking and telephone support following the class.
In the course, participants will gain an understanding of the capabilities of PowerPoint and how they can be applied to create effective presentations.
Introduction
Duration: 1 Day - 9:00 A.M. until 4:00 P.M.
Cost $195 plus HST
Starting out including:
The PowerPoint window
The toolbars
Quick keys and shortcuts
PowerPoint Views
Accessing commands
Using HELP
Enhancing the presentation:
Moving, copying and sizing
Modifying and/or applying a different template
Adding ClipArt and Pictures
Changing the slide colour scheme
Choosing the right slide layout
Changing font styles, size and attributes
Adding headers and page numbers
Enhancing a slide with the drawing tools
Spell checking
Creating a presentation:
Using the AutoContent Wizard
Adding a templates
Creating a blank presentation
Creating a bullet slide with options
Creating a table slide with options
Creating an org chart with options
Creating a chart with options
Showing your presentation including:
Previewing and sorting slides
Adding transitions to each slide
Adding movement to items on each slide
Running your slide show
Printing notes, handouts and outlines
Saving and retrieving your presentation
Duration: 1 Day - 9:00 A.M. until 4:00 P.M.
Cost $195 plus HST
Making changes including:
Modifying slide master, handout and notes master
Changing the default template
Applying different looks to the same presentation
Creating your own templates
Taking your presentation on the road
Adding animation to your slides
Branching between presentations
Draw features including:
Aligning and grouping objects
Rotating/flipping
Creating 3-D objects
Send backward and forward
Creating special effects with text
Using colour and special effects
Miscellaneous features including:
Changing defaults and modifying toolbars
Linking and embedding objects
Advanced slide layout features
Setting tabs with the ruler
Collaborating on the web
Saving as an HTML file
Adding video and sound (if available)
Microsoft Project 2007 Introduction
This course is hands-on and designed to provide participants with a solid understanding of the functions and benefits of Microsoft Project 2000. Each class runs a day in length from 9:00 until 4:00. Included with all courses are course notes, a pad for note taking and telephone support following the class.
In the courses, participants will gain an understanding of the capabilities of Project and how they can be applied to solve common business problems.
Introduction
Duration: 2 Days - 9:00 A.M. until 4:00 P.M.
Cost $495 plus HST
Getting started including:
Understanding Project Management
The screen, menus and toolbars
Getting Help
Cue cards
Planning Wizards
Creating a Project including:
Starting a Project
Editing and rearranging information
Working with Project tasks
Assigning tasks
Establishing task relationships
Tracking Project status
Working with resources including:
Managing Project Resources
Scheduling
Assigning multiple resources to one task
Changing Working Time
Resource Workloads
Handling conflicts
Viewing a Project including:
Exploring the various views
Applying Project filters
Printing views and reports
Duration: 1 Day - 9:00 A.M. until 4:00 P.M.
Cost $225 plus HST
More on managing the Project including:
Adjusting project costs
Comparing costs using the cost table
Reducing costs
Restricting task start and finish dates
Resolving constraint conflicts
Adding resources to shorten the Critical Path
Changing the task relationship
Tracking Project progress including:
Tracking progress
Updating the schedule with actual information
Comparing results
Comparing baseline vs. actual
Changing task information
Adjusting the schedule for future tasks
Setting and displaying interim plans
Working with the multiple projects:
Organizing large or complex projects
Creating and using a resource pool
Working with subprojects and master projects
Miscellaneous features including:
Customizing tables, views and reports
Customizing the environment
Importing and exporting data
Customizing filters
This course is hands-on and designed to provide participants with a solid understanding QuickBooks. The class runs two days in length from 9:00 until 4:00. Included with all courses are course notes, a pad for note taking and telephone support following the class.
In the course, participants will gain an understanding of the capabilities of QuickBooks and how it can be applied to day-to-day accounting practices.
Introduction
Duration: 2 Days 9:00 A.M. until 4:00 P.M.
Cost: $395 plus HST
Getting started including:
Setting up QuickBooks
Working with lists
Your chart of accounts
Setting up what you buy and sell
Setting up your customers
Setting up your vendors and expenses
Day to day activities:
Entering sales and invoices
Receiving payments
Making deposits
Entering and paying bills
Track and pay sales tax
Working with bank accounts
Miscellaneous including:
Analysing financial data
Multi-currency
Setting up and using payroll
Paying payroll liabilities and taxes
Printing your information including:
Types of reports
Working with reports
Customizing forms
Simply Accounting Introduction
This course is hands-on and designed to provide participants with a solid understanding Simply. The class runs two days in length from 9:00 until 4:00. Included with all courses are course notes, a pad for note taking and telephone support following the class.
In the course, participants will gain an understanding of the capabilities of Simply and how it can be applied to day-to-day accounting practices.
Introduction
Duration: 2 Days 9:00 A.M. until 4:00 P.M.
Cost: $395 plus HST
Starting the package including:
Creating a directory to store company data
entering a company name
choosing the correct using date
moving through the menus; saving information.
Converting manual information including:
Reviewing chart of accounts; establishing start, conversion and finish dates; removing integration accounts; modifying, inserting and deleting accounts; entering historical balances; setting ledgers to ready.
Setting company defaults including:
Entering the company name and address; checking the company status; choosing a printer; setting cheque, invoice and statement capabilities; adjusting report parameters.
G/L, A/R, A/P journal entries including:
Entering journal information; editing and saving; exiting an entry; viewing entries; correcting journal entries.
Printing and saving including:
Printing reports to screen and printer; printing journals & financial statements; saving work.
Miscellaneous topics including:
Making copies of accounting information; preparing for new fiscal year; exporting to other packages.
Microsoft Word 2003: Introduction
These courses are hands-on and designed to provide participants with a solid understanding of Microsoft Word. Each class runs a day in length from 9:00 until 4:00. Included with all courses are course notes, a pad for note taking and telephone support following the class.
In the courses, participants will gain an understanding of the capabilities of Word and how they can be applied to solve common business problems.
Introduction
Duration: 1 Day - 9:00 A.M. until 4:00 P.M.
Cost $195 plus HST
Starting out including:
The keyboard and mouse
The display screen
Selecting options from the menu, icons or short-cut keys
Using HELP and the Office Assistant
The basics including:
Creating a document
Moving around in your document
Deleting information in your document
Inserting new information in your document
Undoing your actions
Bolding, underlining and centring text
Moving and copying information
Checking for spelling corrections
AutoCorrect, -Text, -Complete & -Format
Click and type
Using the thesaurus
Document naming
Saving and opening your document
Using a template
Inserting page breaks
Turning on page numbering
Formatting changes including:
The ruler
Adjusting your margins
Changing the line spacing
Setting tabs
Deleting custom tabs and moving tabs
Creating and using indents
Changing the size and style of your print
Printing your work including:
Previewing your work
Printing your document
Printing a page
Duration: 1 Day - 9:00 A.M. until 4:00 P.M.
Cost $195 plus HST
Using Words table feature including:
Inserting a table
Moving from cell to cell
Inserting/deleting rows and columns
Sizing rows and columns
Adding lines and shading
Formatting text and numbers, including rotation
Merging and splitting cells
Nesting a table
Creating forms with a table
More on formatting text including:
Creating, breaking and balancing columns
Inserting page numbers, dates and times
Inserting special characters
Creating a template
Basic headers and footers
Understanding section breaks
Using styles
Using Graphics including:
Boxes, lines and shading
Office Art and Clip Gallery
Inserting and sizing pictures and logos
Using the drawing features
Watermarks
Using Word's merge feature including:
Planning for a mass mailing
Preparing the data file and main document
Printing the documents
Creating labels/envelopes
Sorting your names
Duration: 1 Day - 9:00 A.M. until 4:00 P.M.
Cost $195 plus HST
Automating your work including:
Recording and running a macro
Saving your macros
Editing your macros
Creating and using Styles
Customizing the toolbar
Creating and using Autotext entries
Creating fill-in forms with templates
Advanced Formatting including:
More on headers and footers
Creating a Table of Contents
Creating an Index
Bringing and sending in/out data from Excel
Adding lines and boxes
Hyphenation, word spacing and keep together
Cross-references
Miscellaneous including:
Tips, tricks and traps
Creating multi level outlines
Bookmarks
Master documents
Annotations and revision marks
Creating a form field template
Word and the Web including:
Adding hyperlinks to a report
Creating a web page
Viewing and editing a web page
This is a hands-on course designed to provide users with the skills necessary to better understand the filing structure within their computer and allow them to more efficiently manage files in their directories. The course duration is one day from 9:00 - 12:00 or 1:00 4:00. Cost is $99 plus HST.
Specific goals are as follows:
Filing strategies
software filing versus project-based filing
understanding, planning and creating directories and subdirectories
file naming conventions
using filenames and/or extensions for organizing and identifying files
locating files by name, date, extension and size
Searching for A lost@
files
Using Windows Explorer and/or My Computer
creating the directory structure
copying, moving, renaming and deleting files
one at a time vs. groups of files
undeleting files, where possible
Utilities
backing up files
Scandisk
Defrag
virus checking
Computer Basics Starting Out
Computer Basics Starting Out is designed as a hands-on introduction to the world of personal computing for the novice. This course helps participants become familiar with computer terminology, understand the benefits of using a computer, and establish a foundation of computer skills on which they can build in the future. The course duration is one day from 9:00 - 4:00
Specific goals are as follows:
Your computer system including:
what a computer can do and cannot do
how a computer works
the parts of the computer system
the terminology
the keyboard
The basics of Windows including:
starting and ending a Windows session
the parts of the window screen
sizing, minimizing, and maximizing windows
managing directories, sub-directories and files
Windows applications including:
a look at email
a look at a word processor
a look at a spreadsheet
a look at a database
a look at the Internet
Microsoft Office - Level 2 (Evenings)Discountined
This course is for 15 hours; 3 hours a night for 5 nights and covers Word, Excel and PowerPoint. Approximately 6 hours are spent on Word and Excel each with the remaining 3 hours devoted to PowerPoint. This is designed for people already familiar with the basics of the three packages and want to learn more. The course covers:
Word:
More on the table feature including:
Inserting a table
moving around
inserting/deleting columns
adding lines and shading
formatting text & numbers
creating forms and templates with tables
The merge feature including:
Planning for a mass mailing
preparing the data file and main document
printing documents.
Using Graphics including:
Office Art and Clip Art
boxes, lines and shading
More on formatting text including:
Inserting page numbers, dates and times
inserting special characters
basic headers and footers
columns
Excel:
Multiple sheets including:
Creating multiple sheets; moving between sheets; naming sheets; inserting and deleting sheets.
More Excel fundamentals including:
Making use of paste special
range names
headers and footers
printing all or portions of your spreadsheet.
Charts including:
Planning and selecting the type of chart
specifying the X-axis and data ranges
setting the options
changing the chart type
Database features including:
Sorting your information, filtering your data with Auto filter, summing totals
PowerPoint:
Making changes including:
modifying slide master, handout and notes master
adding charts and org charts
tips on bullet slides
choosing the proper slide transition
animating slides
Enhancing your presentation:
Adding headers and page numbers
using the drawing tools
aligning and grouping objects
creating special effects with text
Simply Accounting Level 1(Evenings)Discountined
This is designed as an Introduction to Simply Accounting. The course length is 15 hours spread over 5 nights for 3 hours an evening. The cost is $195 and includes course notes. The course covers:
Starting the package including:
Creating a directory to store company data; entering a company name; choosing the correct using date; moving through the menus; saving information.
Setting company defaults including:
Entering the company name and address; checking the company status; choosing a printer; setting cheque, invoice and statement capabilities; adjusting report parameters.
Converting manual information including:
Reviewing chart of accounts; establishing start, conversion and finish dates; removing integration accounts; modifying, inserting and deleting accounts; entering historical balances; setting ledgers to ready.
G/L, A/R, A/P journal entries including:
Entering journal information; editing and saving; exiting an entry; viewing entries; correcting journal entries.
Printing and saving including:
Printing reports to screen and printer; printing journals & financial statements; saving work.
Miscellaneous topics including:
Making copies of accounting information; preparing for new fiscal year; exporting to other packages.