Free Microsoft Office Training and Tutorial Resources




    



August 27, 2007

Free Training for PowerPoint 2007

Here are Four Free Training Resources for Learning How to Use PowerPoint 2007. The first one is an online course that will help you learn how to use the new Office 2007 Ribbon, do typical tasks to create a presentation, use the interactive galleries, and use the new XML file format. The second one is a tutorial article that helps you understand how to use the new user interface and find familiar features in PowerPoint 2007. The third one is a Powerpoint 2007 tutorial that shows you how to create and use the new presentation templates. The fourth a spreadsheet that maps all PowerPoint 2003 menu and toobar items to PowerPoint 2007′s ribbon interface.


1) Free PowerPoint 2007 Online Course: Up to Speed with PowerPoint 2007

After completing this course you will be able to:

  • Approach the new user interface with confidence and an understanding of how it works.
  • Do the things you typically do to create and prepare a presentation.
  • Use the new file format in PowerPoint in the way that’s best for you.
This course includes:
  • Three self-paced lessons and two practice sessions for hands-on experience. Practices require PowerPoint 2007.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.
PowerPoint 2007 Course Contents:

Get your Bearings: What’s Changed and Why
Get to Work in PowerPoint
A New File Format
Quick Reference Card


2) Reference: Locations of PowerPoint 2003 Commands in PowerPoint 2007

Learn about the elements of the new Microsoft Office Fluent user interface in Microsoft Office PowerPoint 2007. This also shows you PowerPoint 2003 commands that perform the same tasks in PowerPoint 2007.

3) PowerPoint 2007: Get Started with New Templates

This tutorial presents some of the improvements in PowerPoint 2007, and specifically takes you through creating and using New Templates, SmartArt, New Layouts, and Charts.

Pages 2 and 3:
  1. PowerPoint 2007: Get Started with New Templates
  2. SmartArt, New Layouts and Charts, and More

4) PowerPoint 2007 Ribbon Mapping Workbook

This spreadsheet maps all of the menu and toolbar features and options in PowerPoint 2003 to the equivalent in PowerPoint 2007 for each of the following:
  • File menu
  • Edit menu
  • View menu
  • Insert menu
  • Format menu
  • Tools menu
  • Slide Show menu
  • Window menu
  • Help menu
  • Standard toolbar
  • Formatting toolbar
  • Picture toolbar
  • Reviewing toolbar
  • Web toolbar
  • Organization Chart toolbar
  • Slide Master View toolbar
  • Diagram toolbar
  • Drawing toolbar
  • Tables and Borders toolbar
  • 3-D Settings toolbar
  • Print Preview toolbar
  • WordArt toolbar
  • Drawing Canvas toolbar
  • Shadow Settings toolbar
  • Control Toolbox toolbar
  • Visual Basic toolbar
  • Outlining toolbar
  • Slide Sorter
  • Handout Master View
  • Grayscale View
  • Ink Drawing and Writing
  • Ink Annotations
  • Rehearsal
  • System
  • Online Meeting


Tags for this post>>
August 16, 2007

Free Training for Excel 2007

Microsoft has made many modifications to the user interface for all Office 2007 applications, and that means relearning how to use most Excel features in Excel 2007. All menus and toolbars have been replaced with a new “Ribbon” interface and Tabs. These Ribbon and Tabs are located horizontally across the screen and graphically depict groups of features and functionality.

Here are Four Free Training Resources for Learning How to Use Excel 2007. The first one is an online course that will help you learn how to use the Ribbon, find familiar features, and understand and use the new XML file format. The second one is a reference for the locations of Excel 2003 commands in Excel 2007. The third learning resource is a 3 page Excel 2007 Charting tutorial. The fourth document is a spreadsheet that maps all Excel 2003 menu and toobar items to Excel 2007′s ribbon interface.


1) Free Excel 2007 Online Course: Up to Speed with Excel 2007

Learn how to use the new user interface of Microsoft Excel 2007, and find out how to do the everyday tasks that you normally do in Excel.

Length: 30–40 minutes

Course Goals:

  • Get a handle on the new look of Excel.
  • Find everyday commands on the Ribbon: Cut, Copy, Paste, Insert Sheet Rows, Insert Sheet Columns, and Sum.
  • Save workbooks in the new Excel file formats.
This course includes:
  • Three self-paced lessons and two practice sessions for hands-on experience. Practices require Excel 2007.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.
Excel 2007 Course Contents:

Overview

What’s changed, and why
Get to work in Excel
A new file format

Feedback

Quick Reference Card


2) Reference: Locations of Excel 2003 commands in Excel 2007

This tutorial describes the items of the new Microsoft Office Fluent user interface that are in Microsoft Excel 2007. It also shows you commands which you may already know how to use in Microsoft Excel 2003, and explains how to do the same tasks or features in Excel 2007.

3) Excel 2007 Tips for Creating Functional and Attractive Charts

This article explains the Top Ten Tips and Tricks for Excel 2007 Charts. Excel charts have been given a makeover in Excel 2007 and the Chart Wizard of earlier versions is now gone. Find out how to create functional and attractive charts using Excel 2007.

Excel Charting Tips – Pages 2 and 3:

4) Excel 2007 Ribbon Mapping from Excel 2003

