Access Tables
- Creating a Table in Design View
- Adding Records
- Modifying the Table Design
- Deleting, Adding, and Copying records
Access Select Query
- Selection Criteria
- Comparison Operators
- Between & And
- Null
- Wildcards
- Ands and Ors
Access Action Queries
- Update Query
- Delete Query
- MakeTable Query
- Append Query
- Crosstab Query
Access Forms
- Creating Forms from Scratch
- Alignment
- Formatting
- Basic Calculations
- Combo Boxes
- Form Wizard
Access Reports
- Report Wizard
- Creating from Scratch
- Formatting
- Sorting
- Editing
- Basic Calculations
Excel Basic formulas
- Creating Formulas
- Working with Functions: Sum, Avg, Max, Min
- AutoSum
- Using the Fill Tool
- Formatting Numbers
Excel Advanced Functions
- IF: Query and Perform an Action
- SUMIF: Query Ranges and Sum Values
- Using Named Ranges
- VLOOKUP: Query Columns Based on Value
- HLOOKUP: Query Rows Based on Value
- Nested Functions
- Round
Excel Basic Charting
- Creating a Chart Sheet
- Creating an Embedded Chart
- Modifying Source Data
- Chart Formatting Options
- Creating Combination Charts
- Using Graphic Elements
Excel Organizing Data for Printing
- Print Preview
- Page Orientation
- Controlling Margins
- Creating Headers and Footers
- Displaying the Gridlines
- Setting Print Areas
Excel Pivot tables
- Creating PivotTables
- Rearranging PivotTables
- Formatting PivotTables
- Working with PivotCharts
Effective Researching on the Internet
- Search Engines, Directories and Spiders
- Searching Techniques
- Using Favorites and History
- Searching on Multiple Options
- Best Tips & Tricks
- People Finder
Outlook Calendars
- Using the Calendar
- Creating Appointments
- Creating Meetings
- Tracking Feedback
- Rescheduling Meetings
- Recurring Appointments/Meetings
Mail Merges in Outlook
- Importing Contacts from Excel
- Creating a Temporary Contact Folder
- Copying Contacts Into a Folder
- Creating a Mail Merge Using Contacts
Making Outlook Work for You
- Creating folders
- Personal Folders
- Public folders
- Project folders
- Using views
- Find
- Advanced Find
- Using the Organize Page
- Establish Rules
|
|
PowerPoint
Slide Show
- Working with Text and Bulleted slides
- Using the Drawing Toolbar
- Inserting Clip Art
- Running a Slide Show
PowerPoint Organizational Charts and
Graphs
- Creating an Organization Chart
- Editing an Organization Chart
- Creating a Graph
- Editing a Graph
PowerPoint Preparing to Present
- Slide Masters
- Speaker Notes
- Page Numbering
- Headers/Footers
- Printing Options
- Pack & Go
Windows Basics
- Screen Anatomy
- Window Management
- WordPad
- Saving Files
- Shortcuts
Windows Explorer
- Working with Windows Explorer
- Creating Files and Folders
- Moving, Copying, and
- Renaming Files and Folders
Creating and Deleting Shortcuts
- Working with the CD Drive
- Working with the Recycle Bin
Word Catch a Break
- Inserting Section Breaks
- Text Columns
- Column Breaks
- Removing Breaks
- Changing Page Formatting in a Section
- Formatting Page Numbers
- Troubleshooting Tips
Word Creating Professional Documents
- Creating Sections
- Multiple Columns
- Working with Text in Columns
- Creating Different Headers and Footers
- Working with Page Numbering
Word Mail Merge
- Creating a Mail Merge
- Selecting in a Mail Merge
- Merging with Labels
Word Preparing to Print
- Using Styles
- Controlling Page Layout
- Headers and Footers
- Checking Spelling andGrammar
- Using the Thesaurus
- Advanced Printing Options
- Printing Labels and Envelopes
Word Tables and Templates
- Creating Tables
- Modifying Tables
- Creating Styles
- Creating Templates
Word Working with Large Documents
- Table of Contents
- Footnotes and Endnotes
- Bookmarks
- Cross-references
- Indices
Word Working with Tables
- Inserting Tables
- Understanding Table Properties
- Inserting and Deleting
- Columns and Rows
- Splitting and Merging Columns and Rows
- Table Formatting Basics
- Applying Borders and Shading
- Using Table AutoFormat
- Converting From Text to Table
- Converting From Table to Text
- Using Formulas
Keyboarding Techniques
- Guidelines
- Workspace Set-up
- Home row, Top Row, Bottom Row
- Numbers, Symbols and
- Punctuation
Numeric Keypad
- Timed Typing Tests
Understanding Personal Computers
- Desktop Computer
- Laptop Computer
- Keyboard
- Monitor
- Printer
- Peripherals
- Software
|
