Using Access Basics


Using Excel Basics


Using Excel Intemediate


Using Microsoft Mail


Using PowerPoint


Using Word Basics


Using Word Intermediate

This comprehensive Activ® interactive multimedia training course teaches the basic features of Access. This course teaches participants how to create a database, enter and edit data.

• Understand what an Access database is
• Open an existing database
• Understand what a table is
• Create a new database file
• Get on-line help while using Access
• Create a new table with the Table Wizard
• Understand the concepts of fields and records
• Understand the concept of a primary key field
• Create a new table manually
• Understand the concept of data types
• Know how a Counter type is used
• Set an index
• Add, edit, and delete records in a table
• Format or hide a column
• Copy, move, and delete records
• Sort, find, and filter records in datasheet view
• Understand the concept of a relational database
• Join tables into a relationship
• Be familiar with the Query by Example (QBE) screen
• Add tables to a query
• SwITC Learningh from datasheet to design view
• Apply criteria
• Create a query that operates on joined tables

This comprehensive Activ® interactive multimedia training course teaches the fundamentals and many of the advanced features of the Windows version of Microsoft Excel. This course covers the basic concepts of spreadsheets and how to create spreadsheets in Excel.

• Start Excel
• Understand the concept of a spreadsheet
• Identify the parts of the Excel screen
• Type and save a simple file
• Move around in the worksheet and workbook
• Get help on specific topics
• Enter text and numbers on a sheet
• Recognize how operators and cell references are used in formulas
• Perform calculations using formulas
• Recognize the structure of a function
• Use functions for specific types of calculations
• Copy data and formulas on the sheet
• Change information in a cell
• Change the width of columns and the height of rows
• Insert and delete cells
• Move data to another location on the sheet
• Rearrange data by sorting
• Change the appearance of numbers to reflect currency, commas, decimal places, and other formats
• Add character enhancements, such as bold and italics
• Change fonts and font sizes
• Spell check a sheet
• Use print preview and other print options to prepare a sheet for printing
• Print a sheet

This comprehensive Activ® interactive multimedia training course teaches the fundamentals and many of the advanced features of the Windows version of Microsoft Excel. This course covers using formulas, formatting, printing, styles, consolation, graphics, data management, and macro capabilities with Excel.

• Place borders in cells to add emphasis or organization to the data
• Use shading to emphasize or de-emphasize cells
• Use Excel's automatic formatting options
• Place a text box on a sheet
• Create simple draw objects on a sheet
• Recognize the basic types of charts available with Excel
• Create a chart using the Chart Wizard
• Add or remove titles, legends and other chart items
• Use formatting options to make changes to a chart
• Size a chart on the worksheet
• Understand the basic concept of multiple sheets in a workbook
• Name sheets using the workbook sheet tabs
• Group sheets for creating, editing, and formatting
• Insert and delete sheets
• Share data between sheets by linking formulas
• Understand the basic concepts of working with lists in Excel
• Generate a form for entering data in a list
• Create a data list using a form
• Sort information in the list using at least two keys
• Filter information in a list

This comprehensive Activ® interactive multimedia training program introduces Microsoft Mail, a popular electronic mail package. Participants will practice creating, receiving, and forwarding mail messages.

• Understand the basic concepts of electronic mail
• Start Microsoft Mail and enter a password
• Recognize and use the parts of the Mail screen, including menus, the tool bar, windows, and the status bar
• Access on-line help
• Address a message
• Type and edit a message note
• Attach a file to a message
• Check spelling and send a message
• Recognize notifications of new and unread messages
• Open and read a message
• View, save, and delete messages
• Reply to a message
• Forward a message to another user
• Sort message lists by name, subject, and time received
• Create new folders and subfolders
• Move and copy messages to folders; add and remove names to a personal address book
• Create personal groups
• Change passwords

This comprehensive Activ® interactive multimedia training program covers the fundamentals of Microsoft PowerPoint. This course is designed to teach users how to work with text and graphic elements to design an on-screen, graphic presentation.

• Start PowerPoint from Windows
• Identify the different parts of the PowerPoint screen
• View and work with slides in different modes
• Recognize the basic design elements of a slide presentation
• Choose a template
• Insert clip art, drawings, and graphs onto a slide
• Edit and position text
• Rearrange slides, change templates and colors
• Design a slide show complete with transitions
• Print notes and handouts

This comprehensive Activ® interactive multimedia training course teaches basic word processing skills with the Windows version of Microsoft's Word. This course teaches participants to start Word, become familiar with the screen layout, and practice basic document editing and printing techniques.

• Execute Word for Windows start-up procedures
• Perform basic editing and printing
• Work with the Word for Windows screen layout
• Create, modify, save, and print documents

This comprehensive Activ® interactive multimedia training course teaches more advanced word processing skills with the Windows version of Microsoft's Word. This course teaches participants to participants to use Word templates, built-in writing aids, macros, tables, and graphics.

• Use Word for Windows writing aids such as spell checking and the built-in thesaurus
• Create form documents through the Print Merge feature
• Quickly standardize work by attaching stylesheets and applying styles
• Apply borders and shading
• Incorporate graphics
• Create and incorporate tables.