Access Level 1 Introduction Database Concepts Tour of Access Database Wizard Building a Database Creating Databases from Scratch Using the Table Wizards Tables from Scratch Database View Changing Records Table Appearance Cell Effects Managing Appearance of Columns Filter Techniques Sorting-Finding & Filtering Query Essentials Relationships Query Wizard Adding Criteria Using Wildcards Access 2003 Level 2 Form Essentials Using the Form Wizard Creating Forms with AutoForm Report Essentials Using the Report Wizard Exporting Reports Using the Label Wizard Getting Help Field Properties Field Size Date and Time Custom Formats Yes & No Fields Default Value & Expression Builder Validation Rule Indexed Fields Unicode & IME Smart Tags Create a Lookup Inserting a Field Inserting a Lookup Field Adding to the Lookup List Limit to List Importing & Exporting Data Export to Excel Importing from Databases Importing Data from Excel Linking Data from Excel Creating a Shared Database Relationships Relationship Concepts Creating Table Relationships Enforcing Referential Integrity Understanding Cascade Options Printing Database Information Access 2003 Level 3 Advanced Query Techniques Query Desing Tips & Tricks Using Parameter Queries Multiple Parameter Queries Report Bases on a Parameter Query Setting up Calculated Fields Overview of the Expression Builder Creating Summary Queries Access & HTML Creating & Using Hyperlinks Publish Database to HTML Format Data Access Pages Merging Access into Word The Mail Merge Wizard Running the Merge Action Queries Make Table Query Running an Append Query Running a Delete Query Running an Update Query Printing Database Maintenance Compact & Backup Using Compact & Repair Utility Using Backup & Restore Tool Advanced Form Design Printing the Selected Records Creating & Using Form Controls Calculated Controls Advanced Form Modification Selecting Controls Sizing & Moving Controls Adding Fields Saving & Viewing Forms Adjust Tab Order Advanced Report Design Understanding the Report Design Modifying Controls Adding Controls Softing & Grouping Report Data Working with the Pagebreak Control Excel 2003 Lesson 1 Beginning Getting Started Starting Excel Workbooks & Worksheets Task Pane Menu Bar & Shortcut Menus Toolbars Navigation & Mouse Pointer Entering Data Data Entry Auto-Fill Entry Erasing Data AutoComplete & Preselections Undo & Redo Saving, Opening & Closing Files File Save & File Save As Opening a File Closing a File Creating a New Workbook Entering Formulas Methods of Entering Formulas Repeating Formulas in Adjacent Fields Formula Operators Additional Formulas Basic Excel Functions Totals & Averages Function Overview Formatting Adjusting Column Widths & Row Heights Formatting Toolbar Numeric Formatting Changing Worksheet Layout Inserting Columns, Rows & Cells Deleting Columns, Rows & Cells Moving Cells Copying Cells Printing Using Print Preview & Page Setup Printing Controls Printing Excel Help System Using Excel Online Help Using Excel Offline Help Excel 2003 Lesson 2 Intermediate Additional Formatting Cell Alignment & Orientation Borders Centering Text Across Columns Hiding & Unhiding Columns & Rows Conditional Formatting Formatting Based on Values & Multiple Conditions Avoiding Overlapping Conditions Using a Formula to Control Formatting Specialized Numeric Formatting Custom Category Special Category Cell References Absolute References Mixed References Range Names Naming & Using Range Names Additional Creation Methods Pasting a List of Range Names in a Worksheet Deleting Range Names Assigning a Name to a Value Formula Auditing Techniques Using the Formula Auditing Toolbar Tracing Dependent Cells Tracing Precedent Cells Cell Protection Techniques Locking/Unlocking Selected Cells Protecting/Unprotecting a Worksheet Find & Replace Matching Entire Cells & Case Factors Formulas & Wildcard Characters Find & Replace by Format Adjusting Worksheet Views Freeze/Unfreeze Panes Horizontal & Vertical Split Screens Customizing Toolbars Adding & Removing Buttons Economizing Buttons & Resetting Toolbars Creating New Tool Bars Excel 2003 Lesson 3 Advanced The "IF" Function "IF" Functions & Relational Operators Using Text in "IF" Functions Logical Operators ("AND" & "OR") with "IF" Functions Nested "IF" Functions Getting Table Data with "VLOOKUP" Function Dates & Time Using Dates as Values Entering a Series of Dates Date/Time Techniques Multi-Sheet Workbooks Renaming Sheets & Coloring Tabs Inserting & Deleting Sheets Moving, Copying & Grouping Sheets Formulas Across Multiple Sheets Multiple Workbooks Opening & Displaying Multiple Workbooks Moving & Copying Sheets Across Workbooks Linking Formulas Across Workbooks Locating & Maintaining Links Features & Settings Show/Hide Gridlines & Formulas Recently Used File List & New Workbook Settings Other Settings & Features Overview of Charting Quick Chart Creation Chart Types Titles, Gridlines & Scaling Formatting Basics Printing & Copying Charts Overview of Database Features Sorting Data Creating Subtotals Filtering Pivot Tables Excel 2003 MOS Elements Excel 2003 Lesson 6 Additional Topics Templates Saving a Skeleton Workbook as a Template Creating a New Workbook from a Template Editing a Template Protection Workbook Protection File Password Macro Security Sharing Workbooks Establishing Sharing Tracking Changes Merging Workbooks Exporting Data From Excel Exporting to Access Exporting to Word Saving as a Text File Saving as a New Folder Importing Data to Excel Importing Data Using the File Open Command Importing or Copying External Data Hyperlinks Tools Research Excel & the Web Importing Web Data Saving Excel Data as a Webpage Customizing Excel Environment Creating a New Menu Creating a Macro Running a Macro Editing a Macro Excel 2003 Lesson 7 Special Topics Functions Statistical Functions Date & Time Functions Financial Functions Mathematical Functions Formula Troubleshooting Formula Watch Window Evaluate Formula Feature Data Analysis Tools Goal Seek Solver Scenarios Data Table Consolidating Data Consolidate By Position Consolidate By Category Managing a List Creating a List Adding Data to a List Adding Totals File Properties File Properties Workbook/Worksheet Worksheet Styles Autoformatting Showing Multiple Worksheets Comparing Workbooks Outlook 2003 Level 1 Introduction to Outlook Starting Outlook Getting to Know the Outlook Interface Exploring Outlook Using the Reading Pane Creating New Folders Using a Toolbar Using Outlook Today Using Views Sending Email Composing a New Message Formatting a Message Replying to & Forwarding Messages Redirecting Responses Automatically Message Options Attachments Using Address Books Adding & Editing a Contact Sending a Message from the Address Book Creating & Using Distribution Lists Importing & Exporting Address Books Displaying Contacts in Various Views Printing in Outlook Printing Items in Outlook Print Options Cleaning up Outlook Deleting Items Recovering Deleted Items Getting Help Getting Help & Online Help Outlook 2003 Level 2 Using the Calendar Setting Up your Work Schedule Calendar Views & Display Options Additional Display Settings Other Users’ Folders / Shared Calendars Planning Meetings & Appts. Creating, Editing, & Recurring Appts. Setting Appt. Reminders Meeting Requests Finding an Appointment Using Tasks Creating a Task Task Request Scheduling Time for A Task Setting Task Default Options Using the Journal Creating a Journal Entry Creating Automatic Journal Entries Editing a Journal Entry Working with Journal Entry Views Using Notes Creating & Using Notes Configuring & Viewing Notes Organizing Messages Using Organize Creating Personal Folders Moving & Copying Messages Automating Your Mailbox Toolbars Customizing Tool Bars Creating a New Toolbar button Customizing Views Creating Custom Views Using Views Using Outlook’s Anti-Spam Tools Enabling Outlook’s Junk Email Assigning Delegates Delegate Permissions Sharing Folders Outlook 20003 Level 3 Advanced Mail Message Options Automatic Spell Checking Creating a Signature in Outlook Setting the Default Message Font Setting the Default Stationary Finding, Recalling, & Resending Messages Finding Mail Messages Using Activities Tab Search Folders Recalling & Resending Archiving Outlook Data Using AutoArchiving Retrieving Archived Items Disabling AutoArchive Setting Archive Properties for Items Public Folders Creating a Public Folder Public Folder Conversations Public Folders Multiple Email Account Creating Additional Email Accounts PowerPoint 2003 Level 1 Working in PowerPoint Introduction to PowerPoint Customizing PowerPoint Changing Commands Getting Help Starting a Presentation Blank Presentations Basics of Slide Layout A Visual Overview Managing Content in the Outline Managing Content Getting Content Just Right AutoCorrect and AutoFormat Importing Outlines from Word Additional Content Tips PowerPoint 2003 Level 2 Working with Slides-Text-Pictures Introduction to Internetworking Working with Place Holders Working with Text Objects Pictures Compressing Pictures Working with ClipArt Graphic Objects Drawing Toolbar Editing Objects Formatting Objects PowerPoint 2003 Level 3 Organization Charts & Diagrams Introduction to Diagrams Creating Charts & Diagrams Creating Free-Form Diagrams Creating Data-Driven Charts Data-Driven Charts Inserting Charts from Excel Inserting Data & Text Table Inserting Excel Worksheets Integrating Applications Aligning Text with Tables Embedding a Word Table Adding Video & Sound Adding Video Adding Sound Animating PowerPoint Objects Animation Schemes Custom Animation Animating Text Animating Charts Creating Motion Paths Slide Transitions Customizing Color Schemes Color Schemes Working with Slide Masters Restoring the Formatting PowerPoint 2003 Level 4 Formatting the Slide Background Formatting the Slide Background Designs & Masters Designing Masters Master Slides Preparing a Presentation for Delivery Rearranging & Organizing Slides Creating Custom Slide Shows Summary Slides Configuring Slide Timing Working with Hyperlinks & Action Buttons Navigating with Hyperlinks Using Action Buttons Presenting a PowerPoint Slide Show Setup Show Launching & Navigating a Slide Show Marking Up Slides Advanced Presentation Tools Printing Presentations Printing Printing in Color and B&W Printing Handouts & Notes Exporting a Presentation to Word Collaborating on a Presentation Reviewing a Presentation with Outlook Reviewing a Presentation without Outlook Delivering a Presentation Remotely Packaging a Presentation Creating Web-Based Presentations Word 2003 Level 1 First Steps in Word Starting Word The Word Window Creating Content Fundamental File Operations Working Comfortably in Word Fundamentals of Working in Word Copy and Paste Select and Do Help Working Productively in Word Working Productively in Word Navigating Word Documents Efficiently Selecting Efficiently Working as a Power User Templates New Word Documents The Blank Document Template Custom Templates Managing Templates Word 2003 Level 2 Content Creating Content Inserting Symbols & Characters Spelling & Grammar AutoFormat & Auto Correct Automating Content Creation Using Word Reference Materials Working with Fields Formatting Word Documents The Format Menu Paragraph Formats Bullets & Numbering Borders & Shading The Format Painter Styles How to Un-Format a Document Aligning Text with Tables & Tabs Tables Tabs Managing Documents Save and Save As Word 2003 Level 3 Sections Pagination Page Setup Headers & Footers Creating Multiple Sections Headers & Footers in Multiple Sections Newspaper Columns Making Long Documents Accessible Juggling Projects Tables of Contents Document Tables & indices Endnotes-Footnotes & Cross References Auto Summarize Master Documents Macros Creating Macros with the Macro Recorder Playing Macros Macro Security Editing & Managing Macros Word 2003 Level 4 Reviewing Documents Highlighting Collaborative Reviews Compare & Merge Comparing Document Versions Sealing & Protecting Documents Forms Creating Forms Advanced Forms Protecting Sections of Complex Forms Fill-in-Fields Working with Web Documents Saving & Opening Web Documents Publishing to the Web Working with Hyperlinks Applying Themes Structuring Documents with XML Word 2003 Level 5 Photos ClipArt & WordArt Inserting & Positioning Pictures Photo Alteration Compressing Pictures ClipArt WordArt Drawing Basic Objects Creating Freeform Diagrams Organization Charts & Diagrams Charts Final Format Tips Creating Text Boxes Page Borders Page Background & Watermark Envelopes, Labels & Mail Merge Envelopes & Labels