This spreadsheet (.xls) maps all of the menu and toolbar features and options in Excel 2003 to the equivalent in Excel 2007 for each of the following:
  • Standard toolbar
  • Formatting toolbar
  • PivotTable toolbar
  • Chart Toolbar toolbar
  • Reviewing
  • Forms
  • Stop Recording
  • External Data
  • Formula Auditing
  • Circular Reference
  • Visual Basic
  • Web
  • Control Toolbox
  • Exit Design Mode
  • Watch Window
  • Borders
  • Protection
  • Text to Speech
  • List
  • Compare Side by Side
  • Drawing toolbar
  • WordArt
  • Pictures
  • Organization Chart
  • Diagram
  • Ink Drawing and Writing
  • Ink Annotations
  • Shadow Settings
  • 3D Settings
  • File Menu
  • Edit Menu
  • View Menu
  • Insert Menu
  • Format Menu
  • Tools Menu
  • Data Menu
  • Chart Menu
  • Windows Menu
  • Help Menu


Tags for this post>>
August 9, 2007

Free Training for Using Word 2007

Microsoft has made huge changes to the user interface for all of the applications in Office 2007, including Word 2007. It has replaced all menus and toolbars with a new “Ribbon” interface, along with Tabs. The Ribbon and Tabs are positioned across the screen and graphically depict groups of features and functionality.

Here are Four Free Training Resources for Learning How to Use Word 2007. The first one is an online course that will help you learn how to use the Ribbon, find familiar features, and understand and use the new XML file format. The second one is a reference for the locations of Word 2003 commands in Word 2007. The third learning resource is a 3 page Word 2007 tutorial article that reviews Word’s new features and user interface. The fourth document is a spreadsheet that maps all of Word 2003 menu and toobar items to the Word 2007 ribbon or interface.


1) Free Word 2007 Online Course: Up to Speed with Word 2007

Course length: 30–40 minutes

After completing this course you will be able to:

  • Work with the Ribbon — the new feature that makes Word easier than ever before.
  • Find everyday, common commands you need to do your job.
  • Use the new file format for Word in the way that’s best for you.
This course includes:
  • Three self-paced lessons and two practice sessions for hands-on experience. Practices require Word 2007.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course. 
Course Contents:
Overview

Get to Know the Ribbon
Find Everyday Commands
A New File Format
Feedback

Quick Reference Card


2) Reference: Locations of Word 2003 Commands in Word 2007

This tutorial article explains and demonstrates elements of the new Microsoft Office Fluent user interface in Microsoft Word 2007. It also provides lists of commands that you may already be familiar with in Word 2003, showing you how to perform the same feature or function in Word 2007.

3) New Features in Word 2007

Word New Features – Pages 2 and 3:
  1. New Features in Word 2007
  2. Radically New Look for Word 2007

4) Word 2007 Ribbon Mapping from Word 2003

This is an spreadsheet (.xls) that will help you become familiar with the menu and toolbar options in Word 2007. It maps all of the menu and toolbar features and options in Word 2003 to the equivalent in Word 2007 for each of the following:
  • File menu
  • Edit menu
  • View menu
  • Insert menu
  • Format menu
  • Tools menu
  • Table menu
  • Window menu
  • Help menu
  • Standard toolbar
  • Formatting toolbar
  • AutoText toolbar
  • Control Toolbox toolbar
  • Database toolbar
  • Drawing toolbar
  • E-mail toolbar
  • Extended Formatting toolbar
  • Forms toolbar
  • Frames toolbar
  • Function Key Display toolbar
  • Ink Annotations
  • Ink Drawing and Writing toolbar
  • Mail Merge toolbar
  • Outlining toolbar
  • Picture toolbar
  • Reviewing toolbar
  • Tables and Borders toolbar
  • Visual Basic toolbar
  • Web toolbar
  • Web Tools toolbar
  • Word Count toolbar
  • WordArt toolbar
  • 3-D Settings toolbar
  • Shadow Settings toolbar
  • Drawing Canvas toolbar
  • Organization Chart toolbar
  • Diagram toolbar
  • Header and Footer toolbar
  • Full Screen toolbar
  • Stop Recording toolbar
  • Microsoft toolbar
  • Print Preview toolbar
  • AutoSummarize toolbar
  • Exit Design Mode toolbar
  • Text Box toolbar
  • Refresh toolbar
  • Reading Layout toolbar
  • Compare Side by Side toolbar
  • System toolbar
  • Online Meeting toolbar


Tags for this post>>
August 7, 2007

25 Flash Tutorials from Spoono

Here are 25 nicely written and easy to follow Flash Tutorials from Spoono, the web designers’ playground. These free Flash training pages cover all Flash skill levels: beginning, intermediate, and advanced.
 

8 Beginning Flash Tutorials:

Alpha/Onion Skin
This Flash tutorial instructs you how to get a cool alpha fading, onion skin type of effect used by many websites. Can be used for buttons, movie clips, anything.

Animated Button
Discover how to create animated buttons with Flash and make OnMouse animated buttons.

Custom Cursor
This Flash tutorial teaches you how to make a custom cursor for your Flash movies.

Invisible Button
Find out how to use the  invisible button trick to improve your Flash applications by having only one button instead of multiple buttons in your library.

Object Follow Mouse
This shows you how to have a Flash object follow the mouse and increase and decrease in speed depending on how far away the mouse is from the object.

Simple Text Bevel
This is an easy tutorial for Flash beginners teaching you how to get a simple text bevel effect.

Sound Loops
Discover how to fix the issue of a sound loop repeating itself many times over and over again in Flash.

Typewriter Effect
Learn how to create a typewriter effect in Flash without using Actionscripts.


11 Intermediate Flash Tutorials:

Collapsing Text Button
This Flash tutorial will show you how to create a collapsing menu effect.

