|
MICROSOFT
WORD LEVEL 2 - COURSE # 201B
Tables
Performing calculations in tables
Creating charts
Importing worksheets and data
Introduction to styles
Applying styles
Creating styles
Redefining and deleting styles
Introduction to Templates
Using Templates
Introduction to merging
Creating data
Completing main documents
Merging data with the main document
Introduction to macros
Editing and testing macros
Creating and assigning macros
Newspaper columns
Formatting text into newspaper columns
Using graphics
MICROSOFT ACCESS
LEVEL 2 - COURSE # 204B
Principles of Table
Normalizing data for fourth and fifth normal forms
Normalizing data
Principles of table relationship
Establishing and testing referential integrity
Analyzing table relationship
Table design techniques
Indexing techniques
Data validation techniques
Designing select queries
Creating multiple-table queries
Working with calculations
Enhancing form design
Adding calculations to a form
Customizing the form design
Adding combo boxes to a form
Sub form design
Creating a form that contains a sub form
Customizing reports
Sub reports
Customizing a report created by a report wizard
|
|
MICROSOFT
EXCEL LEVEL 2 - COURSE # 202B
Customizing the work area
Creating Templates
Creating a new toolbar
Working with existing toolbars
Advanced formula
The VLOOKUP Function
The IF Function
Nested Function
Pivot Tables
Creating pivot tables
Working with pivot tables
Multiple file linking
Working with workbooks
Linking individual cells
Consolidate data
Using the goal seeker and solver utilities
Consolidating worksheets
Scenario Manager
Introduction to macros
Viewing and editing VBA code
Recording a macro
INTERNET EXPLORER
AND E-MAIL - COURSE # 211
Setup an Internet connection
Connecting to the Internet
Introducing the Internet Explorer Browser
Learning how to browse the web
Finding information on the Internet
Browsing the web offline
Printing and saving information
Sending information over the Internet
Protecting your computer while on-line
Controlling access to inappropriate Internet content
Customizing your Browser
Accessibility and shortcuts
Introducing outlook express mail program
Configuring your mail account
Sending and receiving mails
Managing your mails |
