Video Training Tapes 
International Media Center

Microsoft Office 2000 training videos are available to faculty, staff and students for viewing at the International Media Center located in AICV219 / B wing.

To view a tapes table of contents click on the corresponding link below

 


View Training Tape Table of Contents

Word
Beginning
Intermediate
Advanced
Excel
Beginning
Intermediate
Advanced
PowerPoint
Beginning
Intermediate
Advanced
Access
Beginning
Intermediate
Advanced

 

Return to IT Training

 

 

 

 

 

Word

Back to Top

Beginning / Word 2000
(1 hour 11 minutes)

Intermediate / Word 2000
(1 hour 21 minutes)

 

Exploring the Word 2000 Environment

  • Using keyboard shortcut
  • Using the Overtype mode
  • Selecting / deselecting test
  • Formatting / saving a document
  • Using the Font dialog box
  • Creating a new document
  • Using templates
  • Setting margins/page orientation
  • Adjusting tab
  • Inserting Date & Time/Auto Tex
  • Using the spelling & grammar feature
  • Printing

Getting started in Word 2000

  • Inserting page breaks/ symbols/tab stops
  • Adjusting margins
  • Adding / modifying page numbers
  • Creating / formatting headers & footers
  • Applying a page border
  • Creating an outline
  • Saving HTML files
  • Keying / editing text In columns
  • Creating / formatting tables
  • Merging cells
  • Adding graphics
  • Drawing / modifying lines
  • Adding a 3-D effect
  • Preparing charts
  • Importing data
  • Using the Mail Merge Helper
  • Sorting / merging records
  • Printing envelopes & labels
 

 

Excel

Back to Top

Beginning / Excel 2000
(1 hour 36 minutes)

Intermediate / Excel 2000
(1 hour 35 minutes)

Advanced / Excel 2000
(1 hour 26 minutes)

Exploring the Excel workspace

  • Examining a worksheet
  • Entering text & numbers
  • Modifying the size of columns /  rows
  • Using AutoFit
  • Creating a new workbook
  • Working with series (AutoFill)
  • Editing cell content
  • Merging cells
  • Applying Font styles
  • Entering formulas in a cell
  • Using the Formula bar
  • Entering a function
  • Using AutoSum
  • Clearing cell content / formatting
  • Printing an entire workbook
  • Previewing a worksheet
  • Setting page margins / centering
  • Setting up headers / footers
  • Setting ; clearing a Print Area

Changing Zoom Settings

  • Splitting a worksheet
  • Freezing Columns and rows
  • Inserting / deleting selected cells
  • Inserting columns & rows
  • Moving Selected Cells
  • Utilizing the office clipboard
  • Adding / selecting named ranges
  •  Inserting rows in a named range
  • Preparing formulas
  • Revising formulas
  • Applying boarders / shading
  • Hiding / displaying gridlines
  • Changing indents
  • Defining / applying styles
  • Applying auto formats
  • Creating templates
  • Customizing an invoice
  • Applying / editing templates
  • Applying date formats
Getting started in Excel
  • Discussing grouping
  • Outlining a worksheet
  • Previewing a worksheet
  • Changing page orientation
  • Setting print titles & options
  • Inserting / removing a page bread
  • Opening multiple workbooks
  • Creating / saving a customized workspace
  • Consolidating data from multiple workbooks
  • Creating a link to source data
  • Viewing an Excel list
  • Using data forms
  • Adding a new record to a list
  • Finding records using a data form
  • Performing single / multi-level sorts
  • Applying data filters
  • Exporting to other applications
  • Importing from Text files
  • Adjusting the decimal place
  • Importing a table from an HTML line

Access

Back to Top

Beginning / Access 97
2 hours 16 minutes

Intermediate / Access 97
2 hours 12 minutes

Advanced / Access 97
2 hours 22 minutes

     

Introduction

  • The Access Desktop
  • Opening an Existing Database
  • The Database Window
  • A Preview of the Database  Components
  • Getting Help & the Assistant
  • Working with an Existing Database
  • Viewing & Navigating Table Data
  • Editing Table Data
  • Adding Records to a Table
  • Selecting Records to a Table
  • Selecting Records
  • Deleting Records
  • Find & Replace
  • 2.8  Modifying the Appearance of an Datasheet
  • Spell-check an Auto-correct
  • Designing Your Own Database
  • Planning Your Database
  • Specifications
  • Normalization
  • Data Integrity
  • Field Types
  • The Database Wizard
  • Creating Your Won Tables
  • The table Wizard
  • Creating a Table Without a Wizard
  • Setting a Primary Key
  • Form Basics
  • Using an Existing Form
  • Filter By Form
  • Creating a Form with the Form Wizard
  • Query Basics
  • Creating a Query with a Wizard
  • Creating a Query without a Wizard
  • Adding Fields to the Query Grid
  • Entering Selection Criteria & Sorting query Output
  • Removing Fields from the Query Grid
  • Report Basics
  • Creating a Report with the Report Wizard
  • Report Brands
  • Sorting & Grouping
  • Page Setup
  • Printing a Report