Collision Detection
This Flash tutorial demonstrates how to use hitTarget to detect collisions and use this technique in your movies.

Double Click
How to use Flash’s getTimer() to force users double click on an object.

Draggable Masks
Find out how to use Flash to dynamically create a mask and drag it across your movie.

Flash and JavaScript
Discover how to have Flash work and communicate with JavaScript.

Gravity in Flash
Learn how to make a ball bounce using Flash.

Movie Functions
This Flash tutorial shows you how to use several  action scripts to change a movie clip, such as move, stretch, fade, rotate and more.

Opposeable Mouse Effect
Use Flash ActionScript to create boxes that oppose the mouse pointer.

Revolving Text Button
Find out how to create a revolving text button effect using Flash.

Scrolling
This Flash tutorial demonstrates how to import a text file into Flash and then display it while scrolling.

Springy Text Button
Create a springy text button effect in Flash.


6 Adanced Flash Tutorials:

Advanced Preloader
Learn how to create a Flash preloader that specifies the percent, bytes loaded, bytes remaining, and more.

Digital Timer
Learn how to create a digital timer using Flash’s getTimer() function.

Flash and XML
Learn how to use Flash and XML to create a simple phonebook application.

Keyboard Movement – Part 1
Learn the details of how to control a Flash movie clip using the keyboard  - part 1 of a 3-part tutorial.

Keyboard Movement – Part 2
Learn the details of how to control a Flash movie clip using the keyboard  - part 2 of a 3-part tutorial.

Keyboard Movement – Part 3
Learn the details of how to control a Flash movie clip using the keyboard  - part 3 of a 3-part tutorial.

Tags for this post>>

August 6, 2007

Photoshop Tutorials from Heathrowe.com

Here are very well produced Photoshop Tutorials from Heathrowe.com, providing Photoshop users an excellent set of over 75 Photoshop tutorials for all skill levels. These tutorials offer detailed screen-shots and step-by-step instructions, giving you a good understanding of the secrets beneath the tools. These Photoshop tutorials are categorized by their primary Tool Technique:  


Photoshop Tutorial Topics:



Tags for this post>>

PowerPoint 2000 Tutorial from Comm. College of RI

Here is a PowerPoint 2000 Tutorial from the Community College of Rhode Island, describing step-by-step how to perform the following PowerPoint functionality: Basic Presentation Skills, Using the Outline Pane, Editing Presentation Text, Printing, Sending, and Publishing, Graphic Images and Tables, and the Slide Show View. These tutorial lessons can also be used to learn most of the PowerPoint features in PowerPoint XP and PowerPoint 2003.


Contents of PowerPoint Tutorial Lessons:

Lesson 1 – Exploring PowerPoint

  • Starting PowerPoint 
  • Creating a Blank Presentation 
  • Selecting an AutoLayout 
  • Using PowerPoint Windows 
  • Using Menu Commands 
  • Displaying and Hiding Toolbars 
  • Displaying Hidden Toolbar Buttons 
  • Moving and Resizing Toolbars 
  • Changing Menu and Toolbar Options 
  • Exiting PowerPoint 
  • Exercise 
  • Exploring PowerPoint 

Lesson 2 – Using Basic Presentation Skills

  • Entering Text into a Presentation 
  • Saving a New Presentation 
  • Closing a Presentation 
  • Opening an Existing Presentation 
  • Adding a New Slide 
  • Renaming an Existing Presentation 
  • Creating a New Presentation 
  • Selecting a Design Template 
  • Using Content Templates 
  • Navigating Slides 
  • Switching Views 
  • Using Normal View 
  • Changing the Magnification 
  • Changing the Slide Layout 
  • Changing the Design Template 
  • Using the AutoContent Wizard 
  • Exercise 
  • Using Basic Presentation Skills 

Lesson 3 – Using the Outline Pane

  • Working with the Outline Pane 
  • Creating a Bulleted List 
  • Collapsing and Expanding Slides 
  • Demoting and Promoting Text Lines 
  • Moving Text Lines 
  • Adding Slides in the Outline Pane 
  • Deleting Slides from the Outline Pane 
  • Rearranging Slides in the Outline Pane 
  • Creating a Summary Slide 
  • Exercise 
  • Using the Outline Pane 

Lesson 4 – Enhancing Presentation Text

  • Changing the Font 
  • Changing the Font Size 
  • Changing Font Style and Effect 
  • Changing Text Alignment 
  • Adding and Removing Bullets 
  • Creating a Numbered List 
  • Modifying Bullets and Numbers 
  • Modifying Paragraph Spacing 
  • Exercise 
  • Enhancing Presentation Text 

Lesson 5 – Printing, Sending, and Publishing

  • Printing Presentations 
  • Selecting Page Setup Options 
  • Printing Slides 
  • Printing Outlines 
  • Printing Speaker Notes 
  • Printing Handouts 
  • Sending a Presentation via E-mail 
  • Publishing a Presentation to the Web 
  • Exercise 
  • Printing, Sending, and Publishing 

Lesson 6 – Using Graphic Images and Tables

  • Working with Graphics 
  • Using the Clip Gallery 
  • Inserting Clip Art Images 
  • Using Clip Art Keywords 
  • Inserting a Picture 
  • Cropping a Picture 
  • Moving a Graphic 
  • Resizing a Graphic 
  • Formatting a Graphic 
  • Recoloring Clip Art Images 
  • Creating a Table 
  • Exercise 
  • Using Graphic Images and Tables 

Lesson 7 – Using Slide Show View

  • Running a Slide Show 
  • Navigating a Slide Show 
  • Setting Slide Transitions 
  • Animating Text and Objects 
  • Adding a Note to a Slide 
  • Adding Speaker Notes 
  • Using the Pen Tool to Annotate 
  • Changing the Pen Tool Color 
  • Adding Action Items 
  • Exercise 
  • Using Slide Show View


Tags for this post>>

Outlook 2000 Tutorial from Comm. College of RI

Here is a step-by-step Outlook 2000 Tutorial  from the Community College of Rhode Island, describing how to perform these activities in Outlook: Outlook Basics, Using Outlook Messaging, Managing Messages, Components and Office, Outlook Messaging Features, Scheduling with the Calendar, Managing Contacts, Working with Tasks, The  Journal, Notes, and Organizing Outlook Items. These tutorial lessons can also be used to learn many of these Outlook features in Outlook XP and Outlook 2003.


Contents of Outlook Tutorial Lessons:

Lesson 1 – Working with Outlook Basics

  • Starting Outlook 
  • Using the Outlook Interface 
  • Displaying or Hiding a Toolbar 
  • Using the Outlook Bar 
  • Using the Outlook Today Page 
  • Using the Folder List 
  • Exiting Outlook 

Lesson 2 – Working with The Office Assistant

  • Using the Office Assistant 
  • Finding an Answer 
  • Hiding/Displaying the Office Assistant 
  • Changing Office Assistant Options 

Lesson 3 – Using Outlook Messaging

  • Using Outlook’s E-mail Features 
  • Sending a Message 
  • Using the Address Book - Message Window 
  • Changing Mail Folder Views 
  • Opening a Message in the Inbox Folder 
  • Sending and Receiving Messages 
  • Viewing Sent Messages 
  • Replying to a Message 
  • Forwarding a Message 
  • Printing from the Information Viewer 
  • Printing from the Message Window 

Lesson 4 – Managing Messages

  • Saving a Draft Version of a Message 
  • Flagging a Message for Follow Up 
  • Navigating through Open Messages 
  • Changing the Read Status of a Message 
  • Sorting Mail Messages 
  • Deleting a Message 
  • Moving a Message to a Different Folder 
  • Emptying the Deleted Items Folder 
  • Archiving a Folder 

Lesson 5 – Working with Components and Office

  • Creating an AutoSignature 
  • Selecting a Default AutoSignature 
  • Inserting an AutoSignature 
  • Inserting a File into a Message 
  • Saving a File Attachment 
  • Opening a File Attachment 
  • Inserting a Hyperlink into a Message 
  • Creating and using Office Documents 
  • Using the Office Clipboard 

Lesson 6 – Using Outlook Messaging Features

  • Setting Message Tracking Options 
  • Viewing the Message Delivery Status 
  • Recalling a Message 
  • Creating a Message with Voting Buttons 
  • Responding to a Voting Message 
  • Tracking Votes 
  • Creating a Template 
  • Creating a New Message from a Template 
  • Deleting a Template 
  • Using Remote Mail 

Lesson 7 – Scheduling with the Calendar

  • Opening the Calendar
  • Navigating the Calendar
  • Scheduling a New Appointment
  • Using AutoDate
  • Scheduling an Event
  • Scheduling a Meeting
  • Responding to a Meeting
  • Checking Meeting Responses
  • Adding a Task to the TaskPad
  • Editing Calendar Items
  • Setting a Calendar Item as Recurring
  • Changing the Calendar View
  • Moving Calendar Items
  • Printing Calendar Information
  • Saving a Calendar as a Web Page
  • Deleting Calendar Items

Lesson 8 – Managing Contacts

  • Opening the Contacts Folder 
  • Adding a Contact 
  • Adding Same Company Contacts 
  • Changing the Contacts View 
  • Editing a Contact 
  • Flagging a Contact for Follow-up 
  • Dialing Contacts 
  • Sending a New Message to a Contact 
  • Organizing Contacts Meetings 
  • Exploring a Contact’s Web Page 
  • Assigning a Task to a Contact 
  • Printing Contacts Information 
  • Deleting a Contact 

Lesson 9 – Working with Tasks

  • Opening the Tasks Folder 
  • Adding a Task 
  • Creating a Recurring Task 
  • Editing a Task 
  • Marking a Task Complete 
  • Sorting and Reordering Tasks 
  • Assigning a Task to Another Outlook User 
  • Accepting/Declining Tasks 
  • Indicating the Progress of a Task 
  • Sending a Status Report 
  • Changing the Tasks View 
  • Printing Tasks Information 
  • Deleting a Task 

Lesson 10 – Using Journal

  • Opening the Journal Folder 
  • Adding a Journal Entry 
  • Viewing Journal Entries 
  • Changing the Journal View 
  • Opening a Journal Entry 
  • Printing a Journal Entry 
  • Deleting a Journal Entry 

Lesson 11 – Using Notes

  • Opening the Notes Folder 
  • Creating a Note 
  • Assigning a Color to a Note 
  • Changing the Notes View 
  • Opening a Note 
  • Printing a Note 
  • Deleting a Note 

Lesson 12 – Organizing Outlook Items

  • Assigning an Outlook Item to a Category 
  • Modifying the Master Category List 
  • Creating a New Folder 
  • Deleting a Folder 
  • Using a Simple Find 
  • Using an Advanced Find 
  • Using the Ways to Organize Pane 
  • Using AutoCreate 
  • Inserting an Outlook Item into a Message


Tags for this post>>

Advanced Access 2000 Tutorial

