Be sure to check out our Blogs and discover all the new Free Training!
Newsletter for EducationOnlineForComputers.com
Computer Software Education, Training & Tutorial Resources
*** ISSUE #35 - March, 2007 ***
EducationOnlineForComputers.com
This Newsletter is only sent to its subscribers
and is available on the web at
http://www.EducationOnlineForComputers.com/newsletter35.html
Newsletter Archives are here:
http://www.EducationOnlineForComputers.com/newsletter.html
Subscribe and unsubscribe instructions are at the end.
Please forward this newsletter to all your friends
and associates who might be interested!
In This Issue:2)... Best New Free Microsoft Office Training & Tutorial Sites
4)... Best New Free Web Development Training Sites
5)... Best New Free Windows, Linux, Hardware & Computer Training
6)... Software, Office and Computer Sites Worth Mentioning
7)... Question of the Month about Software Training
8)... Please Support Our Computer Training Mission
1) Editor's Greeting:
Hello everyone, and welcome to our new subscribers!
Here is our March 2007 issue (#35) of our Free monthly Newsletter for EducationOnlineForComputers.com, giving you the most current Free online Microsoft Office and Web Development Software Training and Tutorial Resources that we have recently discovered and researched. This newsletter is free to anyone subscribing (instructions at bottom, no username/password is needed). To access our member site, however, you do need a user name and password - registering as a member of EducationOnlineForComputers.com costs only $14 for two months, for more information please see Become a Member of EducationOnlineForComputers.com.
My desire is that these free resources will help you with your computer education and training and will help you advance your career. Our main mission is the training of those less fortunate who are seeking to become computer literate, from a user's perspective.
By means of this email newsletter, you have knowledge of and access to these sites before our web site visitors do. The best of these resources will be added to our Member Training pages and the remainder to our Free Training pages.
In this issue we are featuring a total of 48 Computer Software Application training, learning and tutorial web sites, with a total of 134 tutorial courses linked. It features many Free Microsoft Office, Flash, Photoshop, Dreamweaver, and Web Development training tutorials for your learning profit and enjoyment.
*** Current Issue ***Please take a look at and bookmark our Blogs, these will be updated daily and weekly with New Free Training and Tutorial Resources, as I discover and evaluate them:
EducationOnlineForComputers.com Blogs:- Free Microsoft Office Application Training
- Free Web Development Training
- Free Adobe & Macromedia Training
Intelligentedu.com Blogs:- Free Technical Computer Training
- Free Computer Books & Ebooks
To get your Free MS Office and Web Development Software Training updates via RSS, please copy (right click and copy shortcut or link location) and paste these urls into your RSS reader:
Free_Microsoft_Office_Training_Tutorial_Resources_rss2.xml
Free_Training_Photoshop_Flash_Dreamweaver_FrontPage_Adobe_Macromedia_rss2.xml
Free_Web_Development_Training_Tutorial_Resources_rss2.xml
Please visit our New Free Training and Tutorial Search Engine, Edcomp.com - We have deployed a new website at www.edcomp.com that is a search engine with a large database of over 150,000 free IT education and training web resources, with another 70,000 free resources reserved exclusively for paid members. If you're an educationonlineforcomputers.com member, go to http://www.edcomp.com/members/ to access the special members' page for searching 220,000 free training web resources.
For your convenience, this newsletter is also available to subscribers in HTML format at this special url:
http://www.educationonlineforcomputers.com/current_news.htmlIf you are looking for free technical or programming training, please visit our sister site:
http://www.intelligentedu.com.Also, please check out our new free computer training search site at www.edcomp.com.
I wish you the best with your computer studies and learning.
Warm Regards,
Scott Turton Newsletter and Web Site Editor
scott_turton@EducationOnlineForComputers.com
http://www.EducationOnlineForComputers.com
"Learn New Skills and Increase Your Earning Power
*** Become a Member of EducationOnlineForComputers.com ***
- With Free Online Computer Training!"
Our Members' Site contains the web's best Microsoft Office and other software training resources and tutorials. This content is individually linked and presented in a way to expedite and facilitate your computer learning experience. We have done all the web research and presentation work for you so you can concentrate solely on your computer training. For short FAQ Answers, please see the end of this newsletter.
The total price to join as a member is only $14 total for 2 months, $24 for 4 months, $32 for 6 months, or $56 for a whole year. The funds generated will assist us to help all those seeking computer education and application end-user training. Here's the link to see what's available on our member's site and to sign up.
EdComp.com:
http://www.edcomp.com/
This is our new free computer and IT education and training search engine housing over 140,000 free training internet resources! Just type in a topic you're looking for and get tons of great web resources instantly. These search results are much better than the big search engines, like google. You can also check out our predefined search results page giving you tons of free training resources: http://www.edcomp.com/predefined.htm.
--> Here is Your Reward for Subscribing to this Newsletter <--
*** Get Your Free Microsoft Office Forms and Templates ***
Click here for tons of Free Office Forms and Templates
2) The Best New Free Microsoft Office Training & Tutorial Sites:
This section of our newsletter contains the best new Free Microsoft Office training and tutorial sites that we have found and researched in the last few weeks.
Visit TrainingByEmail to receive Free Training for Word, Excel, Outlook, C#, ASP.Net, and SQL via your email every week! We will send out a new training in the topic of your choosing every week. You can then save this, print it out, or delete it all at your convenience. And you can't beat the price, FREE!
8 Microsoft Office Tools
Here are short tutorials and explanations for 8 common Microsoft Office Tools that all or most of the applications use. These help you productivity when using the Office applications and help you and your document users become more efficient.Auto Format As You Type
Describes how the"auto format as you type" feature works in Office 2003.
Layering
This Layering tutorial shows you various ways to work with many objects (pictures, graphics, Auto Shapes etc.) and to virtually merge them to display as object.
Hyperlinks
This tutorial teaches you how to create a hyperlink that links to anywhere on your current document, to a different document or to a Web site.
Equation Editor
Find out and practice what the Equation Editor toolbar is used for and then use it in Microsoft Word and PowerPoint.
Inserting Objects Into Office Applications
Explains how to use the Insert Objects option so you can insert other Office application documents into your current open one you're working on. For example, you can insert an Excel Spreadsheet into a Word document, and then you can either update the spreadsheet dynamically through the Word document, or merely view the spreadsheet statically.
Common Microsoft Office Shortcuts
Here is what you need for knowing and using the most common keyboard shortcuts for all the applications in Microsoft Office.
Spell Check
This is a tutorial that demonstrates how to use Spell Check in Microsoft Office. Using this feature will help you spell word correctly.
Auto Correct
This is a tutorial that explains how the Auto Correct spelling feature works in all Office applications, and how to use it to help you spell correctly as you type.
Beginners Word Training and Mail Merge
Here are three well written Word Training Guides hosted by California State University, Northridge. Two of these training tutorials are for those getting started with Word 2002 and Word 2000, and one is a tutorial covering Mail Merge Using Word and Excel. Basic Word features demonstrated by these training guides are: Creating a Document, Basic Editing, Correcting Errors, Restoring a Deletion, Adding and Moving Text, Correcting Spelling and Grammatical Errors, Saving a Document, Printing a Document, Text Formatting, Paragraph Formatting, Document Formatting, Page Setup, Headers and Footers, Automatic Page Numbering, and File Management.
Beginner's Guide to Word 2002
- Getting Started
- Bare Bones Basics
- Creating a Document
- Basic Editing Features
- Correcting Errors
- Saving a Document
- Saving a Document for the First Time
- Saving a Previously Saved Document
- Printing a Document
- Closing a Document Window
- Opening an Existing Document
- Ending a Word Session
- Text Formatting Features
- Paragraph Formatting Features
- Document Formatting Features
- File Management
- How to Learn More
- Appendix A: Glossary
- Appendix B: Features Table
Beginner's Guide to Word 2000
This training guide presents an introduction to selected features in the word processing program Word 2000. Please note that the document is not intended to cover all ways in which the basic features can be used or accessed.
- Getting Started
- Bare Bones Basics
- Creating a Document
- Basic Editing Features
- Making Corrections
- Saving a Document
- Printing a Document
- Closing a Document Window
- Opening an Existing Document
- Ending a Word Session
- Formatting Features
- Text Formatting
- Bolding, Italicizing or Underlining Text
- Changing Font Typeface and Size
- Paragraph Formatting
- Aligning a Paragraph
- Paragraph Indents
- Line Spacing
- Setting Tab Stops
- Document Formatting
- Page Setup
- Headers and Footers
- Automatic Page Numbering
- File Management
- How to Learn More
- Appendix A: Glossary
- Appendix B: Word 2000 Features Table
Mail Merge Using Word and Excel
Using Word's Mail Merge function gives you the ability to generate personalized documents by merging together a main document and a data source.
There are three steps to any mail merge project:Step 1: Create a data source document in Excel with the information, such as name and addresses, that will vary with each letter or label.
Mail Merge Table of Contents
Step 2: Create a main document in Word, such as a form letter, mailing labels, envelopes, etc.
Step 3: Merge the main document from step 2 with the data source from step 1.
1. Creating and Sorting a Data Source Document2. Generating Individually Addressed Form Letters 3. Generating Mailing Labels 4. Generating Individually Addressed Envelopes
- Creating a Data Source Document in Excel
- Sorting the Excel Data
- Creating a Data Source Document in Word
5. Generating a List (or Catalog) 6. How to Merge and Print Selected Records
- Creating the Main Document in Word
- Merging Envelopes
- Saving the Main Document and Merging Again Later
7. How to Learn More
Word Form Tutorial
This is a 5-part Word Form Tutorial that explains and describes how to lay out and create a form in Word. It starts with the basics of making a Word form and then goes on to show you how to use macros and Visual Basic for Applications (VBA) programming to automate the form and store the data. However, you can still create nice looking form with using the more advanced techniques.
Part 1 teaches you how to create a form that provides fields to users for entering information. Part 2 goes into using the VBE (Visual Basic Editor) and shows you some VBA to direct the form users to specific areas of the form. In Part 3 you will learn to make message boxes to provide or request information to be used downstream from the form. Part 4 shows you how to create a custom dialog box. Part 5 describes how you should code using ADO (ActiveX Data Objects) and VBA to connect an AutoForm to a database.
Please Fill Out This Form! - 5 Part Word Form TutorialPart 1: Create professional looking forms in Word
Part 2: Adding Automation to your Word forms
Part 3: Learn more about VBA macros to automate your form
2 Beginning Excel Tutorials
Excel 2003 and Excel 2000 are very comprehensive and feature-rich spreadsheet applications, and to start geting the most from them, you need to understand their fundamentals. These 2 Beginning Excel Tutorial Guides, from California State University, Northridge, demonstrate the basics of Excel so that you can start becoming proficient right away with this common spreadsheet application. These Excel tutorials will show you how to create a simple spreadsheet, move around in Excel, edit your data, enhance the look of your spreadsheet, and use some of Excels important features. Specifically they demonstrate the following Excel activities: Entering Data, Understanding Formulas, Editing Cells, Copying & Pasting Cell Content, Moving Cell Content, Deleting Cell & Range Content, Using AutoFill, Inserting & Deleting Rows and Columns, Changing Row Height and Column Widths, Naming Worksheets, Borders, Font & Fill Coloring, Creating Charts, Page Setup, and Saving and Printing These Excel tutorials can also be used by Macintosh users.
Excel 2003 Basics & Beyond - Beginner's Guide
(628kb, 28 pages, pdf format)
Getting Started with Microsoft Excel 2003
Table of Contents:
- Overview
- Getting Started with Microsoft Excel 2003
- Entering Data
- Understanding Formula Basics
- Editing Cell Content
- Copying & Pasting Cell Content
- Moving Cell Content
- Deleting Cell & Range Content
- Using AutoFill
- Inserting & Deleting Rows and Columns
- Changing Row Height or Column Widths
- Naming your Worksheet
- Formatting with Borders
- Font & Fill Coloring
- Creating Basic Charts
- Page Setup
- Saving & Printing
- Closing & Exiting Excel
Excel 2000 Beginner's Guide
1 Overview 2 Getting Started 3 Entering Data and Using Formulas 4 Editing Cell Contents5 Saving and Printing a Worksheet 6 How to Learn More 7 Closing a Worksheet and Exiting Excel 8 Appendix: Excel 2000 Menus
- In-Cell Editing
- Formula Bar Editing
- Copying Cell Contents
- Moving Cell Contents
- Deleting the Contents of a Cell or a Range
- Copying a Formula to Other Cells Using AutoFill
- Inserting a Column or Row
- Deleting a Column or Row
4 Intermediate and Advanced Excel Tutorials
California State University, Northridge hosts the following excellent four Intermediate and Advanced Excel Training Tutorials.
The first Excel Tutorial provides techniques on Controlling the Worksheet View, Working with Ranges, Changing Text Alignment & Angle in a Cell, Converting Text to Columns, and Text Functions.
The second tutorial covers how to work with multiple worksheets and workbooks, including Inserting Additional Worksheets, Renaming Sheets, Deleting a Worksheet, Hiding Worksheets, Moving & Coping Worksheets, Creating & Working with Graphic Objects, Linking across Worksheets & Workbooks, and Protecting Your Data.
The third Excel tutorial teaches you how to do perform Data Query and Management, specifically, Freezing the View Pane, Sorting Data, Filtering & Querying Data, Creating & Removing Subtotals, Data Validation, and Auditing Worksheets.
The last tutorial offers instructions on how to create and manage Macros in Excel, including how to record, run, assign, and delete macros.
Useful Tips & Techniques for Excel 2003
(917kb, 20 pages, pdf format)
Table of Contents:
- Getting Started Right
- Controlling the Worksheet View
- Working with Ranges
- Changing Text Alignment & Angle in a Cell
- Converting Text to Columns
- Text Functions
Working with Multiple Worksheets and Workbooks in Excel 2003
(579kb, 21 pages, pdf format)
This Excel training guide gives you additional techniques to efficiently use more than one workbook and worksheet at the same time. By learning and using these workbook and worksheet features you will save time and keystrokes.
Table of Contents:
- Introduction
- Inserting Additional Worksheets
- Renaming Sheets
- Colorizing the Sheet Tabs
- Deleting a Worksheet
- Hiding Worksheets
- Moving & Coping Worksheets
- Creating & Working with Graphic Objects
- Inserting Additional Worksheets
- Linking across worksheets & workbooks
- Protecting Your Data
Data Query & Management in Excel 2003
(705kb, 23 pages, pdf format)
Become more efficient with using Excel by learning some of Excel's more advanced features that will assist you in working with and easily accessing large worksheets, and also many worksheets in a workbook.
Table of Contents:
- Freezing the View Pane
- Sorting Data
- Filtering & Querying Data
- Creating & Removing Subtotals
- Data Validation
- Auditing Worksheets
Using Macros in Excel 2003
(402kb, 17 pages, pdf format)
This Excel Macro Tutorial will teach you how to easily do repetitve tasks much quicker than normal. A macro is a set of recorded instructions that perform ordered tasks to carry out one or more activities or features in Excel. If you find yourself doing the same tasks over and over again, then you should learn how to create a macro to do it for you. Then all you need to do is to run the macro by pressing a few keys.
Table of Contents:
- Introduction
- Understanding what Macros are and what they can do
- Recording Macros
- Running Macros
- Assigning Macros
- Deleting Macros
- Viewing your Macro Option
- Class Exercise
160 Excel VBA Tutorials
This is a comprehensive linked list of 160 Excel Tutorials and How Tos teaching how to use Macros and code using VBA in Excel. VBA is an abbreviation for Visual Basic for Applications, its the Microsoft Office scripting language used to customize the applications. These Excel learning materials include instructions for performing the demonstrated tasks and are hosted by three excellent Excel tutorial sites: MrExcel, Chip Pearson, and John Walkenbach, all together containing over 500 Excel Articles and Tutorials.
Excel Ebooks
Here are 23 Excel Ebooks, linked at itebookhome.com, covering many topics and areas of Microsoft Excel, versions 2000, 2002 (XP), 2003, and 2007. These ebooks will teach you about many of Excel's key components, features, toolbars, and its user interface. They will give you lots of spreadsheet examples, formulas, techniques, and tips, while also providing step-by-step instructions, useful graphics, and suggestions performing time-saving tasks. You can learn the basics on how to create spreadsheets, add and format data in cells and ranges, preview and print reports, create charts, and utilize formulas and functions. You can also learn many of Excel's advanced features as described below. (To download Excel ebooks at rapidshare.de, first click on the Free button, then wait a few seconds, and then click on the download link or button.)
The areas and technical topics covered by these Excel ebooks are as follows:
- The redesigned user interface with tabbed toolbar in Excel 2007
- Excel VBA and .NET
- Macros for automating tasks, transposing cells, adding formula details, globally changing values, and more.
- Lists and XML data, using Visual Studio Tools for Office, and using Web Services and Infopath
- Building reporting solutions with Excel - Pivot Table reports and spreadsheet reports,
- Using Excel as a calculating tool for finance - financial statements, budgets, capital budgeting, pro forma statements, cost of capital, etc.
- Using Excel add-ins (written in C and C++) with financial applications
- How to use Excel for computations, circuit modeling, graphing, and data analysis in regards to electronics design
- How to use Excel for statistical tests and modeling, such as bootstrap, decision trees, t-test, and permutations
- Using XML with Excel
- Excel hacks for reducing workbook and worksheet frustration, and adjusting features such as pivot tables, charts, formulas and functions
- What-If data analysis tools using Goal Seek, Data Tables, Scenarios, and Solver
- Integrating Excel and Access
- VSTO - the new Excel Macro programming language
Basics and Intermediate PowerPoint Tutorials
Here are two PowerPoint Tutorials for PowerPoint Basics on Creating a Slide Presentation, one each for the 2002 (XP) and 2000 versions. Also included here is an Intermediate PowerPoint Tutorial giving you tips and features you can use to make PowerPoint work better and smoother for you. These are provided by California State University, Northridge.
PowerPoint 2002 Basics
This tutorial teaches the steps for making a nice looking slide presentation using PowerPoint XP. Features covered in this tutorial and the one below for Powerpoint 2000 include the following: Startup Choices, The PowerPoint Window, Creating Slides, Layout Choices, Positioning and Resizing a Text Box or Image, Bulleted Items, Adding Clip Art, Charts and Graphs, Tables, Organization Charts, Normal View, Slide Sorter View, Slide Show View, Changing the Look and Feel of Your Presentation, Building Transitions and Effects on Your Slides, Effects, and Using Master Pages to Make Global Changes.
- Some PowerPoint Definitions
- Opening PowerPoint
- Creating Slides - New Layouts
- The Many Views of Your PowerPoint Presentation
- Changing the Look and Feel of Your PowerPoint Presentation
- Building Transitions and Effects on Your Slides
- Using Master Pages to Make Global Changes
- How to Learn More: PowerPoint's Help Options
PowerPoint 2000 Basics
This tutorial teaches the steps for making a nice looking slide presentation using PowerPoint 2000.
- Some PowerPoint Definitions
- Opening PowerPoint
- Creating Slides - New Layouts
- The Many Views of Your PowerPoint Presentation
- Changing the Look and Feel of Your PowerPoint Presentation
- Building Transitions and Effects on Your Slides
- Making Global Changes to Your PowerPoint Presentation Using the Master Pages Feature
- How to Learn More
PowerPoint 2003 - Intermediate Training Guide
(12 pages, 270kb, pdf format)
Table of Contents:
- Course Description
- Recoloring Clip Art
- Cropping Clip Art and Images
- Ungrouping Clip Art
- Using the Picture Toolbar
- Creating a Custom Background
- Change Color Scheme
- Modifying a Presentation Design Template
- Create a Customized Presentation Design Template
- To Save a Template for Future Use
- Applying Animation Effects Additional effects
- Adding Interactivity
- Insert a Movie and/or Sound Clip
- Insert WordArt
- Putting Your PowerPoint 2003 Presentation on the Web
24 Microsoft Access Tutorials from Towson University
The Microsoft Access database model consists of data, fields, records, and tables of records, with each table being a flat file database. However this is not all -- in addition, in Access, the user can create and run queries, and produce reports from the the fields, records, and tables. This functionality, along with the ability to work with many tables having common elements, makes Access a database management system (DBMS) and a basic relational database.
Here are 24 Microsoft Access Tutorials offered by Towson University. These Access tutorials demonstrate and convey how to perform many basic and advanced Access features and functions, including the following: Creating new databases, Data Entry, Forms, Tables, Relationships, Exporting and Importing Data, Sorting and Filtering Tables, Queries, Reports, Labels, and Lookup Lists. These Access tutorials will help you learn these topics and add to your Access knowledge and skillset. All documents are in pdf format, except the first 3 tutorials, which are videos with sound.
- Access 2003 Video Tutorial: Relationships
- Access 2003 Video Tutorial: Tables
- Access 2003 Video Tutorial: Forms
- Access 2003: Basic Workshop
- Access 2003: Understanding Databases
- Access 2003: Creating a New Database
- Access 2003: Data Entry and Forms
- Access 2003: Exporting and Linking Data
- Access 2003: Importing Data
- Access 2003: Sorting and Filtering Tables
- Access 2003: Queries
- Access 2003: Reports
- Access 2003: Inserting Graphics
- Access 2003: Advanced Tables Design View
- Access 2003: Advanced Forms: Sub-Forms
- Access 2003: Advanced Queries: Design View
- Access 2003: Advanced Reports: Calculations
- Access 97: Converting to Access 2003
- Access: Getting Data from PeopleSoft
- Access 2003: Understanding Relationships
- Access 2003: Creating Labels
- Access 2003: Creating Switchboards
- Access 2003: Understanding Tables
- Access 2003: Creating a Lookup List
Access Training Guides
Here are three excellent Access Training Guides provided by California State University, Northridge. These Access training tutorials cover the fundamentals for both Access 2000 and 2003, and intermediate and advanced topics for Access 2003. Areas of functionality and features taught by these training guides are as follows: Getting Started, Starting Access 2003, Creating a New Database, Naming Conventions, The Leszynski Naming Convention, Object Naming Conventions, Designing a Table in Design View, Starting a New Table, Data Types, Defining Data Fields, Entering Data in Datasheet View, Creating a Query, Designing an Input Form, Producing a Report, Relationships, Using Operators in Queries, Designing Advanced Queries, and Creating Action Queries.
Access 2003 - Basics & Beyond
(21 pages, 484kb, pdf format)
Contents:
- Introduction
- Getting Started
- Naming Conventions
- Designing a Table in Design View
- Entering Data in Datasheet View
- Creating a Query
- Designing an Input Form
- Producing a Report
- How To Learn More
- Closing a Database and Exiting Access
Access 2003 Intermediate Training Guide
(19 pages, 262kb, pdf format)
Contents:
- Relationships
- Using Related Tables
- Creating a Relationship
- Setting Referential Integrity
- Using Operators in Queries
- Using Comparison Operators
- Using an AND Condition
- Using an OR Condition
- Using the BETWEEN AND Operator
- Using the Expression Builder
- Using a Wildcard Character
- Designing Advanced Queries
- Setting Top Values in a Query
- Creating a Calculated Field
- Formatting a Calculated Field
- Creating a Function Query
- Creating a Parameter Query
- Creating a Concatenation in a Query
- Filtering a Query
- Creating Action Queries
- Creating a Make Table Query
- Creating an Update Query
- Creating an Append Query
- Creating a Delete Query
Beginner's Guide to Access 2000
This training guide is intended to acquaint you with the fundamentals of Microsoft Access 2000. At the completion of this series of documents, you will have a basic understanding of database functions and capabilities, and the tools necessary to begin your own exploration and experimentation with Access 2000.
- Introduction
- Getting Started
- Naming Conventions
- Designing a Table in Design View
- Entering Data in Datasheet View
- Creating a Query
- Designing an Input Form
- Producing a Report
- How To Learn More
- Closing a Database and Exiting Access
Access Ebooks
Here are 21 Access Ebooks which will help you acquire or increase your Microsoft Access knowledge and skills. These ebooks will teach you how to develop and manage simple and complex Access databases, and gain a thorough understanding of programming with Access VBA to create database applications. You will learn all of the basic database concepts as well as intermediate to advanced database design and programming. (To download ebooks at rapidshare.de, first click on the Free button, then wait the stated amount of seconds, then click on the download link or button.)
These are some of the areas and topics addressed by these Access ebooks:
- Learn the following:
- How Access objects and interfaces fit together
- The best way to organize your fields into tables
- How you can modify tables, forms, and reports
- How you can design forms and reports for better usability
- How primary keys and relationships work
- Learn Access core concepts, so you can build robust and useful database applications
- Methods for creating and customizing a new database, retrieving, processing, presenting, and exchanging data
- How to secure your Access database and environment. Learn about database protection methods and security from a task-by-task perspective
- Access VBA - how to create your own code, and work with Object-Oriented Programming
- Learn skills to create Access VBA programming applications, and also find out how to use AKO, DDL, event programming, ASP and XML
- How to create multi-user database applications with the latest Web services technologies and XML
- Access operators and functions, debugging and error handling, and menu commands
- Write advanced queries, import and export data, program with Web Matrix and .NET
- Use SQL update scripts to make tables, add rows to tables, and retrieve records
- Learn to use DAO and ADO to manipulate data, manage errors, make classes and utilize APIs
3 Visio Tutorials
These are 3 Visio Tutorials, hosted by Towson University in pdf format. Visio gives you the ability to create comprehensive diagrams and graphic drawings, such as flow charts and organization charts. These Visio tutorials will teach and demonstrate the fundamentals of Visio and how to use the following important features and tools: making a Diagram; using Templates, Stencils, and the New button; using, creating and moving Shapes; interactive Shapes; the Shapes window; the Organization toolbar; Pictures and Text; and the Insert menu.
10 Publisher 2003 Tutorials
Here are 10 Publisher 2003 Tutorials that will get you going with this desktop publishing application in Microsoft Office. Learn how to perform and create the following using Publisher: all the basic features; insert and edit graphics; create newsletters, brochures, and booklets; working with text boxes, and editing pages.
Publisher 2003: Basics
This tutorial describes and teaches all of the fundamental features of Publisher 2003.
Publisher 2003: Graphics
This tutorial takes you through the steps of how to insert and edit graphics in your Publisher document. The picture toolbar is also explained to make this easier.
Publisher 2003: Newsletters
Describes and teaches how to make a professional looking newsletter using Publisher.
Publisher 2003: E-mail Newsletters
Learn how to make great looking newsletters for email with Publisher.
Publisher 2003: Brochures
Shows and explains how to easily create great looking brochures using Publisher 2003's brochure template.
Publisher 2003: Booklets
This Publisher tutorial demonstrates and teaches how to make great looking booklets.
Publisher 2003: Connect Text Boxes
This will teach you how connect text boxes from one page to another within a Publisher document, such as a newsletter.
Publisher 2003: Working with Pages
Shows and explains how to edit and manage a 2-page spread withing a Publisher publication, and also add, move, remove, and copy pages.
Publisher 2003: Blank Tutorial
This tutorial teaches you how to use Publisher 2003 when beginning with a blank document instead of one created out of the ready-made templates.
Publisher 2003: Printing a Newsletter onto 11x17
Shows how to print a 4-page newsletter on a single 11x17 piece of paper using Publisher.
3) The Best New Free Training Sites for Flash, Photoshop, Dreamweaver, FrontPage, and other Adobe and Macromedia Applications
8 Macromedia Flash TutorialsMacromedia Flash (now Adobe) provides you the ability, as a web designer, to insert and integrate video, graphics, animations, and audio, into your web pages and applications. Flash makes is possible to give your users a more interactive and positive experience, thus delivering greater results in areas of page retention, registrations, marketing, etc. Here are 8 Macromedia Flash Tutorials hosted by newtutorials.com that show you how to perform or create the following using Flash: masking effects, preloading, rotating objects, mouse followers, a drop-down menu, an animation, and a color flash light.
Cool Masking Effect
- This tutorial teaches you how to create a cool effect, with masking, using Flash MX.Preloader Tutorial
- This shows you and explains how to create a Flash Preloader.Rotating Objects
- In this tutorial, you will see how to rotate objects in Flash.Mouse Follower: Part 1
- Here you can find out how to force objects to follow the mouse pointer around the screen.Mouse Follower: Part 2
- Part 2 of Mouse Follower finishes the tutorial on getting objects to follow the mouse pointer.Drop Down Menu
- Using this tutorial, you will find out how to make a Drop-down menu using Flash MX..Moving Lines Tutorial
- This tutorial demonstrates and explains how to use Tweening to create an animation using Flash MX.Color Flash Light Tutorial
- Discover how to create the Color Flash Light Effect using Flash MX.
10-page Flash Guide
This is a 10-page Guide on "Exploring Macromedia Flash MX" (796kb, pdf format), from Kansas State University. It explains what Flash does, how to start using it, and introduces many important features of Flash.
Flash is a software application that is used to create and display attractive multimedia and web animations and presentations. Programmers use Flash to develop nice looking and compact navigational interfaces, technical graphics, animations, and other compelling user experiences. Illustrations and animations in Flash are made with Flash's drawing tools, or Flash developers can import images from their favorite vector and/or bitmap graphics software. Flash has lots of great features, and for those in academics, it is priced quite well at around $100, making it a very accessible multimedia application.
This Flash guide provides instruction and how-to steps for the following functionality:
- Flash Work Environment
- The Stage and the Timeline Window
- The Library Window
- Symbols and Instances
- Using the Toolbox
- Using Scenes
- Using the Movie Explorer
- Creating a Basic Animation - Shape Tween and Motion Guides
- Creating the Shape Tween
- Prep the Shape Tween before attaching the Motion Guide
- Create the Motion Guide
- Creating a very basic Multiple Choice Quiz
A Simple Photoshop Tutorial
Here is a simple, but lavishly illustrated Photoshop Tutorial from thinkfree.com.
This tutorial demonstrates and teaches the following Photoshop tools and features:
- The Grid
- Layers
- Lines
- Dashed Lines
- Ellipses and Circles
- Text
- History
Photoshop Ebooks
Here are 15 Photoshop Ebooks that will teach you how to use many of the features and tools of Adobe Photoshop. Photoshop is the most popular and most feature rich digital imaging software available today. These ebooks will help you, either as a photographer or an artist, to create and edit better quality images, whether you scan, shoot, or capture them. Using Photoshop, you can also develop attractive and well-designed web page graphics. (To download Photoshop ebooks at rapidshare.de, first click on the Free button, then wait the stated amount of seconds, then click on the download link or button.)
The areas and topics covered by these Excel ebooks are as follows:
- How to use Photoshop’s productivity features to facilitate your work
- Learn these Photoshop features: Preferences, presets, Actions, scripting, batch processing, keyboard shortcuts, Workspaces, file browsing, and the Bridge
- How to use these new CS2 features: Image Warping, Vanishing Point, Smart Objects
- Find out how to sharpen your digital images by changinging them from continuous gradations of tone and color to points on a grid
- Learn how to do creative finishing, using frames and border effects, color and artistic effects, presentation, sharpening, and printing
- Understand how Photoshop channels are used
- Use Photoshop for your web design and web graphics, create buttons, logos, web headers, and other web graphics
- Use Adobe Camera Raw and Bridge with Photoshop
- Get answers to over 200 of the most-commonly asked Photoshop questions
- Manage your photos by date, event, place, or subject, and make them creative projects
- Get help with using channels and masks, painting and drawing, adding masks and special effects, and creating Web photo galleries
Dreamweaver is a wonderful and robust application for creating and developing web sites. It provides excellent tools which will help you build an attractive and compelling web site that includes user interactivity and connectivity to a database. Many of these tools and features are complex, however, so you may need to turn to these Dreamweaver Ebooks linked at itebookhome.com. The ebooks available are listed in the above blog post with a short description. (To download Dreamweaver ebooks at rapidshare.de, first click on the Free button, then wait the stated amount of seconds, then click on the download link or button.)
Dreamweaver Training Guides
California State University at Northridge provides these Dreamweaver Training Guides containing excellent training tutorials for learning how to use many features of Dreamweaver. Topics taught by these training guides include the following: Defining a New Website, The Dreamweaver Work Area, Creating a Basic Web Page, Page Properties, Text, Links, Inserting Common and "Head" Objects, Preparation for Publishing, Using HTML Styles to Format Text, Using Tables in Web Page Design, and Using Templates for Consistent Design.
Dreamweaver MX Basics
The instructions in this document assume the reader has already created web pages using some other web page creation software, such as FrontPage. Some knowledge of HTML coding is also recommended.
- Before You Begin
- Getting Started with Dreamweaver
- Creating a Basic Web Page
- Preparation for Publishing
- How to Learn More
Intermediate-Level Dreamweaver Topics:
Using HTML Styles to Format TextAn HTML style is similar to a Word (or other word processing) style in that it can be defined to specify one or more text-formatting features that can be applied to a paragraph or selected text. As with a Word style, you can apply an HTML style over and over. Unlike a Word style, an HTML style only affects specified text at the time you apply the style. This means that if you later change an HTML style, any text to which the style has been applied will not be affected by the change. This characteristic is more like Word's Format Painter, which applies text formatting only at the time of application.
- The HTML Styles Panel
- Creating an HTML Style Based on Existing Text
- Creating an HTML Style from Scratch
- Creating an HTML Style from an Existing Style
- Applying an HTML Style
- Editing an HTML Style
- Deleting an HTML Style
- How to Learn More
Using Tables in Web Page Design
One way to give vertical and horizontal structure to a page is to format a web page using tables.
- Standard View vs. Layout View
- Creating a Table in Standard View
- Designing a Page in Layout View
- How to Learn More
Using Templates for Consistent DesignDreamweaver provides two types of assets that can help you create Web pages with a consistent content and design — templates and libraries. This document describes the basics of creating and using an HTML template to an generate an identical layout for a set of pages. See also Using Libraries to Reuse or Update Page Elements.
- Creating a Basic HTML Template in a New Document Window
- Creating a Basic HTML Template from an Existing Document
- Designing the Page and Defining Editable Regions in a Template
- Using a Template
- Modifying a Template
- Detaching a Document from a Template
- Using the Assets Panel to Work with Templates
- How to Learn More
4) The Best New Free Web Development Training SitesWeb Tips and Techniques
This is a site named, Dan's Web Tips, which provides some useful information that Dan has learned and discovered over the years. These web development tips and techniques will hopefully assist you in creating a more compelling and functional website for your visitors. Dan says that many of these are not referred to on other learning sites or in books on web design and development. These web tips are targeted to those who are seeking some assistance with making their web sites better while staying away from potential problems.
- Introduction
some words from Dan about HTML philosophy
- "How do I force..."
you may have ask this type of questions, but the answer probably isn't what you want to hear.
- Directories and Default Index Files
some tips on structuring your web site
- Titles, LINK Tags, META Tags, and Search Engine Robots
how to tell browsers and search engines what you site is about, using various META and LINK tags.
- Physical vs. Logical Markup
information about these two basic types of HTML tags
- Validators
how to find out if your web pages contain valid HTML code
- Brand X Browsers
you need to account for other browsers besides Internet Explorer
- My Site Doesn't Work In Netscape?
more tips on making sure your pages are coded using valid HTML
- Graceful Degradation
how to keep your web site accessible while at the same time using some advanced techniques
- Nesting
learn the structure of the elements of an HTML web page
- Cascading Stylesheets (CSS)
using CSSs are now the recommended method to code web pages, as doing so separates structure from presentation
- Colors
learn about colors and how to use them
- Languages
Implementing a multilingual site
- Characters and Fonts
find out about using special characters
- Images
understand how to insert images and graphics to your web pages
- Sounds
add sound, such as music, to your web site
- Tables
here are suggestions for using tables in your HTML.
- Frames
prompts you to think if you really need these in your site
- Auto-Refreshing Pages
How to make a page load another one after a period of time
- Opening New Browser Windows
some web sites want to do this with their external links
- HTML Comments
learn how to correctly place comments into your HTML code
- Cleaning Up After WYSIWYG Editors
sometimes after using a GUI web editor you will need to fix a few things
- Dealing with Changes
what to consider and think about when redesigning your site
- URL
find out what relative and absolute addresses are, and the best way to use each
- Domain Names
a few words about domain names and what they are
let you web users provide feedback via email
- Server vs. Client
learn what components of the Web are managed by server and which by client
- Miscellaneous
here is some more information that may be useful
HTML and Web Design Training Guides
California State University Northridge is offering the following HTML and Web Design Training Guides on their self-study training web site. These will help you get started with creating web pages, learning how to code HTML, and also help you think about your web site design strategy, guiding you on style, purpose, and organization.
Creating an HTML File
HTML: Beginner's Guide
This document provides basic instructions for coding in Hypertext Markup Language (HTML) to create a Web page (an HTML file) on your desktop computer.
Introduction
Saving & Viewing Your HTML File
Updating (Revising) a Web Page
Style Suggestions
How to Learn More About HTML
Appendix: Sample HTML-Coded Documents
Design and Accessibility
Designing an Effective Web Page
A Web page is a place people visit to obtain information. Web pages can be informational (such as those maintained by CSUN organizations such as University departments) or personal (as in the case of individuals who wish to communicate something about their own backgrounds and interests). For a business Web page, there may be an interest in marketing products or services.
When you design a Web page, think about such things as purpose, organization, and style, as well as copyright laws and plagiarism. Making your pages readable to all who view them is also important (see next section).
How to Make Your Web Pages ADA Compliant
Some Accessibility Suggestions
Following are some general suggestions for helping to make your pages readable to all who view them.
Hearing Access
Visual Access
Mobility Access
Cognitive Access
The Text-Only Alternative
Other Sources
Questions?
182 XHTML Tutorials and FAQs
Whether you are starting out or already an experienced web development programmer, these 182 XHTML Tutorials and FAQs will help you create an attractive and functional web site. Example XHTML code is also provided, along with tutorial exercises and some great XHTML tips. These will increase your knowledge and understanding of XHTML and demonstrate some excellent ways you can use this web development technology.
5) The Best New Free Windows, Linux, Hardware and General Computer Training SitesWindows XP FAQ's
This Windows XP Frequently Asked Questions section provides some execellent tips and tweaks that are available to help your Windows XP opeating system be more efficient and less prone to problems.
Windows XP Gudies
2) Adding an E-Mail Account to Outlook Express
3) Defragmenting Your Hard Drive
4) Restoring your system with System Restore
5) Accessing Newsgroups with Outlook Express
Windows XP File Management
The following programs are totally Free, no popups, adware, spyware, or shareware.
6) Software, Office and Computer Sites and Downloads Worth Mentioning
Delta SP 1.62
Delta SP bundles several music software programs into one, making it more flexible and easier to use once you've learned the basics. It provides you a sequencer, which plays MIDI messages to it's internal synthesizer or to external MIDI devices, and also Audio clips to Audio channels in the synth.
Use Delta SP to compose music, jingles, podcasts, etc. and when finished save your project as a high definition WAV, MP3 or OGG file. If you have used music software before, you'll recognize the standard tools and panels in Delta SP.
Download Delta SP (3210 KB)
Ultimate Zip 2.7.0
Ultimate Zip creates, opens, and uncompresses the following types of archive files: ACE, ARC, ARJ, BH, BZ2, CAB, ENC, GZ, HA, JAR, LHA, LZH, PAK, PK3, PK_, RAR, TAR, TBZ, TBZ2,TGZ, UU, UUE, XXE, Z, ZIP, ZOO. To open these archive types in Windows Explorer, UltimateZip must be associated to them.
Download Ultimate Zip (3061 KB)
MightyWriter 1.2.1
MightyWriter creates Audio CDs of Wave files using Disk-At-Once recording mode. It auto-detects all CD-R/RW recorder settings and supports the Burn-Proof technology. It also works great with drives that do not support this technology, as it uses an optimized buffering method to ensure that a buffer underrun does not occur.
Download MightyWriter (523 KB)
Atlantis Nova 1.0.0.68
Atlantis Nova is a full-featured and user-friendly Word Processor that takes a small amount of disk space and a very small memory footprint. Its user interface is coherent and integrated, including 3 toolbars, a Document Bar with name-tabs for quick and easy access to any open document, a Easy Hand "grabbing" mode to navigate effortlessly through any document, a Hide All mode for maximum working space, a Magnifying Glass tool for instant high/low magnification, a graphic-type Format Brush to copy/Paste font format, and a Clippy Bank to store notes.
Download Atlantis Nova (764 KB)
Spread32 1.18
Spread32 is fully compatible with Microsoft Excel, containing all of the basic features. You can run macros, draw objects, generate charts, calculate functions and formulas, and more. And it reads and writes xls, csv, text, and pxl formats.
Download Spread32 (490 KB)
7) Question of the Month about Software Training:Each month Scott Turton will answer a current or important question that we have received about computer and software training.
March 2007 Question of the Month:What's the news with Adobe planning to offer on online version of Photoshop?
On February 27, 2006, Adpbe's Chief Executive stated that Adobe Systems plans to release an online version of its popular Photoshop image and graphics-editing application within six months. This new Photoshop web-based software will be part of a larger initiative by Adobe to start providing ad-supported online services. These online products are intended to complement its existing software and improve the company's penetration into the consumer market.
- Answer:
This new online Photoshop will be offered free to all users, and as such will contain ads. It will compete with PXN8, Fauxto, Picture2Life, Picnik, Preloadr, Snipshot, and other online photograph and image web applications. The features that will be hosted by this new Photoshop version will mainly contain the lower end of functionality and features, so it will not be meant to take away from the current desktop version. However, the features that will be offered will probably be more powerful and robust that what is currently offered online elsewhere. So it appears that part of Adobe's strategy is to gain more market share by attracting more users to the Photoshop family of products.
For more detailed information about the new web-based version of Photoshop, you can take a look at this google search.
I hope this helps you.Scott Turton
Site Editor
EducationOnlineForComputers.com
8) Please Support Our Training Missionhttp://www.EducationOnlineForComputers.com
How You Can Support Our Computer and Software Training Mission
Please help support EducationOnlineForComputers.com's Computer and Sofware Education and Training Mission by visiting our sponsors below and requesting more information. By doing so, you will be helping people who want to learn to use computers in an Information Technology career.
EdComp.com:
http://www.edcomp.com/
This is our new free computer and IT education and training search engine housing over 150,000 free training internet resources! Just type in a topic you're looking for and get tons of great web resources instantly. These search results are much better than the big search engines, like google. You can also check out our predefined search results page giving you tons of free training resources: http://www.edcomp.com/predefined.htm.
ITT Technical Institute: Choose from their many programs:
University of Phoenix Online: Advance your career
DeVry: Online degrees for working adults
EducationOnlineForComputers.com
http://www.EducationOnlineForComputers.comFree Computer Software Training Now!
A free and member-based software educational and training portal web site. We have compiled, categorized, described, and linked many sites that will be of keen interest to computer software application end-users seeking free training and knowledge. Many subject areas are covered, including Microsoft Office, Flash, Photoshop, Dreamwever, FrontPage, Web Development, Windows, Linux, and Computer Hardware. You are able to study and learn all about computer software via Free training, courses, tutorials, documentation, articles, tips, notes, and help. Check us out today.
Copyright Notice: Please note that all of the items hyperlinked are copyrighted by their authors and/or publishers. You are eXPected to look for, read, and adhere to such notices. Downloaded and online material is copyrighted whether or not a copyright notice is present.
***EducationOnlineForComputers.com's Member Site ***Our Members' Site contains the web's best computer software training resources and tutorials. This content is individually linked and presented in a way to eXPedite and facilitate your software and computer learning eXPerience. We have done all the web research and presentation work for you so you can concentrate solely on your computer training.
EducationOnlineForComputers.com Member Site FAQ Answers:
- All of the web sites and pages in our members site are not in the free section of our web site. The member site training is more detailed and the best available. The online training resources in our members' site are linked and laid out in a much more detailed fashion than those in the free section. This will save you time in finding all the best free training on the web.
- You can choose to pay using either Paypal or 2Checkout. If paying pay check and you live in the U.S., please select 2Checkout.
- You have a choice to select the non-recurring or recurring method of payment. If you select non-recurring, when your membership period eXPires, you will not be automatically charged another fee on your credit card or check.
- The total price to join our member's site is only $14 total for 2 months, $24 for 4 months, $32 for 6 months, or $56 for a whole year. The funds generated will assist us to help all those seeking software application education training. Here's the link to see what's available on our member's site and to sign up: http://tinyurl.com/7ien You can email Scott Turton with questions at scott_turton@educationonlineforcomputers.com
I will give you 5 Great Free Bonuses when you sign up now.
These are as follows:
- 28 Modules of Soft Skills Training, covering topics such as Coaching, Delegating, Finance Essentials, Hiring, Leading and Motivating Team, Making a Presentation, Managing Your Time, and Setting Goals.
- 19 Online Business and Reference Books, including titles such as Scientific Advertising, The Art of Electronic Publishing, and Small Business Manual
- 12 Instructive e-Books, including On Line Stealth Marketing, 7 Secrets to Unlimited Traffic, and Increase Auction Profits.
- Instant and Easy Online Access to the 24 Best Free Computer Help & Support Sites.
- 45 of the Best, Completely Free Programs and Utilities.
To Subscribe to this Free monthly Newsletter of Computer Education, Training, & Tutorial Resources simply send a blank email to this address:
newsletter-sub@educationonlineforcomputers.com
(You will need to confirm using a link in a confirming email.)Or go to this web page and use the subscribe form:
http://www.educationonlineforcomputers.com/newsletr_sub_unsub.html
To Unsubscribe from this Free monthly Newsletter of Computer Education, Training, & Tutorial Resources simply send a blank email to this address:
newsletter-unsub@educationonlineforcomputers.com
(no need to confirm)Or simply go to this web page and use the unsubscribe form:
http://www.educationonlineforcomputers.com/newsletr_sub_unsub.html
Thank You!
scott_turton@educationonlineforcomputers.com
http://www.EducationOnlineForComputers.com