Free Microsoft Office Training and Tutorials Blog




    



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

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

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

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

Page :  1