Here is a excellent Advanced Access 2000 Tutorial, from the Community College of Rhode Island. It teaches you step-by-step how to perform and work with the following advanced Access functionality: Working with Tables, Field Properties, Operators in Queries, Advanced Queries, Action Queries, Linking and importing Data to an Access Table, Compacting and Backing up a Database, Working with Controls, Design View, Advanced Form Design, Advanced Report Design, and Editing Tools. These tutorial lessons can also be used to learn Access of this Access functionality in Access XP and Access 2003.


Contents of Advanced Access Tutorial Lessons:

Lesson 1 – Modifying Tables

  • Inserting a Column in a Table 
  • Changing a Column Name 
  • Deleting a Column 
  • Inserting a Lookup Column 
  • Inserting a Hyperlink Column 
  • Creating a Many-to-Many Relationship 

Lesson 2 – Setting Field Properties

  • Using Field Properties 
  • Limiting Field Size 
  • Setting Number Formats 
  • Setting Date/Time Formats 
  • Setting Yes/No Formats 
  • Setting Default Values 
  • Setting Validation Rules 
  • Creating an Input Mask 

Lesson 3 – Using Operators in Queries

  • Using Comparison Operators 
  • Using an And Condition 
  • Using an Or Condition 
  • Using the Between And Operator 
  • Using a Wildcard Character 

Lesson 4 – Designing Advanced Queries

  • Setting Top Values in a Query 
  • Creating a Calculated Field 
  • Creating a Function Query 
  • Creating a Parameter Query 
  • Creating a Concatenation in a Query 
  • Using Multiple Tables in a Query 
  • Filtering a Query 

Lesson 5 – Creating Action Queries

  • Creating a Make-table Query 
  • Creating an Update Query 
  • Creating an Append Query 
  • Creating a Delete Query 

Lesson 6 – Using Advanced Query Wizards

  • Using the Crosstab Query Wizard 
  • Using the Find Duplicates Query Wizard 
  • Using the Find Unmatched Query Wizard 

Lesson 7 – Using Advanced Database Features

  • Printing a Relationship Document 
  • Linking Data to an Access Table 
  • Importing Data 
  • Setting a Database Password 
  • Compacting a Database 
  • Backing Up a Database 

Lesson 8 – Manipulating Controls

  • Using Controls 
  • Selecting Non-adjacent Controls 
  • Deleting Controls 
  • Sizing a Control by Dragging 
  • Selecting Adjacent Controls 
  • Moving Selected Controls 
  • Sizing Controls Automatically 

Lesson 9 – Using Design View

  • Hiding the Ruler 
  • Disabling the Snap to Grid Feature 
  • Displaying the Field List 
  • Adding a Field 
  • Moving Part of a Paired Control 
  • Aligning Controls 
  • Spacing Controls 
  • Using the Toolbox 
  • Adding a Label 
  • Adding an Image 
  • Adding a Rectangle 
  • Adding a Line 
  • Editing an Unbound Control 

Lesson 10 – Using Advanced Form Design

  • Using Forms in Design View 
  • Creating a Combo Box 
  • Creating a List Box 
  • Creating an Option Group 
  • Setting the Tab Order Automatically 
  • Setting the Tab Order Manually 
  • Adding a Form Header and Footer 
  • Creating a Blank Form 

Lesson 11 – Using Advanced Report Design

  • Using Reports in Design View 
  • Creating a Calculated Control 
  • Grouping Data in a Report 
  • Creating a Header for Each Group 
  • Creating a Running Summary 
  • Inserting a Date/Time Control 
  • Inserting a Page Break 
  • Changing the Report Margins 
  • Using the Label Wizard 
  • Creating a Blank Report 

Lesson 12 – Using Editing Tools

  • Selecting a Font Name 
  • Selecting a Font Size 
  • Selecting a Font Style 
  • Using the Format Painter 
  • Selecting Objects with the Toolbar 
  • Using AutoFormat 
  • Running the Spelling Checker 
  • Setting AutoCorrect Options 
  • Adding AutoCorrect Entries 
  • Deleting AutoCorrect Entries


Tags for this post>>

Access 2000 Tutorial from Comm. College of RI

Here is a well written Access 2000 Tutorial from the Community College of Rhode Island. It takes you through the steps of  how to perform and work with the following Access functionality: Creating and Editing Tables and Records, Filtering Data, Printing, Relationships, Simple Queries, Modifying Query Results, Analyzing Tables, Basic Forms, Basic Reports, and  Using Online Help. These tutorial lessons can also be used to learn most of this Access functionality in Access XP and Access 2003.


Contents of Access Tutorial Lessons:

Lesson 1 – Getting Started

  • Starting Access
  • Opening an Existing Database
  • Using Menu Commands
  • Displaying and Hiding Toolbars
  • Changing Menu and Toolbar Options
  • Using Database Objects
  • Using the Database Window
  • Selecting Object Types
  • Opening a Database Object
  • Exiting Access

Lesson 2 – Working with the Office Assistant

  • Using the Office Assistant 
  • Finding an Answer 
  • Hiding/Displaying the Office Assistant 
  • Changing Office Assistant Options 

Lesson 3 – Creating Tables

  • Creating a New Database 
  • Designing Tables 
  • Creating a Table in Design View 
  • Using Design View 
  • Adding Field Names 
  • Assigning Data Types 
  • Adding a Field Description 
  • Setting a Primary Key 
  • Saving a New Table 
  • Using the Table Wizard 

