Here are 5 workshop training tutorials for learning how to use basic, intermediate, and advanced features of Access 2003. These are in pdf format and are provided by the University of Nevada.

5 Free Access Workshop Training Tutorials


Microsoft Access 2003Topics:

Level 1 Classes: beginning topics designed to develop basic application skills.  
Level 2 Classes: intermediate topics that assume users have some working knowledge and experience with the application.
Level 3 Classes: advanced topics that assume the users have strong knowledge and experience but wish to extend their skills.Topics:

Level 1 

Introduction to Access Training Manual

The first in the series for building a relational database, this workshop provides the foundation for beginning to create a database and start storing data.   Tables are the basis of each database, and we begin here by learning how to plan and design tables. 

Topics:           
  » Planning Your Database and Tables
  » Designing Tables
  » Field Properties
  » Data Entry

Now that your data is stored, you might want to find a way to view it according to certain criteria, or view certain data.  Queries allow you to pull specified records for viewing or editing.  In this workshop you will learn how to design the queries and understand what they are used for.

Topics:           
  » Types of Queries
  » Designing a New Query
  » Running Queries
  » Using Criteria
  » Creating  Parameter Queries
Sample Database File

Level 2 

Creating Relationships in Access Training Manual

Access is designed for relational databases so that separate tables of information can share data. 

Topics:
  » Understanding Relationships
  » Primary Keys
  » Creating Relationships
  » Working with Subdatasheets
Sample Database File

Access Forms and Reports Training Manual

Forms give you a way to create a more user friendly interface for data entry and data viewing.  Reports provide a printout of complete or summarized data.  Learn how to create and format both.

Topics:           
  » Creating a New Form
  » Using a Form
  » Using the Form Wizard
  » Creating a New Report
  »  Editing a Report
Sample Database File

 

Level 3:

Access Switchboards Training Manual

Creating switchboards for your Access Database gives users a friendly environment to use for data entry, viewing records, pulling reports, and more.  The switchboard can become the center of operations for using the objects in your database and provides an element of security as well.

Topics:
  » Creating a Switchboard
  » Using Command Buttons
  » Using Macros
  » Security Options
Sample Database File

Here are 6 workshop training tutorials for learning how to use basic, intermediate, and advanced features of Excel 2003. These are in pdf format and are provided by the University of  Nevada.

6 Excel 2003 Workshop Training Tutorials


Microsoft Excel 2003

Level 1 Classes: beginning topics designed to develop basic application skills.  
Level 2 Classes: intermediate topics that assume users have some working knowledge and experience with the application.
Level 3 Classes: advanced topics that assume the users have strong knowledge and experience but wish to extend their skills.

Level 1

Basic Excel Skills Training Manual

Learn all the basic skills necessary to start creating lists and tables of data in an Excel spreadsheet, as well as how to format it to be visually clear and attractive.

Topics:
  » The Excel Environment
  » Setting Up Your Data
  » Modifying Data And Worksheets
  » Formatting Your Data
  » Conditional Formatting

Excel Formulas and Functions Training Manual

This workshop will illustrate how to create formulas and functions in Excel so that your calculations are automated. 

Topics:
  » Creating Formulas
  » Creating Functions
  » Editing
  » Absolute Referencing
  » Auditing
Sample File

Using Multiple Excel Worksheets and Workbooks Training Manual

There are times when you might need to organize your data into multiple worksheets or even multiple workbooks.  This workshop will illustrate the tools, tips, and skills you need to manage your data and calculations that span multiple sheets and files. 

Topics:
  » Creating Formulas and Functions Across Spreadsheets
  » Moving Sheets to New Files
  » Creating Links
  » Protecting Sheets
  » Sharing
Sample File

Level 2

Excel Graphs Training Manual

Learn how to create graphs of your data.  It is quick and easy with the Chart Wizard.  The workshop includes tips on formatting your graphs to achieve the perfect visual results.

Topics:
  » Using the Chart Wizard
  » Editing your Graphs
  » Tips and Tricks
Sample File

Using Data Tools in Excel Training Manual

Excel has tools that enable database like record keeping right in your spreadsheet.  Use the tools to view and summarize your records the way you want. 

Topics:
  » Sorting
  » Autofilter
  » Advanced Filter
  » Importing Data
  » Saving as a .csv
  » Group and Outline
Sample File

Level 3  

Excel Macros Training Manual

Automate the tasks you need to do repeatedly, or make quick shortcuts.  Macros allow you to record a string of commands that will execute automatically.  This workshop teaches macros within the context of Excel, but the skills are applicable in Word as well.

Topics:
  » Recording a Macro
  » Running a Macro
  » Debugging and Editing a Macro
Sample File

Here are 4 workshop training tutorials for learning how to use basic, intermediate, and advanced features of Word 2003. These are in pdf format and are provided by the University of  Nevada.

