Getting Acquainted with Access
The Access Interface
Overview of a Database
Working with Database Objects
Opening and Closing Databases
Database Objects
Creating Relational Database Tables
Creating New Databases
Flow Overview of a Database
The "Flat-File" Model of Data Storage
The Relational Model of Data Storage
Tips for Creating a Relational Database
Creating Relational Database Tables
Assigning a Primary Key to a Table
Using Tables
Using Datasheet View
Navigating in Datasheet View
Adding Records in Database View
Editing and Deleting Records in Datasheet View
Inserting New Fields
Renaming Fields
Deleting Fields
Field Properties
Setting Field Properties
The 'Field Size' Property
The 'Format' Property for Date/Time Fields
The 'Format' Property for Logical Fields
Setting Default Values for Fields
Setting Input Masks
Setting Up Validation Rules and Responses
Requiring Field Input
Allowing Zero Length Entries
Joining Tables
The Relationships Window
Enforcing Referential Integrity
Creating Lookup Fields
Indexing Tables
Indexes
Creating Indexes
Deleting Indexes
Queries
Using the Simple Query Wizard
Designing Queries
Joining Tables in a Query
Adding Criteria to the QBE Grid
Running A Query
How is Using the QBE Grid Writing SQL Code?
Sorting Query Results
Hiding Fields in a Query
Using Comparison Operators
Using 'AND' and 'OR' Conditions
Advanced Queries
Using the 'BETWEEN...AND' Condition
Using Wildcard Characters in Criteria
Creating a Calculated Field
Creating 'Top Value' Queries
Function Queries
Parameter Queries
Advanced Query Types
Make-Table Queries
Update Queries
Append Queries
Delete Queries
Crosstab Queries
The 'Find Duplicates' Query
The 'Find Unmatched' Query
Creating Forms
Forms Overview
The Form Wizard
Creating Forms
Using Forms
Form and Report Layout View
Form and Report Design View
Viewing the Ruler and Grid
The "Snap to Grid" Feature
Creating a Form in Design View
Form and Report Controls
Selecting Controls
Deleting Controls
Moving and Resizing Controls
Sizing Controls 'To Fit'
'Nudging' Controls
Aligning, Spacing and Sizing Controls
Formatting Controls
Viewing Control Properties
Using Controls
The Controls Group
Adding Label Controls
Adding Logos and Image Controls
Adding Line and Rectangle Controls
Adding Combo Box Controls
Adding List Box Controls
Setting Tab Order
Subforms
Creating Subforms
Using the Subform/Subreport Control
Reports
Using the Report Wizards
Using Basic Reports
Creating a Report in Design View
Sorting and Grouping Data in Reports
Creating Calculated Fields
Subreports
Creating Subreports
Charting Data
Using Charts
Macros
Creating a Standalone Macro
Macro Actions
Using Program Flow with Macros
Creating Autoexec Macros
Creating Data Macros
Switchboard and Navigation Forms
Creating a Switchboard Form
Creating a Navigation Form
Controling Startup Behavior
Advanced Features
Getting External Data
Exporting Data
Setting a Database Password
Using Help
Instruction Manuals
Introductory Access Manual
Intermediate Access Manual
Advanced Access Manual
Getting Acquainted with Excel
About Excel
The Excel Environment
The Title Bar
The Ribbon
The "File" Tab and Backstage View
Scroll Bars
The Quick Access Toolbar
The Formula Bar
The Workbook Window
The Status Bar
The Workbook View Buttons
The Zoom Slider
The Mini Toolbar
Keyboard Shortcuts
Creating Basic Workbooks
Creating New Workbooks
Saving Workbooks
Closing Workbooks
Opening Workbooks
Selecting Cells
Entering Text Into Cells
Entering Numbers Into Cells
AutoComplete
Pick From Drop-Down List
Using the "Window" Command Group
Switching to Full Screen View
Working with Excel File Formats
Using Ranges
Selecting Ranges
Ranged Data Entry
Using AutoFill
Creating Formulas
Ranged Formula Syntax
Simple Formual Syntax
Writing Formulas
Using AutoSum
Inserting Functions
Editing a Range
Formula and AutoCorrect
AutoCalculate
Copying and Pasting Formulas
Absolute References and Relative References
Cutting, Copying and Pasting
AutoFilling Cells
The Undo Button
The Redo Button
Columns and Rows
Selecting Columns and Rows
Adjusting Column Width and Row Height
Hiding/Unhiding Columns and Rows
Inserting and Deleting Columns and Rows
Formatting Worksheets
Formatting Cells
The Format Cells Dialog Box
Clearing All Formatting from Cells
Copying All Formatting from Cells to Another Area
Worksheet Tools
Moving Between Worksheets
Selecting Multiple Worksheets
Inserting and Deleting Worksheets
Renaming Worksheets
Coloring Worksheet Tabs
Copying or Moving Worksheets
Setting Worksheet Layout
Using Page Break Preview
Using the Page Layout View
The Page Setup Dialog Box
Printing Worksheets
Previewing and Printing Worksheets - 2010
Helping Yourself
Using Excel Help
3D Formulas
Creating 3D Formulas
3D Formula Syntax
Creating 3D Range Preferences
Named Ranges
Naming Ranges
Creating Names from Headings
Moving to a Named Range
Using Named Ranges in Formulas
Naming 3D Ranges
Managing Named Ranges
Conditional Formatting and Cell Styles
Conditional Formatting
Finding Cells with Conditional Formatting
Clearing Conditional Formatting
Using Table and Cell Styles
Paste Special
Using Paste Special
Pasting Linked Formulas
Sharing Workbooks
Sharing Workbooks
Highlighting Changes
Reviewing Changes
Using Comments
Compare and Merge Workbooks
Auditing Worksheets
Auditing Worksheets
Tracing Precedent and Dependent Cells
Tracing Errors
Error Checking
Using the Watch Window
Cell Validation
Outlining Worksheets
Using Outlines
Applying and Removing Outlines
Consolidating Worksheets
Consolidating Data
Creating Worksheet Charts
Creating Charts
Selecting Charts and Chart Elements
Moving and Resizing Charts
Changing the Chart Type
Changing the Data Range
Switching Column and Row Data
Choosing a Chart Layout
Choosing a Chart Style
Printing Charts
Deleting Charts
Editing and Formatting Charts
Formatting Chart Objects
Inserting Objects into a Chart
Changing Chart Labels
Changing Axes Display
Changing the Chart Background
Applying Chart Analysis Lines
Naming Charts
Applying Shape Styles to Chart Elements
Applying WordArt Styles to Chart Elements
Saving Custom Chart Templates
PivotTables
Creating PivotTables and PivotCharts
Manipulating a PivotTable
Changing Calculated Value Fields
Applying PivotTable Styles
Creating a PivotChart
Setting PivotTable Options
Sorting and Filtering PivotTable Data
Tables
Creating a Table
Adding and Editing Records
Inserting Records and Fields
Deleting Records and Fields
Sorting Data
Sorting Data
Custom Sort Orders
Filtering Data
Using AutoFilters
Using the Top 10 AutoFilter
Applying a Custom AutoFilter
Creating Advanced Filters
Applying Multiple Criteria
Using Complex Criteria
Copying Filtered Results to a New Location
Using Database Functions
Using What-If Analysis
Using Data Tables
Using Scenario Manager
Using Goal Seek
Table-Related Functions
The Hlookup and Vlookup Functions
Using the IF, AND, and OR Functions
Security Features
Unlocking Cells
Worksheet Protection
Workbook Protection
Password Protecting Excel Files
Making Macros
Recording Macros
Running and Deleting Recorded Macros
The Personal Macro Workbook
Instruction Manuals
Introductory Excel Manual
Intermediate Excel Manual
Advanced Excel Manual
Getting Acquainted with OneNote
The OneNote Environment
The Title Bar
The Ribbon
The "File" Tab and Backstage View
The Quick Access Toolbar
The Scroll Bars
The Mini Toolbar
The Default "Personal" Notebook
Getting Started
Opening, Saving and Closing Notebooks
Creating New Notebooks
Creating, Moving and Deleting Sections and Pages
Creating, Moving and Deleting Subpages
Notes
Creating a Basic Note
Unfiled Notes
Copying and Pasting Content
Screen Clippings
Adding Pictures
Adding Audio and Video Files
Recording Audio and Video Files
Adding Other Types of Files
Adding Mathematical Equations
Quick Filing - Sending Information to OneNote
Formatting Notes
Basic Text Formatting
Bullets and Numbering
Checking Spelling
Setting Default Proofing Options
Working with Microsoft Outlook
Inserting Outlook Meetings
Sending Notebook Pages via Microsoft Outlook
Working with Microsoft Outlook Tasks
Tables
Creating a Table
Working with Columns and Rows
Formatting Tables and Table Data
Moving Tables and Table Data
Writing Tools
Pen Mode
Formatting Written Notes and Drawings
Converting Handwriting to Type
Viewing and Organizing Information
Organizing the OneNote Interface
Creating New Windows
Searching Content in a Notebook
Wiki Linking
Tagging Notes
Working with Sections
Section Groups
Stationery and Templates
Applying Templates and Stationery
Custom Templates
Choosing a Default Template
Formatting Pages
Defining Paper Size and Margins
Formatting Page Backgrounds
Adding a Background Graphic
Printing
Previewing and Printing
Sharing Notebooks and Collaborating
Saving Notebooks to Share
Creating a Shared Notebook
Inviting Others to Share
Synching Notebooks
Sending Pages in Various Formats
Sharing Notebooks with SkyDrive
Author Indicators
Finding Newly Added Content with Highlighting
Page Versions
Researching with OneNote
Linked Notes
The Research Pane
Translating Text with the Mini Translator
Changing OneNote Options
Changing Display Options
Changing Other Options
Helping Yourself
Using OneNote Help
Instruction Manual
Introductory OneNote Manual
Getting Acquainted with Outlook
The Outlook Environment
The Title Bar
The Ribbon
The Quick Access Toolbar
The Navigation Pane, Reading Pane and To-Do Bar
Making Contacts
The Contacts Folder
Customizing the Contacts Folder View
Creating Contacts
Basic Contact Management
Printing Contacts
Creating Distribution Lists
Categorizing Contacts
Searching for Contacts
Calling Contacts
Mapping a Contact's Address
E-Mail
Using the Inbox
Changing the Inbox View
Message Flags
Searching for Messages
Creating, Addressing, and Sending Messages
Checking Message Spelling
Setting Message Options
Formatting Messages
Using Signatures
Replying to Messages
Forwarding Messages
Sending Attachments
Opening Attachments
The Sent Items Folder
The Sent Items Folder
Resending Messages
Recalling Messages
The Outbox Folder
Using the Outbox
Using the Calendar
The Calendar Window
Switching the Calendar View
Navigating the Calendar
Appointments, Meetings and Events
Manipulating Calendar Objects
Setting an Appointment
Scheduling a Meeting
Checking Meeting Attendance Status
Responding to Meeting Requests
Scheduling an Event
Setting Recurrence
Printing the Calendar
Tasks
Using Tasks
Printing the Tasks
Creating a Task
Setting Task Recurrence
Creating a Task Request
Responding To Task Requests
Sending Status Reports
Deleting Tasks
Deleted Items
The Deleted Items Folder
Permanently Deleting Items
Recovering Deleted Items
The Journal Folder
The Journal Folder
Switching the Journal View
Recording Journal Items Automatically
Recording Journal Items Manually
Opening a Journal Entry
Opening the Journal Entry Document
Deleting Journal Entries
Public Folders
Creating Public Folders
Setting Permissions
Administering Public Folders
Folder Rules
Copying Public Folders
Personal and Private Folders
Creating a Personal Folder
Setting AutoArchiving for Folders
Creating Private Folders
Notes
Creating and Using Notes
Advanced Mailbox Options
Creating Mailbox Rules
Creating Custom Mailbox Views
Handling Junk Mail
Color Categorizing
Advanced Find
Outlook Options
Using Shortcuts
Adding Additional Profiles
Adding Additional Services
Outlook Options
Using Outlook Help
Delegates
Creating a Delegate
Acting as a Delegate
Deleting Delegates
Instruction Manuals
Introductory Outlook Manual
Advanced Outlook Manual
Getting Acquainted with PowerPoint
The PowerPoint Environment
The Title Bar
The Ribbon
The “File” Tab and Backstage View
The Quick Access Toolbar
The Scroll Bars
The Presentation View Buttons
The Zoom Slider
The Status Bar
The Mini Toolbar
Keyboard Shortcuts
Creating Basic Presentations
Opening Presentations
Closing Presentations
Creating New Presentations
Saving Presentations
Inserting New Slides
Applying Slide Layouts
Using the “Save and Send” Features
Working with PowerPoint File Formats
Using Presentation Views
Normal View
Slide Sorter View
Notes Page View
Slide Show View
Reading View
Using Text
Adding Text to Slides
Basic Object Manipulation
Font Formatting
Paragraph Formatting
Applying Custom Bullets and Numbering
Using Tabs
Setting Text Box Options
Checking Spelling
Using Clip Art
Inserting Clip Art and Pictures
Basic Graphic Manipulation
Using Picture Tools
The Format Picture Dialog Box
Using SmartArt
Inserting and Manipulating SmartArt
Formatting SmartArt
Using Slide Show View
Running a Slide Show
Using Custom Shows
Printing Your Presentation
Using Page Setup
Setting the Slide Header and Footer
Previewing and Printing Presentations
Helping Yourself
Using PowerPoint Help
Applying Animation
Adding Slide Transition Animation
Adding Object Animation
Drawing Objects
Inserting Shapes
Formatting Shapes
Inserting WordArt
Inserting Video and Sound
Inserting Videos
Inserting Audio
Animating Multimedia Playback
Recording a Sound
Using Themes
Applying Themes
Customizing Themes
Formatting the Slide Background
Using Presentation Masters
Using Slide Masters and Slide Layouts
Using the Notes Master
Using the Handout Master
Saving a Presentation Template
Setting Up the Presentation
Setting Up the Slide Show
Recording Narration
Rehearsing Timings
Applying Actions
Inserting Actions
Inserting Hyperlinks
Inserting Charts, Tables, and Objects
Inserting Charts
Inserting Tables
Inserting Objects
Setting PowerPoint Options
Setting PowerPoint Options
Instruction Manuals
Introductory PowerPoint Manual
Advanced PowerPoint Manual
Getting Acquainted With Publisher
The Publisher Environment
The Title Bar
The Ribbon
The "File" Tab and Backstage View
The Quick Access Toolbar
The Scroll Bars
The Page Layout View Buttons
The Zoom Slider and Zoom Button Group
The Status Bar
The Mini Toolbar
Keyboard Shortcuts
Creating Basic Publications
Creating New Publications
Using Business Information
Saving Publications
Closing Publications
Opening Publications
Inserting New Pages
Deleting Pages
Moving Pages
Basic Skills
Inserting Text Boxes
Inserting Shapes
Adding Text to Shapes
Inserting Clip Art and Pictures
Moving, Resizing and Rotating Objects
Deleting Objects
Using Find and Replace
Using AutoCorrect
Inserting WordArt
Formatting Objects
Formatting Text
Formatting Shapes
Formatting Clip Art and Pictures
Using Building Blocks
Using Building Blocks
Master Pages
Using Master Pages
Customizing Schemes
Creating a Color Scheme
Creating a Custom Font Scheme
Customizing Page Backgrounds
Using Tables
Creating and Deleting Tables
Selecting Table Elements
Inserting and Deleting Columns and Rows
Merging and Splitting Cells
Modifying Text in Table Cells
Formatting Tables
Page Setup and Layouts
Using Page Setup
Using Layout Guides
Using the Rulers
Mailings
Mail Merge
The Step By Step Mail Merge Wizard
Creating a Data Source
Selecting Recipients
Inserting and Deleting Merge Fields
Previewing a Merge
Detaching the Data Source
Finishing a Mail Merge
Merging a Catalog
Printing
Previewing and Printing
Commercial Printing
Save and Send
Helping Yourself
Using Publisher Help
Instruction Manual
Introductory Publisher Manual
Introduction to Windows
About Windows
The Start Screen in Windows 8
Customizing the Start Screen
Using the Charm Bar in Windows 8
The Windows Desktop
The Mouse
Touch Gestures in Windows 8
App Snapping in Windows 8
Using a Microsoft User Account
Starting a Program in Windows 7 & Vista
Resizing a Desktop Window
Scrolling a Window
Shutting Down Windows
Windows Explorer
Windows Explorer in Windows 8
Navigating Folders
Changing Folder Views
Sorting Folder Contents
Selecting Files
Opening a File
Opening a Recently Accessed File or Folder
Creating a New Folder
Renaming Files and Folders
Cutting, Copying and Pasting Files and Folders
Burning a CD or DVD
Deleting Files
Managing Libraries in Windows 8
Managing the Computer and Disks in Windows 8
Windows 8 Settings
Accessing Settings
Personalizing Windows
Managing Users
Notifications
Managing Search Settings
Managing Sharing Settings
General Settings
Privacy Settings
Managing Devices
Wireless Options
Ease of Access Settings
Sync Settings
HomeGroup Settings
Windows Updates
File History
Control Panel Settings
The Control Panel
Personalizing the Desktop
Changing Screen Resolution
Backup and Restore in Windows 7
System Restore
Creating Users in Windows 7 & Vista
Audio Adjustment
Adding Devices and Printers
Installing and Uninstalling New Software
Windows Management
Searching for a File or Folder in Windows 7 and Vista
The Recycle Bin
Creating Desktop Shortcuts
Pinning Items to the Taskbar or the Quick Launch Toolbar
Windows Help
Moving and Resizing the Windows Taskbar
Setting the Date and Time Display
Windows Updates
Using Apps in Windows 8
Downloading Apps from the Windows Store
Managing App Files
Using SkyDrive
Creating Documents
Starting WordPad
Editing Text
Formatting Text
Saving a Document
Opening a Document
Printing a Document
Closing a Document
Drawing Pictures
Starting Paint
Drawing Shapes and Lines
Adding Text
Erasing Parts of a Picture
Saving a Picture
Opening a Picture
Using the Internet
About the Internet
Using the Desktop Internet Explorer 10
Using the Internet Explorer 10 App
Connecting to the Internet
Windows Defender in Windows 8
Printing Information
Selecting a Printer
General Printing Options
Managing Print Jobs
Instruction Manual
Introductory Windows Manual
Getting Acquainted with Word
About Word
The Word Environment
The Title Bar
The Ribbon
The “File” Tab and Backstage View
The Quick Access Toolbar
The Ruler
The Scroll Bars
The Document View Buttons
The Zoom Slider
The Status Bar
The Mini Toolbar
Keyboard Shortcuts
Creating Basic Documents
Opening Documents
Closing Documents
Creating New Documents
Saving Documents
Entering Text
Moving through Text
Selecting Text
Non-Printing Characters
Managing Multiple Documents
Working with Word File Formats
Basic Editing Skills
Deleting Text
Cutting, Copying, and Pasting
Undoing and Redoing Actions
Finding and Replacing Text
Basic Proofing Tools
The Spelling and Grammar Tool
Setting Default Proofing Options
Font Formatting
Formatting Fonts
The Font Dialog Box
The Format Painter
Formatting Paragraphs
Aligning Paragraphs
Indenting Paragraphs
Line Spacing and Paragraph Spacing
Setting Page Layout
Setting Page and Section Breaks
Using Headers and Footers
Using Page Setup
Using Templates
Using Templates
Printing Documents
Previewing and Printing Documents
Helping Yourself
Using Word Help
Working with Tabs
Using Tab Stops
Using the Tabs Dialog Box
Using Clip Art
Using Clip Art
Inserting Your Own Pictures
Using Picture Tools
The Format Picture Dialog Box
Drawing Objects
Inserting Shapes
Inserting WordArt
Inserting Text Boxes
Formatting Shapes
The Format Shape Dialog Box
Using Building Blocks
Using Building Blocks
Bullets and Numbering
Applying Bullets and Numbering
Formatting Bullets and Numbering
Tables
Using Tables
Creating Tables
Selecting Table Objects
Inserting and Deleting Columns and Rows
Deleting Cells and Tables
Merging and Splitting Cells
Adjusting Cell Size
Aligning Text in Table Cells
Converting a Table into Text
Sorting Tables
Formatting Tables
Table Formulas
Inserting Table Formulas
Recalculating Word Formulas
Viewing Formulas Vs. Formula Results
Mailings
Mail Merge
The Step by Step Mail Merge Wizard
Creating a Data Source
Selecting Recipients
Inserting and Deleting Merge Fields
Error Checking
Detaching the Data Source
Finishing a Mail Merge
Creating a Table of Contents
Creating a Table of Contents
Customizing a Table of Contents
Updating a Table of Contents
Creating an Index
Creating an Index
Customizing an Index
Updating an Index
Creating Forms
Displaying the Developer Tab
Creating a Form
Inserting Controls
Adding Instructional Text
Protecting a Form
Making Macros
Recording Macros
Running and Deleting Recorded Macros
Assigning Macros
Word Options
Setting Word Options
Instruction Manuals
Introductory Word Manual
Intermediate Word Manual
Advanced Word Manual