Advanced Table Techniques

  • The field Size Property
  • The Caption Property
  • Establishing Default Values
  • Entering Field-Level Validations
  • Entering Table –Level Validations
  • Designating a Field as Required
  • Formatting Field Data
  • Using Input Masks
  • The Lookup Wizard
  • Adding Table Indexes
  • Working with Hyperlink Data
  • Establishing Relationships
  • Referential Integrity
  • 2.2  Cascading Update & Delete
  • Modifying Table Design While in 2.4  the Relationships Window
  • Advanced Selection Queries
  • Entering Complex Criteria
  • Building Multi-table Queries
  • Adding Calculated Fields
  • Parameter Queries
  • Totals Queries
  • Top Value Queries
  • Displaying Unique Values
  • Cross tab Queries
  • Advanced Form Design
  • Adding Controls
  • Selecting Controls
  • Moving Controls
  • Deleting & Aligning Controls
  • Sizing Controls
  • Changing Control Properties
  • Form Properties
  • Advanced Report Design
  • Creating Groups & Totals Reports
  • Working with control Properties

Database Window Tricks

  • List Types
  • Renaming Objects
  • Hide Objects
  • Drag & Drop to Create Desktop Shortcuts
  • Drag & Drop Between Applications
  • Importing Exporting and Linking
  • Exporting to Another Database
  • Exporting to an Excel Spreadsheet
  • Exporting to ASCII
  • Exporting to HTML
  • Importing from Another Access Database
  • Importing Spreadsheet Data
  • Importing ASCII Data
  • Importing from HTML
  • Linking to Another Access Database
  • Linking to Another Type of Database
  • The Linked Table Manager
  • Action Queries
  • Make Table queries
  • Append Queries
  • Update Queries
  • Delete Queries
  • Power Query Techniques
  • The Find Duplicates Wizard
  • The Find Unmatched Wizard
  • Inner & Outer Joins
  • Self-Joins
  • Union Queries
  • Power Form Techniques
  • Working with Built-in Tab Control
  • Working with Form Headers and Footers
  • Creating Multi-table Forms
  • Adding OLE Objects to Forms
  • Using a Bitmap as a Form Background
  • Other Important Form & Control 5.7  Properties
  • Saving a Form as HTML
  • Power Report Techniques
  • Building Reports With Sub-Reports
  • Advanced Brand Techniques
  • Adding / Modifying Calculations

PowerPoint

Back to Top

Beginning / PowerPoint 2000
1 hour 20  minute

Intermediate / PowerPoint 97
2 hours

Advanced / PowerPoint 2000
1 hour 16  minutes

     

Using a Template

  • Discussing toolbars
  • Editing slides
  • Inserting headers/footers
  • Using the AutoContent wizard
  • Demoting / promoting items
  • Expanding / collapsing slides
  • Working with text
  • Inserting ClipArt
  • Scaling objects / adding slides
  • Inserting charts / editing datasheets
  • Adding transition effects
  • Applying sound / animating text
  • Changing chart types
  • Editing data series
  • Setting up a slide show
  • Adding speaker notes
  • Customizing handouts
  • Printing notes / handouts

PowerPoint Editing

  • Indents, Alignment, & Spacing
  • Inserting a Text Object
  • Setting & Removing Tab Stops
  • Working with bullets
  • Changing Text Case
  • The Format Painter
  • Formatting Text Objects
  • Power Slide Development
  • Creating Summary Slides
  • Reducing Slide Clutter – The expand Slide Feature
  • Enhancing Your Slides with Comments
  • Adding a Slide Header & Footer
  • The slide Finder
  • The Style Checker
  • Slide Miniatures & Black & White View
  • Working with Masters
  • Creating Your Own Templates
  • Enhancing Your Presentations with ClipArt
  • Adding ClipArt
  • Auto ClipArt
  • Using the Picture Toolbar to   Enhance Your Pictures
  • Say It With Impact – Word Art
  • Adding a Word Art
  • Using the Word Art Toolbar
  • Charting
  • Inserting a Chart
  • Entering Chart Data
  • Excluding Chart Data
  • Adding Data From a Spreadsheet
  • Changing the Chart Type
  • Adding Pizzazz to Your Charts
  • Inserting Organization Charts
  • Inserting an Organizational Chart
  • Adding & Deleting Relationships
  • Changing the Chart Style
  • Inserting Tables & Spreadsheets
  • Inserting & Enhancing Word Tables
  • Inserting Spreadsheets

Identifying Components

  • Inserting / formatting a Word table
  • Importing text
  • Creating / modifying tables
  • Adding / formatting bullets
  • Copying slides / altering slide layout
  • Building organizational charts
  • Setting tabs
  • Adding shapes
  • Rotating / filling objects
  • Aligning / distributing objects
  • Drawing objects
  • Adjusting color & position of objects
  • Customizing ClipArt
  • Creating summary slides
  • Adding video clips
  • Creating an action button
  • Applying animation effects
  • Creating an Agenda Slide
  • Inserting an Excel chart
  • Placing text inside shapes

Back to Top