4 Word 2003 Workshop Training Tutorials


Microsoft Word 2003

Level 1 Classes: beginning topics designed to develop basic application skills.  
Level 2 Classes: intermediate topics that assume users have some working knowledge and experience with the application.
Level 3 Classes: advanced topics that assume the users have strong knowledge and experience but wish to extend their skills.

Level 1

Basic Microsoft Word Skills Training Manual

The basics class is designed for those who may have typed in Word before but want to learn more about the environment, use the tools more efficiently, and make the task of creating a document easier. 

Topics:
 » Environment Tour
 » Views
 » Typing and Navigating a Document
 » Editing, Moving, Copying, and Pasting
 » Spelling, Grammar, and Thesaurus
 » Tabs and Indents
 » Bullets and Numbering
 » Page Setup and Print Options
 » Basic Templates

Professional Word Formatting Training Manual
 
Making your document organized, clear, and visually attractive is necessary and even fun.  This workshop addresses essential skills in formatting text, pages, bullets and more.

Topics:
 » Font Formatting
 » Paragraph Formatting
 » Choices for Bullets and Numbering
 » Borders and Shading
 » Using Styles
 » Additional Formatting Options

Sample File

 

Level 2

Creating and Managing Large Word Documents Training Manual

When moving beyond the short letter, essay, article, etc., it may be necessary to start using Word’s large document tools.  The tools make it easier to handle large amounts of text and large numbers of pages. 

Topics:
 » Creating Columns
 » Inserting Breaks
 » Headers and Footers
 » Word Count
 » Table of Contents
 » Index
 » Footnotes
 » Document Map and Thumbnails     
 » Document Properties and Security
 » Large Document Printing Options
 » Templates

Sample File

Sample File

 

Level 3  

Mail Merge Training Manual

If you have names, addresses, or other information stored in a file, you can merge that data in Word to create envelopes, labels, and form letters.   In the Mail Merge workshop, learn how to use data and Word tools to automate your mailings. 

Topics:
 » Single Envelopes And Labels
 » Data Source
 » The Mail Merge Process
 » Creating Mail Merged Envelopes and Labels
 » Creating Mail Merged Form Letters

Here are workshop tutorials and materials for Microsoft Excel, Access, and PowerPoint, provided by North Carolina State University. These tutorials are self-extracting zip files and have an .exe extention. They will decompress automatically when you double-click on them.

• Excel Introduction - Part 1

• Excel Introduction - Part 2

• Excel Introduction - Part 3

• Time Saving Tips in Excel (exercise file - not zipped)

• Introduction to Access Part 1

• Introduction to Access Part 2

• Introduction to Access Part 3

• Introduction to Access Part 4
  

 

• Introduction to PowerPoint

The TechTrax Library contains the following Microsoft tutorials and articles teaching useful features of Word, Excel, Project, Access, and Outlook. Also on this site are utility downloads, office utilities, and html and VBA code modules.

Tutorials for Word, Excel, Project, Access, and Outlook from TechTrax Library

• Microsoft Excel
  
  
  • If Statement Part 1: Introduction
  • If Statement Part 2: Nesting Functions
  • Time Calculations in Excel
    
  
  
• Excel VBA (No Experience Necessary)
  
  
• Lesson 1
• Lesson 2
• Lesson 3
• Lesson 4
• Lesson 5

• Microsoft Word
  
  
  • AutoShapes Part 1: Introduction
  • AutoShapes Part 2: Fill Effects
  • AutoShapes Part 3: Special Effect
  • Word's Character Styles
  • Creating a Table of Contents Spanning Multiple Documents
  • Word Options Utility
  • More on Word Field Vulnerability
  
  
• Help with Letters and Envelopes in Word
  
  
• Part 1: Letter Wizard
• Part 2: Instant Envelopes Using the Macrobutton Field and VBA
• Part 3: Enhancing the MacroButton Field

• Controlling the Printer using Word VBA
  
  
• Part 1: Using VBA to Select the Paper Tray
• Part 2: Using VBA to Control Duplex, Color Mode and Print Quality
• Part 3: Dealing with Different Paper Sizes
• Part 4: Getting Printer Driver Details
  
  
• Microsoft Project
  
  
  • Part 1: Introduction
  • Part 2: Lesson Two
  • Part 3: Lesson Three
  • Part 4: Lesson Four
  • Part 5: Lesson Five—Working With Resources
  • Part 6: Lesson Six—Working With Views, Tables and Filters
  • Part 7: Lesson Seven-Task and Resource Information dialogs, Working Hours and Calendars
  • Fast Presentations In PowerPoint

• Access Database
  
  
  • Part 1: Access Terminology and Relational Database Concepts
  • Part 2: Normalizing Access Data
  • Part 3: Access Data "Clean-up" Tips
    
    
• Microsoft Outlook
  

• Looking Out Through Outlook
• "Do you want to Merge Changes?"