Course Outlines
Access
Microsoft Access is a powerful program to create and manage
your databases. It has many built in features to assist you in
constructing and viewing your information. Access is much more
involved and is a more genuine database application than other
programs.
Access Beginning
• Database Basics
• Database Terminology
• Opening and using Existing Databases
• Objects
• Views
• Create a Database
• Create/Design tables from scratch and with wizard
• Work with fields
• Input Masks
• Sort/Filter
• Query a table - SQL
• Create Reports
• Create Forms
Access Intermediate
• Import from other Databases, Excel, Text
• Primary Keys
• Converting Field Types
• Custom Formats
• Input Mask
• Lookup Fields
• Captions
• Default Values
• Validity Rules
• Querying Tables
• Calculated Fields
• Summary Operators
• Querying Multiple Tables
• Action Queries
• Relationships
• Referential Integrity
• Create and Customize Reports
• Create and Customize Forms
• Printing Options
• File Properties
Access Advanced
• Indexing
• Parameter Queries
• CrossTab Queries
• Customizing Forms & Reports
• Combo Boxes
• List Boxes
• Option Group
• Command Buttons
• Backup & Restore
• Securing a Database
• Macros
• Data Access Page
• Add-Ins
• Introduction to VBA (Visual Basic Application)
Excel
Excel is a "spreadsheet application" which means that it is
designed to help the user manipulate numerical data (such as
budgets, research data analysis, etc.). Excel is designed to quickly
and accurately perform complex and tedious calculations. Excel
can help automate the process of calculating your data as well as
lay it out in a more appealing and meaningful way.
Excel Beginning
• Navigate and Enter Excel Data
• Views
• AutoComplete
• Pick From List
• Undo/Delete Cells, Rows, Columns
• Adjusting Columns and Rows
• Insert and Delete Cells Rows and Columns
• Formatting
• Formulas
• Functions (Sum, Min, Max, Count)
• Absolute Cell Referencing
• Cut/Copy/Paste & Drag and Drop
• Aligning Cell Data
• Charts
• Templates
Excel Intermediate
• Find & Replace Data
• Named Ranges
• Dates (Calculating)
• Functions: IF, PMT, FV,
• Sorting
• AutoFilter
• Macros
• Arrays
• 3-D References
• Protection
• Freeze/Unfreeze Rows & Columns
• Customizing Charts
• Hyperlinks
• Tracking Changes
• Conditional Formatting
Excel Advanced
• Group & Outline
• Pivot Tables
• Advanced Charts
• Combination
• Secondary Axis
• List
• Graphics & Clipart
• Goal Seek
• Scenarios
• Comments
• Sharing
• Track Changes
• Compare & Merge
• Importing & Exporting
• Custom Views (Workspace)
• Web Pages
Outlook
Outlook 2003 is a Personal Information Manager that is made up
primarily of Mail/Email, Calendar, and Contacts. You can also,
keep a task lists and create your own notes.
• Use outlook to organize your life
• Time Management Hints with Outlook
• Navigating Within Outlook
• Working with Mail
• Create/Manage Mail
• Formatting
• Numbered List
• Signature Block
• Flagging Messages
• Message Options
• Recall Messages
• Sorting & Finding
• Mark as Read or Unread
• Attachments
• Stationary
• Save and Organize Messages
• Create Rules
• Address Book
• Distribution Lists
• Calendar
• Task List
• Notes
• Contacts
PowerPoint
PowerPoint is the number 1 program used worldwide for
presentations. Anyone can create stunning presentations that
look like they were designed by a professional. PowerPoint
presentations can be made into photo albums, complete with
music or narrations, to distribute on CDs or DVDs. With just a few
simple clicks you can add an organizational chart of your
company's structure. Make your presentation into a web page for
emailing purposes or as a promotion displayed on your company's
website.
• Running a Slide Show
• Views
• Add/Delete/Rearrange Slides
• Objects
• Clipart
• Working with Text
• AutoContent Wizard
• Start a new presentation
• Templates
• Headers & Footers
• Bullets
• Ruler
• Drawing Options
• Tables
• WordArt
• Charts
• Import from Excel and Word
• Transition Effects
• Adding Animation to text and objects
• Timing for Slide Shows
• Slide Master
• Custom Backgrounds
• Design Templates
• Hyperlinking
• Web Pages
• Packaging Your Presentation
• Shortcut Key
Word
Microsoft Word is one of the most commonly used word
processors, and can be considered a standard on both the
Macintosh and Windows platforms. In addition to the usual word
processing, Word can also be used to create and edit text
documents with its included desktop publishing features.
Word Beginning
• Creating a new document
• Saving and Printing a document
• spell checker
• Navigating within a document
• Insert vs. typeover mode
• Edit/Delete text
• Click and type
• formatting
• Page setup
• Reveal formatting
• Paragraph alignment
• Tabs
• Cut/Copy/Paste, Drag and Drop
• Thesaurus
• Bookmarks
• Printing envelopes
• Mailing Labels
• The Letter Wizard
• Templates
• Applying a Theme
Word Intermediate
• Keeping Text Together
• Page numbering
• Headers and Footers
• Insert Fields
• Find and Replace Data
• Cut/Copy/Paste
• Columns
• Borders
• Drop Caps
• Mail Merge
• Outlines/Number/Bullets
• Inserting Symbols
• Hyperlinks
• Templates
• Comments
• AutoText
• Macros
• File Management
• Tracking Changes
• Compare and Merge
• Protection
Word Advanced
• Tables
• Performing math
• Working with worksheets
• Linking files
• Graphics
• Clip art
• Autoshapes
• Wordart
• Diagrams
• Charts
• Watermarks
• Sorting
• Mailing labels
• Styles
• Footnotes/endnotes
• Cross referencing text
• Creating an index
• Creating a table of contents
• Master documents
• Web pages
• Tool bar
Windows XP
Windows XP is a Microsoft version of the Windows operating
system. Windows XP was released on October 25, 2001.
Presumably, the letters XP come from the word experience,
indicating how Windows XP has evolved from previous versions of
Windows. The basics of running a computer all start here with the
Operating System.
• Accessing Help
• Working with Windows
• Running Programs
• Switch between open apps
• Access menus – keyboard, mouse
• Cut, Copy & Paste
• Dragging & Dropping
• My Computer
• Control Panel
• Manage/Create Files & Folders
• Customizing the Desktop
• Customizing the Taskbar
• System Maintenance
• USB Drives
• Copy CD
• Work with Pictures
• Applications
Office 2007 Demonstration (one hour)
The Microsoft Office 2007 suite of applications represents a
significant change in the way users interact with the software.
The redesigned user interface represents the most significant
change since the Office 95 version was introduced more than a
decade ago. This one hour demonstration will provide a summary
of the most common new features in the user interface that are
common to most of the applications in the suite (Word, Excel,
PowerPoint, Access, and Outlook).
• Office Button
• Ribbon
• Tabs & Contextual Tabs
• Quick Access Toolbar
• Mini Toolbar
• Super Tooltips
• Dialog Box Launchers
• Zoom Slider
• Galleries
• Live Preview
• SmartArt
• File Extensions
Office 2010 Demonstration (one hour)
Access
Microsoft Access is a powerful program to create and manage
your databases. It has many built in features to assist you in
constructing and viewing your information. Access is much more
involved and is a more genuine database application than other
programs.
Access Beginning
• Database Basics
• Database Terminology
• Opening and using Existing Databases
• Objects
• Views
• Create a Database
• Create/Design tables from scratch and with wizard
• Work with fields
• Input Masks
• Sort/Filter
• Query a table - SQL
• Create Reports
• Create Forms
Access Intermediate
• Import from other Databases, Excel, Text
• Primary Keys
• Converting Field Types
• Custom Formats
• Input Mask
• Lookup Fields
• Captions
• Default Values
• Validity Rules
• Querying Tables
• Calculated Fields
• Summary Operators
• Querying Multiple Tables
• Action Queries
• Relationships
• Referential Integrity
• Create and Customize Reports
• Create and Customize Forms
• Printing Options
• File Properties
Access Advanced
• Indexing
• Parameter Queries
• CrossTab Queries
• Customizing Forms & Reports
• Combo Boxes
• List Boxes
• Option Group
• Command Buttons
• Backup & Restore
• Securing a Database
• Macros
• Data Access Page
• Add-Ins
• Introduction to VBA (Visual Basic Application)
Excel
Excel is a "spreadsheet application" which means that it is
designed to help the user manipulate numerical data (such as
budgets, research data analysis, etc.). Excel is designed to quickly
and accurately perform complex and tedious calculations. Excel
can help automate the process of calculating your data as well as
lay it out in a more appealing and meaningful way.
Excel Beginning
• Navigate and Enter Excel Data
• Views
• AutoComplete
• Pick From List
• Undo/Delete Cells, Rows, Columns
• Adjusting Columns and Rows
• Insert and Delete Cells Rows and Columns
• Formatting
• Formulas
• Functions (Sum, Min, Max, Count)
• Absolute Cell Referencing
• Cut/Copy/Paste & Drag and Drop
• Aligning Cell Data
• Charts
• Templates
Excel Intermediate
• Find & Replace Data
• Named Ranges
• Dates (Calculating)
• Functions: IF, PMT, FV,
• Sorting
• AutoFilter
• Macros
• Arrays
• 3-D References
• Protection
• Freeze/Unfreeze Rows & Columns
• Customizing Charts
• Hyperlinks
• Tracking Changes
• Conditional Formatting
Excel Advanced
• Group & Outline
• Pivot Tables
• Advanced Charts
• Combination
• Secondary Axis
• List
• Graphics & Clipart
• Goal Seek
• Scenarios
• Comments
• Sharing
• Track Changes
• Compare & Merge
• Importing & Exporting
• Custom Views (Workspace)
• Web Pages
Outlook
Outlook 2003 is a Personal Information Manager that is made up
primarily of Mail/Email, Calendar, and Contacts. You can also,
keep a task lists and create your own notes.
• Use outlook to organize your life
• Time Management Hints with Outlook
• Navigating Within Outlook
• Working with Mail
• Create/Manage Mail
• Formatting
• Numbered List
• Signature Block
• Flagging Messages
• Message Options
• Recall Messages
• Sorting & Finding
• Mark as Read or Unread
• Attachments
• Stationary
• Save and Organize Messages
• Create Rules
• Address Book
• Distribution Lists
• Calendar
• Task List
• Notes
• Contacts
PowerPoint
PowerPoint is the number 1 program used worldwide for
presentations. Anyone can create stunning presentations that
look like they were designed by a professional. PowerPoint
presentations can be made into photo albums, complete with
music or narrations, to distribute on CDs or DVDs. With just a few
simple clicks you can add an organizational chart of your
company's structure. Make your presentation into a web page for
emailing purposes or as a promotion displayed on your company's
website.
• Running a Slide Show
• Views
• Add/Delete/Rearrange Slides
• Objects
• Clipart
• Working with Text
• AutoContent Wizard
• Start a new presentation
• Templates
• Headers & Footers
• Bullets
• Ruler
• Drawing Options
• Tables
• WordArt
• Charts
• Import from Excel and Word
• Transition Effects
• Adding Animation to text and objects
• Timing for Slide Shows
• Slide Master
• Custom Backgrounds
• Design Templates
• Hyperlinking
• Web Pages
• Packaging Your Presentation
• Shortcut Key
Word
Microsoft Word is one of the most commonly used word
processors, and can be considered a standard on both the
Macintosh and Windows platforms. In addition to the usual word
processing, Word can also be used to create and edit text
documents with its included desktop publishing features.
Word Beginning
• Creating a new document
• Saving and Printing a document
• spell checker
• Navigating within a document
• Insert vs. typeover mode
• Edit/Delete text
• Click and type
• formatting
• Page setup
• Reveal formatting
• Paragraph alignment
• Tabs
• Cut/Copy/Paste, Drag and Drop
• Thesaurus
• Bookmarks
• Printing envelopes
• Mailing Labels
• The Letter Wizard
• Templates
• Applying a Theme
Word Intermediate
• Keeping Text Together
• Page numbering
• Headers and Footers
• Insert Fields
• Find and Replace Data
• Cut/Copy/Paste
• Columns
• Borders
• Drop Caps
• Mail Merge
• Outlines/Number/Bullets
• Inserting Symbols
• Hyperlinks
• Templates
• Comments
• AutoText
• Macros
• File Management
• Tracking Changes
• Compare and Merge
• Protection
Word Advanced
• Tables
• Performing math
• Working with worksheets
• Linking files
• Graphics
• Clip art
• Autoshapes
• Wordart
• Diagrams
• Charts
• Watermarks
• Sorting
• Mailing labels
• Styles
• Footnotes/endnotes
• Cross referencing text
• Creating an index
• Creating a table of contents
• Master documents
• Web pages
• Tool bar
Windows XP
Windows XP is a Microsoft version of the Windows operating
system. Windows XP was released on October 25, 2001.
Presumably, the letters XP come from the word experience,
indicating how Windows XP has evolved from previous versions of
Windows. The basics of running a computer all start here with the
Operating System.
• Accessing Help
• Working with Windows
• Running Programs
• Switch between open apps
• Access menus – keyboard, mouse
• Cut, Copy & Paste
• Dragging & Dropping
• My Computer
• Control Panel
• Manage/Create Files & Folders
• Customizing the Desktop
• Customizing the Taskbar
• System Maintenance
• USB Drives
• Copy CD
• Work with Pictures
• Applications
Office 2007 Demonstration (one hour)
The Microsoft Office 2007 suite of applications represents a
significant change in the way users interact with the software.
The redesigned user interface represents the most significant
change since the Office 95 version was introduced more than a
decade ago. This one hour demonstration will provide a summary
of the most common new features in the user interface that are
common to most of the applications in the suite (Word, Excel,
PowerPoint, Access, and Outlook).
• Office Button
• Ribbon
• Tabs & Contextual Tabs
• Quick Access Toolbar
• Mini Toolbar
• Super Tooltips
• Dialog Box Launchers
• Zoom Slider
• Galleries
• Live Preview
• SmartArt
• File Extensions
Office 2010 Demonstration (one hour)
| Contact Staci: 801-463-1213 |
Training with a personal touch!
Page Title Here
| 6-Hour Courses |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |