Access Session 1
Section A: Introduction
· Relational Databases
· Flat System
· Relational System
· Database Components
Section B: Database Objects
· Tables
· Queries
· Forms
· Reports
· Macros
· Modules
· Data Access Page
Section C: Database Planning
· Naming Conventions
· Convention Examples
· Database Design
· Plan Purpose
· Plan Tables
· Plan Fields
· Field Names
· Plan Relationships
Section D: Examining Access
· Starting Access
· Table View
· Switching Views
· Query View
· Forms View
· Report View
· Create New Database
· Database Wizard
Section E: Creating Tables
· File Format Considerations
· Create Table
· Data Type
· Description
· Assign Primary Key
· Saving
· Using the Table Wizard
Section F: Text Field Properties
· Field Size
· Format
· Caption
· Default Value
· Required
· Allow Zero Length
· Numbered Text Fields
· Input Mask
Section G: Number Field Properties
· Number Field Size
· Format Date
· Validation Rule
· Validation Text
· Validation Data
· End Date Validation Rule |
Access Session 2
Section A: Working with Data
· Moving Through Datasheets
· Adding Records
· Editing Records
· Deleting Records
· Keyboard Shortcuts
Section B: Working with Datasheets
· Modifying Datasheet Format
· Modifying Datasheet Font
· Modifying Column Widths
· Hiding/Showing Columns
· Moving Columns
Section C: Manipulating Data
· Sorting Data
· Finding Data
· Filtering Data
· Filter Excluding Selection
· Filter for Input
· Filter by Form
· Saving As Query
Section D: Working with Table Structure
· Manipulating Fields
· Changing Data Types
· Deleting Fields
· Moving Fields
· Using Name AutoCorrect
· Property Update Options
· Creating Lookup Fields
· Using Lookup Wizard
Section E: Dependencies & Datasheets
· Checking Object Dependencies
· Subdatasheets
· Manipulating Subdatasheets
Section F: Shaping Up Tables
· Copying
· Renaming
· Deleting
· Printing Tables
Section G: Importing & Exporting
· Importing
· Import Spreadsheet Wizard
· Exporting
Section H: Relationships
· Understanding Relationships
· Referential Integrity
· Join Types
· Understanding Join Types
· Relationship Types
Section I: Creating Relationships
· Relationship Setup
· Adding Tables
· Arranging Tables
· Create Permanent Relationship
· Printing Relationships |
Access Session 3
Section A: Select Queries
· Creating in Design View
· Sorting
· Adding Additional Tables
· Changing Relationship Type
· The Show Box
Section B: Filtering with Criteria
· Exact Entries
· Comparison Operators
· Filter Range
· Null/Not Null
· Using "And" Statements
· Either "Or" Statements
· Unique Values
Section C: Calculations
· Formulas
· Group By
· Concatenation
Section D: Intro to Forms
· Creating Auto Forms
· Form Components
· Working with Controls
· Aligning Controls
· Removing Controls
· Adding Controls
· Using the Forms Wizard
Section E: Working in Forms
· Formatting Forms
· Control Properties
· Navigating a Form
Section F: Data Access Pages
· Save Form As
· Using the Page Wizard
· Apply Themes
· Preview in Browser
Section G: Working with Reports
· Creating Auto Reports
· Using the Reports Wizard
· Report Controls & Sections
· Modifying Controls
· Changing Sorting & Grouping
· Controlling Page Breaks
· Report Output Options
· Exporting to Word
Section H: Maintaining Database
· Using Compact & Repair
· Backing up Data
· Convert Database |
Excel Session 1
Section A: Introduction
· Exploring Excel
· Data Types
· Navigating
· Selecting Data
· Noncontiguous Selection
Section B: Workbook Basics
· Entering Data
· Dates
· Numbers
· Fill Handles
· Fill Options
· Save
Section C: Editing Worksheets
· Replace/Edit Data
· Cut, Copy & Paste
· Drag & Drop
· Delete Data
· Rows & Columns
· Change Width & Height
· AutoFit
· Data Validation
Section D: Formatting Data
· Format Toolbar
· Font Format
· Merge & Center
· Format Cells
· Indent
· Borders & Shading
· Layout Options
· Add Graphics
Section E: Advanced Formatting
· Number Formats
· Decimals
· Special Features
· Dates
· Custom Formats
· Create Custom Format
· Conditional Format
· AutoFormat
Section F: Reusable Formats
· Using Templates
· Creating Styles
· Modifying Styles
· Creating Template
· Use/Save Worksheet |
Excel Session 2
Section A: Basic Formulas
· Formula Syntax
· Create Formula
· Create & Edit Formulas
· Relative Reference
· Absolute Reference
· Complex Formulas
· Formula Rules
Section B: Formula Auditing
· Tracing
· Evaluate Formula
· Circle Invalid Data
· Watch Window
Section C: Basic Functions
· Function Syntax
· Common Functions
· Building Functions
· Paste Function Box
· Paste Function Button
· AutoCalculate
· Date & Time Functions
· Logical Functions
Section D: Working with Names
· Create Names
· Range Names
· 3-D Names
· Use Names
· Range Functions
· Paste References
· Edit Range
Section E: Organization
· Worksheets
· Copy Worksheets
· Consolidate Data
· Tab Naming
Section F: Charts
· Chart Wizard
· Define Data
· Layout Options
· Position Options
· Charting Toolbar
· Format Options
· 3-D Charts
· Modify Data
Section G: Save & Print
· Save Options
· Save As Web Page
· View Saved Files
· Print Setup
· Page Setup Options
· Print Area |
Excel Session 3
Section A: Protecting Data
· Worksheet View
· Cell Protection
· Allow Range Editing
· Protect Sheet
· Protect Workbook
Section B: Sharing Workbook
· Set Up for Sharing
· Comments
· Email for Review
· View Changes
· Track Changes
· Compare Side by Side
Section C: Database
· Defining Databases
· Database Components
· Using Forms
· Filtering with Forms
Section D: Sorting Database
· Freeze Panes
· Sort Buttons
· Sort Columns
· Sort Order
Section E: Database Function
· DFunction Syntax
· Modify Function
· And vs. Or
· Record Count
· VLookup
Section F: Filtering
· AutoFilter
· Multiple Filters
· Custom Filters
· Advanced Filters
· Copy to Location
Section G: Subtotals
· Working with Subtotals
· Count Subtotal
· Average Subtotal
· Grouping
· Linking Workbooks |
Excel Session 4 (CD only)
Section A: Excel Advanced Features
· Quick Review
· Ways to Manipulate Data
· What-if Analysis Tools
· Goal Seek
Section B: Using Solver
· Setting Solver Parameters
· Modifying Parameters
· Solver Results
Section C: Forecasting with Trendlines
· Terminology
· Trendline Types
· Creating Charts
· Adding Trendlines
· Formatting and Deleting Trendlines
Section D: Working with Scenarios
· Creating Scenarios
· Showing Scenarios
· Modifying Scenarios
· Merging Scenarios
· Scenario Summaries
· Protecting Scenarios
Section E: PivotTables and PivotCharts
· PivotTable Features
· PivotTable Terminology
· PivotTable Fields
· Creating PivotTables
· PivotTable Layout
· Field List and Toolbar
· Modifying PivotTables
· Filtering PivotTables
· PivotCharts
· Grand Totals and Viewing Details
Section F: Capturing Data from the Web
· Basic Options
· Refreshable Web Queries
· External Data Toolbar
· Web Query Options
· Saving Web Queries
· Exporting Web Pages to Excel
· Redirecting Web Queries
Section G: Using XML
· Saving Spreadsheets to XML Format
· Creating XML Maps
· Exporting XML Data |
Excel Session 5 (CD only)
Section A: Macros
· Macros Defined
· Naming Rules
· Storing Macros
· Recording a Macro
· Running a Macro
· Editing a Macro
· Absolute vs. Relative Cell Referencing
· Assigning Macros to Buttons
Section B: Web Functionality
· Hyperlinks
· E-mail a Hyperlink
· Hyperlinks Within Files
· Hyperlinks to Other Files
· Optimizing for Web Publication
· Publishing to the Web
· Office Web Components
· Viewing in a Browser
· Republishing
Section C: Customizing the Interface
· General and View Options
· Calculation and Edit Options
· Custom Lists and Chart Options
· Save Options
· Spelling Options
· Security Options
· Customizing Toolbars
· Creating New Menus
Section D: Manipulating the Screen Display
· Freezing Panes
· Splitting Screens
· Opening in a New Window
· Comparing Side by Side
Section E: Working with Templates
· Benefits
· Creating Styles
· Copying and Importing Styles
· Saving Templates
· Using Templates
Section F: Excel with Other Applications
· Word Mail Merge
· Importing Contacts to Outlook
· Outlook Journal Options
· Linking to Outlook Contacts
· Linking to PowerPoint Charts |
Outlook Session 1
Section A: Introduction
· What is Outlook?
· Usage
· Email Support
· Exchange Storage/Sync
· Personal Folders
Section B: Outlook 2003 Interface
· Starting Outlook
· Setup Email
· Adding Email Account
· Pane View
· Navigation Pane Options
Section C: Navigating with Outlook
· Folders
· Inbox/Reading Pane
· Outlook Today
· Go Menu
Section D: Creating Messages
· Email Messages
· Addressing Options
· Checking Names
· Subject Line
· Text Block
· Message Options
· Tracking/Delivery Options
· Send/Receive
Section E: Working with Messages
· Outbox
· Sent Items
· Inbox
· Voting Options
· Reply/Reply to All
· Forwarding
Section F: Global Email Options
· Message Handling
· Advanced Options
· Reply/Forward Options
· Mail Setup Tab
· Mail Format Tab
· Signatures
· Spell Check
· Reading Pane
Section G: Formatting Messages
· Creating New Message
· Formatting Toolbar
· Create Attachment
· Check Spelling
· Saving Drafts
· Changing Formats
· Stationery Options
Section H: Securing Your Inbox
· Blocked Attachments
· Beaconing
· Viewing Graphics
· Junk Email Options
· Adding Senders |
Outlook Session 2
Section A: Managing Your Inbox
· Read/Unread Messages
· Flagging Messages
· Sorting Inbox
· Advanced Find
· Completing Flags
· Using Colors
Section B: Message Options
· Recalling Messages
· Resending Messages
· Out of Office Assistant
· Receiving Out of Office
Section C: Printing, Saving, & Deleting
· Printing Messages
· Saving Messages
· Deleting Messages
· Deleting Shortcut
Section D: Folders & Folder Rules
· Creating Folder
· Creating Subfolder
· Renaming Folder
· From Inbox to Folder
· Creating Folder Rule
Section E: Create & Edit Contacts
· Creating New Contact
· Adding Email Address
· Adding a Picture
· Adding Phone Numbers
· Adding Address
· Assigning Categories
· Creating Categories
· Contact Details
Section F: Working With Contacts
· Contact Views
· Record Options
· Contact Actions
· Vcards
· Add to Contact List
Section G: Distribution List
· Create Group
· Nested Lists
· Use Distribution Group |
Outlook Session 3
Section A: Calendars
· Views
· Customized View
· Add Appointments
· Events/Time Frames
· Notification Options
· Recurring Appointments
· Move/Delete
· Events
Section B: Meetings
· Meeting Request
· Set Up Meeting Group
· Set Meeting Times
· Meeting Request
· Meeting Tally
· Modify Meetings
Section C: Advanced Calendars
· Multiple Calendars
· Group Schedule
· Calendar Work Week
· Calendar Options
Section D: Sharing Information
· Share
· Add Delegates
· Designated Delegates
· View Shared Calendars
· Printing
· Web Calendars
Section E: Task & Notes
· Add Task
· Create Tasks
· Recurring Tasks
· Assign Tasks
· Task Requests
· Task ManagementNotes
· Calendaring Tasks
Section F: Alternate Access
· Storage Options
· Archive
· Archive Options
· Web Access
· Web Access Options
· Offline Access
· Offline vs. Cached
· Enable Offline Mode |
PowerPoint Session 1
Section A: Introduction
· Using Presentations
· AutoContent Wizard
· PowerPoint Interface
· View Options
· Working with Slides
· Task Panes
· Workspace Views
· Photo Album
Section B: Creating Presentations
· Slide Building
· Create Slides
· Slide Layouts
· Save/Save Options
· File Options
Section C: Editing Presentation
· Edit Text
· Editing Options
· Find & Replace
· Bullet Levels
· Slide Control
Section D: Formatting Text
· Formatting Basics
· Font Options
· Replace Font
· Bullets
· Bulleted Lists
· Font Variations
Section E: Editing Tools
· Indents
· Tabs
· Text Boxes
· AutoCorrect
· Spelling Corrections
· Style Options
· Spell Check
· Style Check
Section F: Working in Outlines
· Outline View
· Outline Manipulation
· Adding Content
· Working with Word
· Importing |
PowerPoint Session 2
Section A: Drawing Options
· Lines
· Drawing Tools
· Colors
· Fill Effects
· Order
· Manipulating
· AutoShapes/3-D
Section B: Objects
· Insert Clip Art
· Edit Clip Art
· Word Art
Section C: Slide Design
· Backgrounds
· Color Schemes
· Design Templates
Section D: Images
· Insert Pictures
· Picture Controls
· Working with Pictures
Section E: Sound & Video
· Animation
· Sound
· Using CD Audio
Section F: Tables & Graphics
· Inserting Tables
· Add Text in Tables
· Importing Tables
· Table Sources
· Inserting Graphics
· Adding Excel Graphics
· Format Options
Section G: Diagrams
· Diagram Options
· Using Org Chart
· Formatting |
PowerPoint Session 3
Section A: Select Queries
· Creating in Design View
· Sorting
· Adding Additional Tables
· Changing Relationship Type
· The Show Box
Section B: Filtering with Criteria
· Exact Entries
· Comparison Operators
· Filter Range
· Null/Not Null
· Using "And" Statements
· Either "Or" Statements
· Unique Values
Section C: Calculations
· Formulas
· Group By
· Concatenation
Section D: Intro to Forms
· Creating Auto Forms
· Form Components
· Working with Controls
· Aligning Controls
· Removing Controls
· Adding Controls
· Using the Forms Wizard
Section E: Working in Forms
· Formatting Forms
· Control Properties
· Navigating a Form
Section F: Data Access Pages
· Save Form As
· Using the Page Wizard
· Apply Themes
· Preview in Browser
Section G: Working with Reports
· Creating Auto Reports
· Using the Reports Wizard
· Report Controls & Sections
· Modifying Controls
· Changing Sorting & Grouping
· Controlling Page Breaks
· Report Output Options
· Exporting to Word
Section H: Maintaining Database
· Using Compact & Repair
· Backing up Data
· Convert Database |
Word Session 1
Section A: Introduction
· Versions
· Hardware Requirements
· Launch Word
· Word Environment
Section B: Word Basics
· Click & Type
· Aligning Text
· Word Wrap
· Cut, Copy & Paste Concepts
· Copy & Paste
· Multiple Copy
· Pasting with Clipboard
Section C: Time Savers
· Keyboard Navigating
· End/Home Keys
· Select Options
· Selection Bar
· Selection Shortcuts
· Noncontiguous
· Move Through Documents
· Selection Review
Section D: Word 2003 Interface
· Task Panes
· Using Task Panes
· Type a Question Box
· Office Assistant
· Open Documents
· Search for Documents
· Reading Layout View
· Side-by-Side View
Section E: Creating New Documents
· Page Setup
· Date & AutoComplete
· Symbols
· AutoText
· AutoCorrect
· AutoCorrect Options
· AutoFormat
Section F: Proofing Documents
· Spelling Checker
· Spelling & Grammar
· Grammar Options
· Find & Replace
· Clipboard Replace
· Go To
· Word Usage Tools |
Word Session 2
Section A: Basic Formatting
· Text Formatting
· Character Formatting
· Formatting Options
· Font Formatting
· Shortcuts
· Paragraph Formatting
· Paragraph Spacing
· Line & Page Breaks
Section B: Advanced Formatting
· Using Rulers
· Borders & Shading
· Applying Columns
· Formatting Columns
· Bulleted Lists
· Tabs
· Tables
Section C: Document Sections
· Insert Section Break
· View Section Break
· Header/Footer Options
· Create Header
· Page Border
Section D: Graphics
· Text Boxes
· Clip Art
· Picture Options
· Insert Picture
· Word Art
· Excel Worksheet
· Linking Documents
Section E: Charts & Diagrams
· Graph Charts
· Diagrams
· Modify Diagrams
· Organization Charts
· Modify Charts
Section F: Save Documents
· Document Properties
· Preview Document
· Save Option
· Change File Type
· Web Version
· View/Preview |
Word Session 3
Section A: Printing
· Print Preview
· Print Dialog Box
· Zoom Options
· Printing Options
· Envelopes/Labels
· Envelope Formatting
· Envelope Printing
· Labels
Section B: Templates
· New Document
· Online Template
· Save Templates
· Template Location
· Attaching Templates
· Built-in Templates
Section C: Collaboration
· Track Changes
· Send Documents
· Review/Edit
· Add Comments
· Compare/Merge
· Show Change Options
· Accept/Decline
· Reviewing Pane
Section D: Menus & Toolbars
· Toolbar Control
· Customizing Options
· Custom Toolbar
· Customize Menu
· Customize Order
Section E: Basic Styles
· Current Styles
· Style & Formatting
· Apply Styles
· View Styles
Section F: Advanced Styles
· Customized Styles
· Modify Paragraph Style
· Styles with Borders
· Create New Style
· Character Style
· Apply Style
· Bullet/List Styles
· Apply Bullet Style |
Word Session 4
Section A: Draw Table
· Insert Table Button
· Format Cells
· Add Data
· Navigate
· Insert Table Menu
· Calculations
Section B: Formatting Tables
· Select/Delete
· Format Options
· Header Rows
· Resize Cells
· Move Tables
· Sort Data
· Table Styles
Section C: Document Effects
· Watermarks
· Picture Watermarks
· Themes
Section D: Navigate within Documents
· Go To
· Browse By
· Split Windows
· Multiple Windows
· Bookmarks
· Using Bookmarks
· Hyperlinks
· Hyperlink Navigation
Section E: Creating References
· Footnotes/Endnotes
· Footnote Content
· Footnote Shortcut
· Format Footnotes
· Move/Delete Footnotes
· Captions
· Table of Figures
Section F: Index/Table of Contents
· Indexing
· Cross References
· Subentry
· Create Index
· Table of Contents
· Edit Table of Contents
Section G: Master Documents
· Using Master Documents
· Insert Subdocuments
· Edit Subdocuments
· Work with Subdocuments |
Word Session 5
Section A: Outlines/Summaries
· Outline View
· Working with Outlines
· Promote/Demote
· Adding Text
· Expand/Collapse
· AutoSummarize
Section B: Forms
· Form Overview
· Text Form Field
· Drop-Down Form Field
· Calculations
· Form Control
· Help Text
· Protect Document
· Validate Form
Section C: Mail Merge
· Merge Components
· Mail Merge Template
· Mail Merge Wizard
· Lists
· Write Email
· Address Block
· Complete Merge
· Labels
Section D: XML
· What is XML?
· Schema
· Transform
· XML in Word
· Saving in XML
Section E: Macros
· Introduction
· Creating Macros
· Recording Macros
· Signature Block
· Organizer Tool
Section F: Security
· Document Protection
· Security Tab
· Document Properties
· Digital Signatures
· Apply Signatures
Section G: Application Maintenance
· Application Recovery
· Save My Settings
· Updates
· Detect & Repair |
To
order, simply call us on
01884 821870,or fax orders to
01884 829168. 