Lesson 4 – Working with Tables

  • Using Datasheet View 
  • Navigating Fields in Tables 
  • Adding Records 
  • Moving through Records 
  • Selecting Records 
  • Editing Records 
  • Saving Records 
  • Deleting Records 

Lesson 5 – Editing Tables

  • Changing the Row Height 
  • Changing the Column Width 
  • Changing a Font Attribute 
  • Changing a Cell Effect 
  • Selecting a Column 
  • Moving a Column 
  • Hiding a Column 
  • Unhiding a Column 
  • Freezing a Column 

Lesson 6 – Finding and Filtering Data

  • Sorting Records 
  • Finding Specific Records 
  • Finding Records using Wildcards 
  • Using Replace 
  • Using Filter By Selection 
  • Applying/Removing a Filter 
  • Using Filter Excluding Selection 
  • Using the Filter For Feature 
  • Using Filter By Form 

Lesson 7 – Printing Data

  • Printing Table Data 
  • Changing the Page Setup 
  • Printing Selected Records 

Lesson 8 – Creating Relationships

  • Using Related Tables 
  • Creating a Relationship 
  • Setting Referential Integrity 
  • Adding a Table - Relationships Window 

Lesson 9 – Using Simple Queries

  • Using Queries and RecordSets 
  • Using the Simple Query Wizard 
  • Creating a Query in Design View 
  • Opening a Query 
  • Adding a Table to a Query 
  • Joining Tables in a Query 
  • Running a Query 

Lesson 10 – Modifying Query Results

  • Sorting a Query 
  • Adding Criteria to a Query 
  • Hiding a Field in a Query 
  • Adding a Record using a Query 
  • Printing a Query 

Lesson 11 – Analyzing Tables

  • Analyzing a Table 
  • Using Relationships in Splits 
  • Using the Table Analyzer Wizard 

Lesson 12 – Creating Basic Forms

  • Using Forms 
  • Using the Form Wizard 
  • Viewing Records in a Form 
  • Printing Records in a Form 
  • Basing a Form on a Query 
  • Using AutoForm 
  • Adding a Record using a Form 

Lesson 13 – Creating Basic Reports

  • Using Reports 
  • Using the Report Wizard 
  • Using Print Preview 
  • Printing Pages of a Report 
  • Basing a Report on a Query 
  • Using AutoReport 

Lesson 14 – Using Online Help

  • Working with Online Help 
  • Viewing ScreenTips 
  • Using Help Contents 
  • Showing and Hiding the Help Tabs 
  • Using the Help Answer Wizard 
  • Using the Help Index


Tags for this post>>

Web Development Tutorials

Here are several Web Development Tutorials from Outfront.net. By using these you will learn how to use CSS, JavaScript, and HTML to give you web site a better look and feel for your users, and to improve its functionality.


Introduction To Cascading Style Sheets

CSS Basics: 3 different ways to apply style sheets:
   1. Inline Styles
   2. Embedded Style Sheets
   3. Linked Style Sheets

Cascading Style Sheets – Part 2
Constructing a Style Sheet

Cascading Style Sheets – Part 3
Using CSS for Text Formatting
Inheritance
Linked or Embedded?
Selectors for Text Style
Browser Support

Creating Funky Forms With CSS

Part 2: Adding a Style to the Submit Button

Part 3: Adding Styles to Text Areas

An Introduction To JavaScript – Part 1
An Introduction to JavaScript – Part 2

Creating JavaScript Rollover Buttons – Part 1
Creating JavaScript Rollover Buttons – Part 2: Creating the JavaScript

Creating JavaScript Rollover Buttons – Part 3: Putting the Code in Your Pages

More Web Design and Development Tutorials:
JavaScript Snippets

Fun With Background Images

Fun With Bulleted Lists

Are You Compliant?

Creating Custom Error Pages

Designing Fast Loading Sites

htaccess Magic

Getting More From Mailto

Installing And Using Perl Scripts

Preparing Photos For Your Web Site

The Popup Dilemma

Creating And Using robots.txt File


Tags for this post>>
August 3, 2007

FrontPage 2000 Tutorial from Comm. College of RI

Here is a step-by-step how FrontPage 2000 Tutorial  from the Community College of Rhode Island, describing how to do the following tasks using FrontPage: Creating and Working with Webs, Working with Page View, Working with Links, Formatting and Developing Web Pages, Graphics and Animations,  Working with Tables, and Finalizing and Publishing a Website. These tutorial lessons can also be used to learn many of these FrontPage features in FrontPage XP and FrontPage 2003.


Contents of FrontPage Tutorial:

Lesson 1 – Working with FrontPage

  • Working with FrontPage Features
  • Starting FrontPage
Lesson 2 – Creating Webs
  • Adding Content to a Home Page
  • Adding Pages to a Web
  • Saving a New Web Page
  • Inserting a File into a Web Page
  • Importing a File into a Web
  • Deleting a Web Page
Lesson 3 – Working with Webs
  • Opening an Existing Web
  • Opening a Web Page
  • Switching between Open Web Pages
  • Working with FrontPage Views
  • Closing a Web Page
  • Closing a Web
Lesson 4 – Working with Page View
  • Using Page View
  • Adding, Editing, and Deleting Text
  • Saving an Existing Web Page
  • Moving and Copying FrontPage Elements
  • Viewing the HTML Source Code
  • Previewing a Web Page
Lesson 5 – Working with Links
  • Linking to Other Web Pages
  • Creating a Link to an Internet Resource
  • Creating a Mailto Link
  • Linking to a Location in a Web Page
  • Following a Hyperlink
  • Editing a Hyperlink
  • Repairing a Hyperlink Automatically
