Teach-ict.com is a great software teaching and learning site that provides free training content for Microsoft Office and other applications. This site was developed by teachers, its coursework materials are high quality and are targeted to both students and teachers. Here are their Word Training Course Workbooks that cover Formatting techniques, Tabs, and Mail Merge.

Microsoft Word Training Course Workbooks

Workbook 1 - Formatting Techniques

This training workbook teaches you how to perform basic formatting techniques. You are asked to correct the Water.doc lesson document.

• Task Instructions (.doc)
• Water.doc

Workbook 2 - More Formatting Techniques

This training workbook teaches you how to perform further formatting techniques. You are asked to correct the Colliery.doc lesson document.

• Task Instructions (.doc)
• Colliery.doc

Workbook 3 - Learn How to Use Tabs

This training workbook offers you the opportunity to practice setting tabs. You are asked to correct the Tabs.doc lesson document.

• Task Instructions (.doc)
• Tabs.doc

Workbook 4 - Mail Merge #1

With this training workbook you will learn how to perform mail merge using data from an Access database and exporting into a letter in Word. Complete step-by-step directions for doing this are given in the Task Intructions document. The Wedding.doc and Wedding.mdb files are provided so you can use them to do the Mail Merge.

• Task Instructions (.doc)
• Wedding.doc
• Wedding.mdb

Workbook 5 - Mail Merge #2

This workbook gives you a second tutorial session to learn how to set up and perform a Mail Merge. After downloading the two f iles below, you will merge the data from the database file (Fancydress.mdb) into the correct sections on the pre-prepared letter (Fancydress.doc).

• Fancy dress.doc
• Fancy dress.mdb

Popularity: 23% [?]

Related Posts:

Excel Review Materials – Tutorials, Tips, Workbooks

In Word, How Do I…

Microsoft Access Training Course Workbooks

12 Free Office XP Training Manuals

Word 17 Word Tutorial Videos

Tags for this post>> Word

Teach-ict.com is a great software teaching and learning site that provides free training content for Microsoft Office and other applications. This site was developed by teachers, its coursework materials are high quality and are targeted to both students and teachers. Here are their Microsoft Access Training Course Workbooks that cover the following Access topics: creating a database, using fields, records, data types, primary keys, importing data, validation rules, creating and  using queries, creating forms from tables and queries, creating reports from tables and queries, reports with grouping, and formatting.

Microsoft Access Training Course Workbooks


Database Workbook 1 (.doc)

Learn how to create a new database using Access. The following skills are covered:

• Creating a simple database
• Creating & using tables
• Using data fields, records, data types, field sizes, primary key
• Importing data
• Validation
• Import file for Task 1 on page 9: Stock.txt
• Import file for Task 2 on page 13: Players.txt

Database Workbook 2 (.doc)

Learn how to use queries and create forms. The following skills are covered:

• Creating queries
• Using queries
• Creating forms from a table
• Creating forms from a query

Database Workbook 3 (.doc)

Continuing on from the first two workbooks, this workbook teaches how to create reports and formatting. The following skills are covered:

• Creating reports from tables
• Creating reports from queries
• Reports with grouping
• Formatting
• Import file to use: Holidays.txt
  

Database Workbook 4 (.doc)

This workbook goes through all of the skills taught in the first three workbooks and can be used as a learning session to bring all of these skills together.

• Import file to use: Pstock.txt

Database Task 5 – Data Validation (.doc)

Here is Task 5, where you will get to practice creating data validation rules. Answers are given so you can see if you have created your validation rules acurrately.

• Validation Answers (.doc)
• Revision.mdb

Database Task 6 – Queries (.doc)

This last task offers more learning material that demonstrates how to create and use queries.

• Revision.mdb

Popularity: 19% [?]

Related Posts:

Microsoft Word Training Course Workbooks

Free Microsoft Access Video Training

Excel Review Materials – Tutorials, Tips, Workbooks

Microsoft Access Tutorial

13 Access 2007 Tutorials

Tags for this post>> Access

InsideGraphics.com offers free graphics software tutorials and online training, tips, and tricks for Photoshop, Flash, Image Ready, and Corel Draw in the areas of animation, effects, art, drawing, colors, buttons, textures, patterns, digital, retouching, and designing. Here are their Flash Tutorials teaching you how to do lots of graphic effects, animations, and text effects using Flash.

Flash Tutorials from InsideGraphics.com


Main

