Here are 4 excellent Flash Tutorials at California Polytechnic State University. These Flash MX 2004 tutorials will teach you how to use Flash in your applications to create interactive and animated Web sites. They start off with an introduction to various Flash interfaces and tools. Then the tutorials cover many animation and navigation tools that are available in Flash for your use. After finishing this course of four Flash tutorials you will be able to create some great applications using this application. These Flash tutorials are in pdf format.


4 Flash Tutorials:

Flash MX 2004 Interface / Tools Introduction (667 Kb, 18 pages)
This section gives you a basic introduction to the world of Flash development. Various Flash MX interfaces and tools are explained here in this section.

 - Working with the Timeline
 - Moving the playhead
 - Frames and keyframes
 - Working with layers
 - About the Property inspector
 - About the Library panel
 - Components in the Library panel
 - Working with common libraries
 - Draw vector art
 - Drawing curved paths with the Pen tool
 - Adjusting anchor points on paths
 - Reshaping using the Selection tool
 - Optimizing curves
 - About overlapping shapes in Flash
 - Erasing
 - Transforming objects freely
 - Scaling objects
 - Add text
 - Creating scrolling text
 - Aligning objects
 - Tweened animation
 - Frame-by-frame animation
 - Layers in animation
 - Creating keyframes
 - Representations of animations in the Timeline
 - Examples


Flash MX 2004 Introduction Lesson (644 Kb, 7 pages)
This section explains some of the introductory topics on Flash. Basic procedures like creating a new document, opening a new document, defining document properties, creating movie clips, drawing rectangle are illustrated here.

 - Creating a new document
 - Open a new document
 - Define document properties
 - Adding media content
 - Add text
 - Create a movie clip
 - Add text
 - Resize with Free Transform tool
 - Drawing a rectangle
 - Copy / Paste Text
 - Common Library


Flash MX 2004 Animation Lesson (182 Kb, 7 pages)
Here in this third section teaches lessons on animation. The subjects which are covered in this section are playing with frames, motion between animation, onion skinning, drawing with pencil tool, creating a motion tween etc.

 - Opening a document
 - Opening the library
 - Grouping objects
 - Frames and keyframes
 - Onion skinning
 - Creating frame-by-frame animations
 - Copying and pasting frames
 - Frames and keyframes
 - Motion between animation
 - Test the application
 - Copy / Paste Text
 - Drawing ovals
 - Create a movie clip
 - Grouping objects
 - Onion skinning
 - Creating frame-by-frame animations
 - Copy / Paste Text
 - Drawing with the Pencil tool
 - Create a movie clip
 - Tweening shapes
 - Creating a motion tween


Flash MX Navigation Lesson (27 Kb, 4 pages)
This section helps you to create the over all design (user interface) and setup home page navigation.

Popularity: 12% [?]

Here are two Access 2007 Tutorials, at the University of South Dakota, which you can use to increase your MS Access skills. The first Access tutorial introduces you to the world of the database management systems through using Access. The second Access tutorial handles some of the advanced topics in like queries, forms and reports. These tutorials are in pdf format.


Access Tutorial Part 1  (765 Kb, 24 pages)
This section of the MS Access tutorials gives you a helping hand in getting started with the database management system. The section explains basic features of Access like templates, adding table to your database, creating forms and reports etc.

 - Getting Started
 - The New File Extension
 - Access Templates
 - Add a Table to your Database
 - Create a Form
 - Create a Report
 - A Few Terms
 - Database design basics
 - Some database terms to know
 - What is good database design?
 - Specifying primary keys
 - Naming Conventions
 - Create a new table
 - Add fields to a table in Datasheet view
 - Add a field from the Field List pane
 - Set a field’s data type in Datasheet view
 - Set the primary key


Access Tutorial II: Queries, Forms, and Reports  (532 Kb, 15 pages)
This section of the MS Access tutorials introduces you to features like queries, creating forms, understanding controls, editing forms, subforms and reports.

 - Introduction to Queries
 - Creating Forms
 - Understand controls
 - Editing Forms
 - Subforms
 - Reports

Popularity: 15% [?]

Here are four Excel 2007 Tutorials, hosted by the University of South Dakota. These Excel tutorials introduce you to this powerful analytic, organization, and data logging application. They are organized in a series of pdf documents that take you through and demonstrate various features, tools, and tips of Excel. The purpose of these Excel 2007 tutorials is to provide instructions on performing both basic and advanced Excel tasks and functions.


Excel Tutorial Part 1: Getting the Basics  (877 Kb, 22 pages)
This first Excel tutorial focuses on the basic features of Excel like the ribbon, adding headers and footers, navigation, entering data in worksheet, and merging and splitting of cells. The Excel 2007 file used in the tutorial can be downloaded from here.

 - First look into Excel
 - Components of Excel
 - The Ribbon
 - Key Tips
 - Using a Previous Version of Excel
 - Inserting Columns
 - Formatting Cells
 - AutoSum
 - Add Headers and Footers
 - The New Workbook Window
 - Navigation in Excel
 - Modifying Cells
 - Entering Data into a Worksheet
 - Merge or Split cells
 - Combine the contents of multiple cells into one cell
 - How do I work with people who don’t have Excel 2007 yet?


Excel Tutorial Part 2: Charts and Graphs  (346 Kb, 11 pages)
This Excel tutorial teaches you charts and graphs in Excel. The tutorial explains various chart and graph features like formatting chart titles, individual columns, moving and resizing tips, modifying the properties of your charts, and changing the axis scale. The Excel 2007 file used in the tutorial can be downloaded from here.

 - Creating Charts in Excel
 - Change the Chart
 - Add Chart
 - Change how your Chart
 - Format Chart Titles
 - Format Individual Columns
 - Add your Chart to a PowerPoint Presentation
 - Choosing a chart type
 - Resize and move an embedded chart
 - Moving and resizing tips
 - Data of the Chart is Linked to the Chart
 - Modify the properties of your charts
 - Add a graphic to a chart
 - Change the axis scale
 - Freeze rows and columns in a List


Excel Tutorial Part 3: Conditional Formatting  (614 Kb, 21 pages)
This tutorial introduces you to conditional formatting in Excel. The topics covered include creating conditional formula that results in a logical value, an overview of formulas, using array formulas and array constants. The three Excel 2007 files used in this tutorial can be downloaded from here: Grade Sheet, Loan Worksheet, and Tutorial Worksheet.

 - Conditional Formatting in Excel
 - Create conditional formulas
 - Create a conditional formula that results in a logical value (TRUE or FALSE)
 - Create a conditional formula using IF, AND, and OR
 - Functions: A Quick Refresher
 - Overview of formulas
 - Using functions and nested functions in formulas
 - The difference between absolute, relative and mixed references
 - Using names in formulas
 - Using array formulas and array constants


Excel Tutorial Part 4: Pivot Tables  (535 Kb, 15 pages)
This tutorial handles the introduction of Excel pivot tables to your skill set. All the basic features that are related to pivot tables in Excel are covered here. Features that are explained include: inserting pivot tables, adding a report filter, filter the data, and using a custom calculation. The two Excel 2007 files used in the tutorial can be downloaded from here: PivotTable_II and PivotTable_III.

 - Get your Data Ready
 - Insert a Pivot Table
 - Add a Report Filter
 - Group the Dates
 - Pivot the Report
 - Filter the Data
 - Filter by using Comparisons
 - Filter by Date
 - Change how Subtotals are Displayed
 - Use a custom calculation
 - The GETPIVOTDATA Function
 - Change the Format of a PivotTable Report

Popularity: 16% [?]