I just wrote a new blog post on our sister site, at Intelligentedu.com/blogs, detailing and deep linking to a site providing excellent CSS Tutorials. They include sample code, exercises and a CSS guide to help you learn and apply CSS to your web pages.

Popularity: 1% [?]

Here are 3 Access 2003 Tutorials, from by Hillsborough Community College, that take you through the following features and tools in Accecss: creating tables and ussing design view to enter data; setting data types; using a primary key; inserting and deleting rows in a table; creating and running queries; creating and using forms; importing data from and exporting data to Excel; and using Aggregate Functions.


Access 2003 Training Tutorial I
(23 pages, 598kb, pdf)
Upon completion of this Access training module, you will know and be able to:
1. Understand the three types of relationships: one-to-many, many-to-many and one-to-one;
2. Create a new database;
3. Create tables for data entry in design view;
4. Use, understand, and set data types: Text, Memo, Number, Currency, Date/Time, AutoNumber, Yes/No, Lookup wizard.
5. Create and delete a primary key;
6. Insert and delete a row.

Access 2003 Training Tutorial II
(29 pages, 1.1mb, pdf)
Upon completion of this Access training module, you will know and be able to:
1. Create a query;
2. Sort fields in a query;
3. Show fields in a query;
4. Run a query using wildcards;
5. Run a query for fields not in result;
6. Run a query for a number value;
7. Run a query using the comparison criteria “And”;
8. Run a query using the comparison criteria “Or”;
9. Create a form using the Wizard tool;
10. Understand the basics of the Toolbox: Controls;
11. Insert a graphic/image;
12. Insert and image;
13. Insert an unbound object frame;
14. Resize and image/graphic.

Access 2003 Training Tutorial III
(23 pages, 969kb, pdf)
Upon completion of this Access training module, you will know and be able to:
1. Import a table from Excel;
2. Import data from a delimited text file;
3. Export an Access file to Excel;
4. Understand the purpose of Aggregate Functions;
5. Create and run a query using count;
6. Create and run a query using average;
7. Create and run a query using the parameter between.

Popularity: 1% [?]

Here are 2 Excel 2003 Tutorials, from by Hillsborough Community College, that will help you learn many of Excel’s basic features, along with how to enter and use formulas and charts. These tutorials include some nicely done screen shots that help in demonstrating the features presented.


Excel 2003 Training Tutorial I
(30 pages, 786kb, pdf)
Upon completion of this Excel training module, you will know and be able to:
1. Use the Menu bar, Standard and Formatting Toolbars;
2. Know the parts of an Excel worksheet;
3. Know how to open and save a workbook;
4. Use the Page Setup Dialog box;
5. Insert a row, column, or worksheet;
6. Format a cell;
7. Change the font type, style, size and color of a cell or range of cells;
8. Create a border around a range of cells;
9. Use basic Excel formulas;
10. Know how to use the Chart Wizard to create a chart

Excel 2003 Training Tutorial II
(17 pages, 241kb, pdf)
Contents:
 - Overview
 - Setting up the Spreadsheet
 - Inputting Data
 - AutoSum
 - Average Formula
 - Multiplication Formula
 - Minimum Formula
 - Maximum Formula
 - Types of Charts
 - Creating a Chart

Popularity: 1% [?]