Home  | Samples / Prices  | Courses  | What You Get  | About Us  | FAQs  | Contact | ECDL / ICDL

             Cheltenham Courseware

UK Computer Courseware Irish Computer Courseware
Please select your region  
UK/Ireland | USA/Canada | Australia/International 

 

 COMPUTER COURSES

  MS Office 2010
  Courseware
  Word 2010 Foundation
  Word 2010 Intermediate
  Word 2010 Advanced
  Excel 2010 Foundation
  Excel 2010 Intermediate
  Excel 2010 Advanced
  Access 2010 Foundation
  Access 2010 Intermediate
  Access 2010 Advanced
  Outlook 2010 Basics
  PowerPoint 2010 Foundation
  PowerPoint 2010 Intermediate
  PowerPoint 2010 Advanced

  MS Office 2007
  Courseware
   Word 2007 Foundation
  Word 2007 Intermediate
  Word 2007 Advanced
  Excel 2007 Foundation
  Excel 2007 Intermediate
  Excel 2007 Advanced
  Access 2007 Foundation
  Access 2007 Intermediate
  Access 2007 Advanced
   Project 2007 Foundation
  Publisher 2007 Foundation
  Visio 2007 Foundation
   PowerPoint 2007 Foundation
  PowerPoint 2007 Intermediate
  PowerPoint 2007 Advanced
  Outlook 2007 Basics

   MS Office 2003 
  Courseware
   Word 2003 Foundation
  Word 2003 Intermediate
  Word 2003 Advanced
  Excel 2003 Foundation
  Excel 2003 Intermediate
  Excel 2003 Advanced
  Access 2003 Foundation
  Access 2003 Intermediate
  Access 2003 Advanced
  Access 2003 Basics
  Access 2003 Expert
  Project 2003 Foundation
  Publisher 2003 Foundation
  PowerPoint 2003 Foundation
  PowerPoint 2003 Intermediate
  PowerPoint 2003 Advanced
  Outlook 2003 Basics

  LONGER 2 LEVEL 
  COURSES

  MS Office 2010
  Courseware
 
  Word 2010 Basics
  Word 2010 Expert
  Excel 2010 Basics
  Excel 2010 Expert
  Access 2010 Basics
  Access 2010 Expert 
  Outlook 2010 Basics
  PowerPoint 2010 Basics
  PowerPoint 2010 Expert

   MS Office 2007
  Courseware
  Word 2007 Basics
  Word 2007 Expert
  Excel 2007 Basics
  Excel 2007 Expert
  Access 2007 Basics
  Access 2007 Expert
  Project 2007 Foundation
  Publisher 2007 Foundation
  Visio 2007 Foundation
  PowerPoint 2007 Basics
  PowerPoint 2007 Expert
   Outlook 2007 Basics

   MS Office 2003 
  Courseware
  Word 2003 Basics
  Word 2003 Expert
  Excel 2003 Basics
  Excel 2003 Expert
  Access 2003 Basics
  Access 2003 Expert
  Project 2003 Foundation
  Publisher 2003 Foundation
  PowerPoint 2003 Basics
  PowerPoint 2003 Expert

  ICT Courseware
   PC Basics
   Windows XP Basics
  Windows Vista Basics
  Windows 7 Basics
   Internet Explorer 8

SEO Training

Sample IT Training Materials

SEO training

 

Printable and customizable Microsoft Office 2010 Training MaterialsMicrosoft Access 2010 Advanced Course

IT Courseware Training Materials

Training Course Outline

 Queries

  • About Queries
  • Update Query.
  • Delete Query.
  • Make Table Query.
  • Append Query.
  • Crosstab Query.
  • Find Duplicates Query.
  • Find Unmatched Records Query.
  • One Variable Parameter Query.
  • Two Variable Parameter Query.
  • Using Wildcards In a Query:
  • Maximum or Minimum Values In a Query.
  • Using Calculated Fields That Perform Arithmetic Calculations.
  • Grouping Information In a Query using Functions.

Forms

  • Types of Form Controls
  • Bound Controls Vs. Unbound Controls.
  • Text Box.
  • Combo Box.
  • List Box.
  • Check Box.
  • Limit to List
  • Distinct Values.
  • Arithmetic Expressions.
  • Logical Expressions.
  • Modifying the Tab Order in a Form.
  • Creating a Sub-Form.
  • Linking a Sub-Form.

Reports

  • Formatting Arithmetic Calculation Controls 
  • Applying a Running Sum For a Group or Over All
  • Concatenating Fields within a Report.
  • Inserting a Data Field In a Report Group.
  • Inserting a Data Field In a Report Page.
  • Inserting a Data Field In Report Headers and Footers.
  • Sorting and Grouping Records In a Report By Field(S).
  • Forcing Page Breaks For Groups In a Report.
  • Creating a Linked Sub-Report.

Macros

  • Creating Macros
  • Assigning a Macro to a Command Button.
  • Assigning a Macro to an Object.
  • Assigning a Macro to a Control.

Linking Data

  • Linking an Excel Workbook to a Database.
  • Linking External Text Data In a TXT File
  • Linking External Text Data In a CSV File
  • Linking External Data to a Database using Existing Database Files.

Importing Data

  • Importing an Excel file.
  • Importing a CSV Text file 
  • Importing a TXT file
  • Importing an XML file
  • Importing an Database File

 

Other Microsoft Office 2010 training courses

 

 		  

UK coursework   USA coursework Canada Australia coursework International Computer coursework  Privacy Policy       SEO Training
© 1995-2012 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged. Terms & Conditions 
Course content subject to change without notice. Cheltenham Group | HTML Formatted Sample
Microsoft Word - Microsoft Excel - Microsoft Access - Microsoft PowerPoint - Microsoft Windows | Prices & Ordering | Computer Courseware Samples | FAQs | Cheltenham Group | About Us | Contact Us |  ECDL UK Instructor-led Courseware  |  ECDL / ICDL International Courseware | Site Map | Home Page |  Perth SEO | 
SEO training Perth

            Computer Training resources for IT trainers inc Microsoft Office 2010

  Customisable Courseware
  No Annual Renewal Fees
  Unlimited Number of Users
  Unlimited Reprinting Rights
  PLUS Intranet Versions


Please select your region  
 UK/Ireland | USA/Canada | Australia/International 

   Computer Training Courseware for IT Teaching Professionals
    Quality courseware materials for tutor-led computer training:  
    For schools, colleges, IT trainers, corporate training departments, & computer training companies. SEO Perth Training Video