Lesson 6 – Formatting and Enhancing Web Pages
  • Inserting a Horizontal Line
  • Creating a List
  • Modifying the Properties of a List
  • Adding a Background Color to a Web Page
  • Sharing Background Properties
Lesson 7 – Using Graphics and Animations
  • Working with Graphics and Animations
  • Inserting a Picture from a File
  • Inserting a Picture from the Web
  • Creating a Transparent Background
Lesson 8 – Working with Tables
  • Inserting a Table into a Web Page
  • Adding and Deleting Rows or Columns
  • Merging Cells in a Table
  • Splitting Cells
  • Aligning Text Vertically
  • Adjusting the Properties of a Table
  • Changing the Properties of a Cell
Lesson 9 – Finalizing and Publishing Webs
  • Finalizing and Publishing a Web
  • Repairing Hyperlinks
  • Previewing a Web in a Browser
  • Publishing a Web


Tags for this post>>

Excel 2000 Tutorial from Comm. College of RI

Here is a well written Excel 2000 Tutorial  from the Community College of Rhode Island, explaining for you step-by-step how to perform the following Excel functionality: Managing Workbooks, Working with Ranges, Creating Formulas, Copying and Moving Data, Printing, Formatting Numbers, Working with Columns and Rows, Using Large Worksheets, and Managing Multiple Worksheets. These tutorial lessons can also be used to learn most of the Excel features in Excel XP and Excel 2003.


Contents of Excel Tutorial Lessons:

Lesson 1 – Exploring Excel

  • Starting Excel 
  • Working with Excel Windows 
  • Working with Worksheets 
  • Exiting Excel 
Lesson 2 – Using Basic Workbook Skills
  • Selecting a Cell using the Keyboard 
  • Scrolling using the Mouse 
  • Entering Text into Cells 
  • Entering Numbers into Cells 
  • Saving a New Workbook 
  • Closing a Workbook 
  • Creating a New Workbook 
  • Opening an Existing Workbook 
  • Using Data Entry Shortcuts
  • Editing Cell Entries 
  • Renaming an Existing Workbook 
Lesson 3 – Working with Ranges
  • Working with Ranges 
  • Selecting Ranges with the Keyboard 
  • Selecting Ranges with the Mouse 
  • Selecting Non-adjacent Ranges 
  • Entering Values into a Range 
  • Using the AutoFill Feature
Lesson 4 – Creating Simple Formulas 
  • Using Formulas 
  • Entering Formulas
  • Using the AutoSum Button
  • Using Basic Functions
  • Using the AutoCorrect Feature
  • Using the Formula Palette
  • Using the Paste Function Button
  • Using the AutoCalculate Feature
  • Using the Range Finder Feature
Lesson 5 – Copying and Moving Data
  • Copying/Cutting and Pasting Data
  • Pasting from the Clipboard Toolbar
  • Creating an Absolute Reference
  • Filling Cells
  • Using Drag-and-Drop Editing
  • Using Undo and Redo
Lesson 6 – Printing
  • Previewing a Worksheet
  • Printing the Current Worksheet
  • Printing a Selected Range
  • Printing Multiple Copies
  • Printing a Page Range
Lesson 7 – Formatting Numbers 
  • Using Number Formats
  • Using the Currency Style
  • Using the Percent Style
  • Using the Comma Style
  • Changing Decimal Places 
Lesson 8 – Working with Columns and Rows 
  • Selecting Columns and Rows
  • Changing the Width of Columns
  • Changing the Height of Rows
  • Adjusting Columns Automatically
  • Hiding Columns and Rows
  • Unhiding Columns and Rows
  • Inserting a Column
  • Inserting a Row
  • Deleting a Column
  • Deleting a Row
Lesson 9 – Using Large Worksheets 
  • Switching to Full Screen View
  • Splitting the Window
  • Removing Split Windows
  • Freezing the Panes
  • Unfreezing the Panes
Lesson 10 – Working with Multiple Worksheets 
  • Using Multiple Worksheets
  • Navigating between Worksheets
  • Selecting Worksheets
  • Renaming Worksheets
  • Selecting Multiple Worksheets
  • Inserting Worksheets
  • Deleting Worksheets
  • Printing Selected Worksheets


Tags for this post>>

Word 2000 Tutorial from Comm. College of RI

This is a well written Word 2000 Tutorial from the Community College of Rhode Island. It instructs you in numbered steps how to perform and work with the following Word features: Text Editing, Check Spelling and Grammar, Using Document Views, Printing, Character and Paragraph Formatting, Mail Merge, and Tracking Changes. These tutorial lessons can also be used to learn most of the Word features in Word XP and Word 2003.


Contents of Word Tutorial Lessons:

Lesson 1 – Exploring Word

  • Starting Word 
  • Working with Word Windows 
  • Using Menu Commands 
  • Displaying and Hiding Toolbars 
  • Displaying Hidden Toolbar Buttons 
  • Moving and Resizing Toolbars 
  • Changing Menu and Toolbar Options 
  • Exiting Word 
Lesson 2 – Using Basic Document Skills 
  • Entering Text into a Document 
  • Saving a New Document 
  • Closing a Document 
  • Creating a New Document 
  • Opening an Existing Document 
  • Scrolling using the Mouse 
  • Moving using the Keyboard 
  • Selecting Text 
  • Using Insert Mode 
  • Using Overtype Mode 
  • Renaming an Existing Document 