• Sunset
• Chess Board
• Patterns
• Pendant
• Fish Tank
• Explode
• Fashion Designing
• Necklace
• Rings
• Making Flowers   Making Stone
• Simple Buttons Collage
• Page Curl
• Line Text
• Color Animation
• Simple Buttons
• Wave Effect
• Get Url
• Clock (Rotate)

Learning Tools

• Shape HInts
• Easing
• Frame by Frame – 1
• Shape Tween – 1
• Motion Guide
• Using Alpha
• Frame by Frame – 2
• Shape Tween – 2
• Onion Skin
• Shape Tween – 3

Text Efects

• Stretch & Fade
• Move & Fade
• Swing Project
• Zoom & Fade
• Fade & Change

Popularity: 18% [?]

Related Posts:

Photoshop Tutorials from Inside Graphics

Free Flash Ebook

17 Freely Available Flash eBooks

Free eBooks and Guides for Flash MX

Flash Tutorials in Many Categories

Tags for this post>> Flash

The Univeristy of Minnesota Duluth provides freely available self-paced Training documents and Workshops for web development and Dreamweaver. Here are their Dreamweaver Workshop Tutorials which will get you going with using Dreamweaver. These will teach you how to create a web site, work with images and hyperlinks, create and edit tables, use some management tools, and learn about Dreamweaver  behaviors in regards to JavaScript and PHP. A Dreameaver demo is available if you’d like to try this web development application before buying it.


Making Your First Web Page with Dreamweaver

In this beginning Dreamweaver tutorial you will learn how to create a simple Web page, adding content and hyperlinks, naming your files, and performing some basic exercises. 

• Adding and Changing Your Content
• Absolute and Relative Links
• Naming Files for the Web
• Viewing Your Web Page in a Browser
• Creating a Site
• Letting the World See Your Page
• Basic Web Page Exercise

Taking Dreamweaver to the Next Level

Using this tutorial workshop, you will learn to insert and manipulate images, and create and edit tables.

• Inserting an Image
• Inserting an Image… Really
• Text Wrapping and Clearing
• Creating and Editing Tables
• Creating and Editing Tables 2
• Creating and Editing Tables 3
• Creating and Editing Tables 4
• Syllabus Exercise

Dreamweaver Management Tools

This management tools workshop will show you how to define a site, use library objects, create and apply templates, and perform find and replace on your web pages and site.

• Defining a Site
• Library Object
• Creating and Applying a Template
• Find and Replace

Having Fun with JavaScript and PHP

Here you will learn what ”behaviors” are in Dreamweaver and how to use and code them. Dreamweaver “behaviors” are interactive components which give a web page the power to handle interactions with users, called “events”, and to provide responses to these events, called “actions”. Events and actions are programmed into a web page using JavaScript, which is placed into the web page source code along with the usual HTML. 

Some of the behaviors shown here can be developed in Dreamweaver without actually going through the process of  writing JavaScript. Dreamweaver will automatically put the JavaScript code into your web page through your use of the menu options available.

Having fun with JavaScript

These JavaScript examples will show you how many interactive features are accomplished. You can examine the details for each by clicking on the “example” link on the left. You can also look at the actual HTML and JavaScript source code (the programming instructions the browser uses to perform the desired behavior) used for each example by clicking on the “view source” link on each Javascript example page. You can insert most of these JavaScript examples into your web page using Dreameaver, so you really do not need to know how write JavaScript if you don’t want to learn this.

Having fun with PHP

Here you can learn to use PHP within your web pages. You can examine the details for each PHP example by clicking on the “example” link on the left. You can also look at the actual HTML and PHP source code (the programming instructions the browser uses to perform the desired behavior) used for each example by clicking on the “display” link on each PHP example page.

Popularity: 20% [?]

Related Posts:

Free Dreamweaver Training Tutorials

17 Dreamweaver Tutorials and Articles

1-page Dreamweaver Tutorial

Free Dreamweaver MX Reference eBook

Dreamweaver Course Materials

Tags for this post>> Dreamweaver

Thinkfree.com’s Doc Exchange is a site that encourages their users to share their documents with one another. You can use their search feature to find documents in areas you are interested in. Here is a helpful little document I found that shows all of the Keyboard Shortcuts for Microsoft Excel. These will really help those power Excel users who need to use many of Excel’s features in their day-to-day work and tasks. If you fall into that category, I hope this helps you out.

Excel Keyboard Shortcuts