Lesson 3 – Using Basic Text Editing 
  • Removing Characters 
  • Deleting Selected Text 
  • Replacing Selected Text 
  • Cutting/Copying and Pasting Text 
  • Pasting Items from the Clipboard Toolbar 
  • Using Drag-and-Drop Editing 
  • Using Undo and Redo 
Lesson 4 – Checking Spelling and Grammar 
  • Checking Spelling/Grammar as You Type 
  • Adding to the Custom Dictionary 
  • Disabling Spelling and Grammar Options 
  • Running the Spelling Checker 
  • Selecting Grammar Options 
  • Running the Grammar Checker 
Lesson 5 – Working with Document Views 
  • Switching Document Views 
  • Changing Document Magnification 
  • Displaying/Hiding the Horizontal Ruler 
  • Viewing/Hiding Nonprinting Characters 
  • Opening Multiple Documents 
  • Switching between Documents 
  • Displaying Documents in Full-screen Mode 
Lesson 6 – Printing 
  • Previewing a Document 
  • Using Web Page Preview 
  • Printing the Current Document 
  • Printing the Current Page 
  • Printing Multiple Copies 
  • Printing Envelopes and Labels 
Lesson 7 – Using Character Formatting 
  • Formatting Characters 
  • Changing an Existing Font 
  • Modifying the Font Size 
  • Changing the Font Format 
  • Underlining Text 
  • Using Font Effects 
  • Highlighting Text 
  • Copying Character Formatting 
  • Changing Character Case 
Lesson 8 – Using Paragraph Formatting 
  • Formatting Paragraphs 
  • Aligning Paragraphs 
  • Using Click and Type to Align Text 
  • Modifying Paragraph Spacing 
  • Modifying Line Spacing 
  • Copying Paragraph Formats
Mail Merge
  • Lesson 1 – Using Mail Merge
  • Lesson 2 – Merging Mailing Labels and Catalogs
Revisions
  • Lesson 1 – Tracking Revisions
  • Lesson 2 – Using Comments


Tags for this post>>
August 1, 2007

Two Excellent Photoshop Tutorials

Here are two excellent Photoshop Tutorials from the University of Utah. These will help you get up to speed quickly using either Photoshop CS or Photoshop 7. They take you step-by-step through many important Photoshop features and functionality related to editing and manipulating images and photographs that you have downloaded from your digital camera or scanned into your computer. These two tutorials teach essentially the same features, use the one that is appropriate for your version of Photoshop.


Using Photoshop CS2 to Edit Images
(11 pages, 689 kb, pdf format)

Using Photoshop 7 to Edit Images
(11 pages, 804 kb, pdf format)


Tutorial Exercise One – Basics
For this exercise you will start with a scanned photograph and make typical kinds of adjustments. You will learn to use a variety of tools & functions including
• Crop, Measure
• Rotate
• Zoom
• Variations

Correcting the Exposure and Color Balance
When correcting for exposure and color it’s helpful to have the original picture in font of you.

Brightness/Contrast
Increasing contrast makes the light areas lighter and the dark areas darker; decreasing it makes the light areas darker and the dark areas lighter.

Tutorial Exercise Two – Retouching Photos
In this exercise, you’ll use the following Photoshop features, and then proceed to the others:
 - Crop the image
 - Straighten the image
 - Adjust the tonal rang
 - Removing a color cast (or imbalances of color)
 - Experiment with the various choices including the Tone Balance.(Shadows, Midtones, Highlights)

Replacing colors in an image
Options in the Replace Color command’s dialog box allow you to adjust the hue, saturation, and lightness components of a selected area of the image. It helps to zoom in on the area where you want to effect a change.

Sponge tool – Adjusting saturation
When you change the saturation of a color, you adjust its strength or purity. The Sponge Tool is useful in letting you make subtle saturation changes to specific areas of an image. We will use the sponge tool on the red and white stripped tarp covering the main gondola in the picture.

Dodge Tool - Adjusting lightness
Use the Dodge Tool to lighten the highlights along the gondola’s hull and exaggerate the reflection of the water there.

Clone Stamp Tool — Removing unwanted objects
Use the Clone Stamp Tool to remove an object or area by “cloning” an area of the image over the area you want to eliminate.

Replacing part of an image
The sky is fairly drab and overcast in this photograph. You will replace it with a more interesting sky from another file.

Adding Text
Adding a Layer Style (CS)
Horizontal Type Tool (ver.7)
Warp Text (CS)
Move Tool (ver.7)
Applying the Unsharp Mask filter (ver.7)
Flatten image into a single layer

Tutorial Exercise Three – Working with a LOGO
The goal in this short exercise is to take a logo and make a modification to it.

Resolution Explanations
 - Image Resolution
 - Monitor Resolution
 - Printer or Output Resolution

Photoshop Tools
 - Go to Adobe Online
 - Rectangular Marquee
 - Lasso
 - Crop
 - Healing Brush
 - Clone Stamp
 - Eraser
 - Blur
 - Path Selection
 - Pen
 - Notes
 - Hand
 - Set Foreground color
 - Default colors
 - Edit in Standard mode
 - Move
 - Magic wand
 - Slice
 - Brush
 - History Brush
 - Gradient
 - Dodge/Sponge
 - Horizontal Type
 - Rectangle
 - Eyedropper
 - Zoom
 - Set Background color
 - Edit in Quick mask mode
 - Full screen with menu mode or full screen
 - Jump to ImageReady

File Formats Explanations
 - Bitmap
 - GIF
 - JPEG
 - PICT
 - TIFF

Tags for this post>>