Key	Alone	Shift	Ctrl	Alt	Shift+Ctrl
F1	Help	What’s This Help		Insert Chart Sheet
F2	Edit Mode	Edit Comment		Save As
F3	Paste Name Formula	Paste Function	Define Name		Names From Labels
F4	Repeat Action	Find Again	Close Window	Quit Excel
F5	Goto	Find	Restore Window Size
F6	Next Pane	Prev Pane	Next Workbook	Switch To VBA	Prev Workbook
F7	Spell Check		Move Window
F8	Extend Selection	Add To Selection	Resize Window	Macro List
F9	Calculate All	Calculate Worksheet	Minimize Workbook
F10	Activate Menu	Context Menu	Restore Workbook
F11	New Chart	New Worksheet	New Macro Sheet	VB Editor
F12	Save As	Save	Open		Print
A			Select All		Formula Arguments
B			Bold
C			Copy
D			Fill Down	Data Menu
E				Edit Menu
F			Find	File Menu	Font Name
G			Goto
H			Replace	Help Menu
I			Italics	Insert Menu
J
K			Insert  Hyperlink
L
M
N			New Workbook
O			Open Workbook	Format Menu	Select Comments
P			Print		Font Size
Q
R			Fill Right
S			Save
T				Tools Menu
U			Underline
V			Paste
W			Close Workbook	Window Menu
X			Cut
Y			Repeat Active
Z			Undo
` (~)			Toggle Formula View		General Format
1 (!)			Cell Format		Number Format
2 (@)			Toggle Bold		Time Format
3 (#)			Toggle Italics		Date Format
4 ($)			Toggle Underline		Currency Format
5 (%)			Toggle Strikethru		Percent Format
6 (^)			a		Exponent Format
7 (&)			a		Apply Border
8 (*)			Outline		Select Region
9 (()			Hide Rows		Unhide Rows
0 ())			Hide Columns		Unhide Columns
-			Delete Selection	Control Menu	No Border
= (+)	Formula			Auto Sum	Insert dialog
[			Direct Dependents		Direct Precedents
]			All Dependents		All Precedents
; (semicolon)			Insert Date	Select Visible Cells	Insert Time
(apostrophe)				Style	Copy Cell Value Above
: (colon)			Insert Time
/			Select Array		Select Array
\			Select Differences		Select Unequal Cells
Insert	Insert Mode		Copy
Delete	Clear		Delete To End Of Line
Home	Begin Row		Start Of Worksheet
End	End Row		End Of Worksheet
Page Up	Page Up		Previous Worksheet	Left 1 screen
Page Down	Page Down		Next Worksheet	Right 1 screen
Left Arrow	Move Left	Select Left	Move Left Area
Right Arrow	Move Right	Select Right	Move Right Area
Up Arrow	Move Up	Select Up	Move Up Area
Down Arrow	Move Down	Select Down	Move Down Area	Drop down list
Space Bar	Space	Select Row	Select Column	Control Box	Select All
Tab	Move Right	Move Left	Next Window	Next Application	Previous Window
BackSpace			Goto Active Cell

Popularity: 22% [?]

Related Posts:

InDesign, Fireworks, Illustrator, and Dreamweaver References and Shortcuts

5 Free Office Quick Reference Guides

Microsoft Office Course Handouts and Templates

Photoshop References and Cheat Sheets

Microsoft Excel Tutorials

Tags for this post>> Excel

Here is a freely available Flash ebook in pdf format that goes into a good deal of depth and understanding on how to use this important graphics, animation, and multimedia web application. It teaches and describes, in easy to follow language, how to use Flash to its fullest extent, and how to make compelling web page animations and graphics. This ebook is 10.1mb in size and contains 409 pages.

Macromedia Flash 8 Ebook

The following Flash features are described and explained:

• Understanding and handling the Flash screen, toolbars, and menus
• Developing text and graphics in Flash
• Sound and video
• Using layers to help manage your animation
• Creating symbols, saved objects for repeated use
• Animating graphics, the core of using Flash
• Maing your Web sites interactive
• Publishing Flash movies to your Web site

Popularity: 26% [?]

Related Posts:

12 Free Ebooks for Flash, Dreamweaver, Fireworks, Macromedia CF MX 7

17 Freely Available Flash eBooks

Free Flash Ebook

Free Ebook for Macromedia Flash 8

38 Free Books: Dreamweaver, Fireworks, Director, Flash, Photoshop

Tags for this post>> Flash

This JavaScript Tutorial is aimed at beginners to help them understand how old and outdated JavaScript techniques can cause issues on a web page. The tutorials proceeds by analyzing the source code of a web page that was written several years ago using concepts that were ok good to use then, but in the current Web will render inaccessible or broken pages in a browser.

Three dynamic elements using JavaScript are reviewed and explained from the point of view when they were originally developed, and then a more current method of re-writing them is demonstrated making them more hardened and less error-prone in regards to DOM scripting. The tutorial starts with providing some understanding about what DHTML and the DOM are. The example web site containing the JavaScript code examples are available for download as a zip file.

From DHTML to DOM Scripting – How to replace outdated javascript techniques

Download PDF version (202KB)


Table of Contents

• Preface
• What is DHTML and what is DOM scripting?
  • What is the DOM?
• Creating the page in DHTML
  • The goal of DHTML
  • The tabbed navigation in DHTML
  • DHTML issue #1: Script dependence
  • Showing, hiding and tab highlight in DHTML
  • DHTML issue #2: Mixing presentation and functionality
  • The Product Photo in DHTML
  • DHTML issue #3: Assuming functionality without testing for it
  • The Slide Show in DHTML
  • DHTML issue #4: Keeping maintenance JavaScript based
  • DHTML issue #5: Mixing HTML and JavaScript
  • DHTML issue #6: Blaming the user
  • DHTML issue #7: Taking over the document
• Introducing DOM scripting
  • The goal of DOM scripting
  • DOM scripting asset #1: Progressive Enhancement
  • DOM scripting asset #2: Ease of maintenance
  • DOM scripting asset #3: Separation of Presentation and Behaviour
  • DOM scripting asset #4: Separation of Structure and Behaviour
  • DOM scripting asset #5: Using modern event handling
  • DOM scripting asset #6: Avoiding clashes with other scripts
• Re-creating the demo page with DOM scripting
  • The tab navigation in DOM scripting
  • The popup window in DOM scripting
  • The slide show in DOM scripting
  • Fixing for Safari
• Where to now?

Popularity: 21% [?]

Related Posts:

Dynamic HTML (DHTML) Training Course

Free Books for Web Design, Development, Programming, and Scripting

Free Book – Teach Yourself JavaScript in 24 Hours

14 DHTML Training Tutorials

More Dynamic HTML (DHTML) Tutorials

Tags for this post>> DHTML | Javascript | Web Programming

Here is a nice Microsoft Word Tutorial from Monroe City Schools that demonstrates and teaches basic Word features that are important to understand and know how to do.

In Word, How Do I …

Create a new Word document?

Save a document?

Change margins?

Change text alignment?

Copy/cut and paste text?

Use the Letter Wizard?

Delete documents from the print queue?

Create a table?

Open a document I previously saved?

Select text?

Change line spacing?

Change the font, font size, font style, font color?

Use WordArt?

Print in grayscale?

Create an Organization Chart?

Popularity: 19% [?]

Related Posts:

8 Microsoft Word Lessons with Exercises

Word 2007 Slide Presentation

Microsoft Word Mail Merge Tutorials

Word 2007 Interactive Guide

Creating Accessible Word Documents

Tags for this post>> Word

Here are two web resources that will help you create an effective, well receieved, and attractive PowerPoint Presentation. The first one listed here outlines the planning steps you need to take for creating a Powerpoint presentation, including the word layout, fonts graphics, special effects, handouts and notes, and practicing. The second one reviews important advice regarding: your audience, speaking clearly, using templates, self-evident content, contrasting colors, effects and transitions, guidelines for wording, fonts, and punctuation, and using clip art and graphics.


Creating a Great Presentation

Table of Contents

   Click here to start – Creating a Great Presentation

   1. Plan

   2. Organize

   3. Develop Content

   4. Work on the word layout

   5. Work on the fonts

   6. Work on the graphics

   7. Use graphs appropriately

   8. Special Effects Use them at your own risk

   9. Use Handouts and Notes

   10. Practice before you preach



Creating an Effective PowerPoint Presentation

Hints for a successful presentation: 

• Plan carefully
• Do your research
• Know your audience
• Time your presentation 
• Practice your presentation 
• Speak comfortably and clearly 

Effective PowerPoint Slides

• Use design templates
• Standardize position, colors and styles 
• Include only necessary information 
• Limit the information to essentials
• Content should be self-evident
• Use colors that contrast 
• Be consistent with effects, transitions and animation 
• Too many slides can lose your audience

Text guidelines

• Generally no more than 6 words a line
• Generally no more than 6 lines a slide
• Avoid long sentences
• Larger font indicates more important information 
• Font size generally ranges from 18 to 48 point
• Be sure text contrasts with background
• Fancy fonts can be hard to read
• Words in all capital letters are hard to read
• Avoid abbreviations and acronyms
• Limit punctuation marks

Clip Art and Graphics

• Should balance the slide 
• Should enhance and complement the text, not overwhelm 
• No more than two graphics per slide
• PowerPoint presentations can also saved in HTML format and inserted in a Web page.

Popularity: 20% [?]

Related Posts:

Lessons on Effective Presentations using PowerPoint

Advanced Powerpoint Tutorials

2 Powerpoint 2007 Tutorials

2 PowerPoint 2003 Tutorials

PowerPoint 2003 and PowerPoint XP Tutorials

Tags for this post>> Powerpoint

This free book, The Web Style Guide, 2nd edition, teaches you Web page and Web site design principles, along with tips and tricks, ranging from interface design to editorial style and graphics. It provides you a high level of understanding which will assist your Web development and design efforts. Whether you’re a newbie to Web design and development or a veteran, this book will give you insight into Web site design that you have not had before, bringing you a more reasoned and realistic perspective. The information given in this Web Style Guide is based on the functional concepts of design, but it also discusses Web site accessibility, Cascading Style Sheets (CSS), and flexible page design. Material covering information architecture, site maintenance, and multimedia design is also included. The second edition offers added illustrations and updated Web site examples to show current best practices.

Web Style Guide, 2nd edition


Chapter 1: Process

• Before you begin
  • Planning
  • Developing a site specification
• The site development process
  • Site definition and planning
  • Information architecture
  • Site design
  • Site construction
  • Site marketing
  • Tracking, evaluation, & maintenance
• References

Chapter 2: Interface Design

• Web page design versus conventional document design
• Make your Web pages freestanding
• Basic interface design
  • User-centered design
  • Accessibility
• Navigation
• References

Chapter 3: Site Design

• Organizing information
  • “Chunking” information
• Site structure
  • Basic information structures
  • Creating site diagrams
• Site design themes
  • Training
  • Teaching
  • Continuing education
  • Reference
  • Entertainment and magazine sites
  • News sites
  • E-commerce
• Site elements
  • Home pages
  • Menus and subsites
  • Resource lists, “other related sites” pages
  • Site guides
  • “What’s new?” pages
  • Search features
  • Contact information and user feedback
  • Bibliographies and appendixes
  • FAQ pages
  • Custom server error pages
• Internet versus intranet design
  • Design standards
• References

Chapter 4: Page Design

• Visual hierarchy
• Consistency
• Page dimensions
• Page length
• Design grids for Web pages
• Page headers and footers
• Page layout
  • Layout tables
  • Fixed versus flexible
  • Other uses for tables
• Frames
• General design considerations
• Cross-platform issues
• Accessibility
• References

Chapter 5: Typography

• Characteristics of type on the Web
• Content structure and visual logic
  • Cascading style sheets
• Legibility
  • Alignment
  • Line length
  • White space
  • Typefaces
  • Type size
  • Case
  • Emphasis
• Consistency
• Cross-platform issues
• Accessibility
• Type graphics
• References

Chapter 6: Editorial Style

• Organizing your prose
• Online style
• Titles and subtitles
• Links
• References

Chapter 7: Graphics

• Characteristics of Web graphics
  • Color displays
  • “Browser-safe” colors
  • Dithering
  • Screen resolution
  • Gamma
  • Graphics and network bandwidth
• Graphic file formats
  • GIF files
  • JPEG graphics
  • PNG graphics
  • Imaging strategies
  • Summary: File formats
• Images on the screen
  • The screen versus printed color artwork
  • Complex illustrations or photographs
  • Diagrams for the computer screen
• HTML and graphics
• Accessibility
• References

Chapter 8: Multimedia

• Applications for multimedia
• Web multimedia strategies
  • Audio only
  • Slide shows
  • Video
  • Animation
• Preparing multimedia
  • Processing
  • Delivery
• Design and multimedia
• Accessibility
• References

Popularity: 19% [?]

Related Posts:

Free Books on Web Development and Programming

31 Free eBooks on Website Design, Development and Programming

15 Freely Available Ebooks for Web Development, Hosting, Infrastructure

Free Web Development and Infrastructure Ebooks

Free Web Development and Programming Books

Tags for this post>> Web Design