Discounts & Specials

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


Select your region  | USA/Canada UK/Ireland  | Australia/International

Home  | Samples & Prices  | Courses  | What you Get | FAQs  | About Us | Contact Us

 Cheltenham Courseware

OFFICE 2010 
COURSEWARE
Microsoft Word 2010 Foundation Training tutorials Word 2010 Foundation
Microsoft Word 2010 Foundation Training tutorials Word 2010 Intermediate
Microsoft Word 2010 Foundation Training tutorials Word 2010 Advanced
Microsoft Word 2010 Foundation Training tutorials Word 2010 Basics
Microsoft Word 2010 Advanced Courseware Word 2010 Expert
Microsoft Excel 2010 Foundation Training Materials Excel 2010 Foundation
Microsoft Excel 2010 Foundation Training Materials Excel 2010 Intermediate
Microsoft Excel 2010 Foundation Training Materials Excel 2010 Advanced
Microsoft Excel 2010 Foundation Training Materials Excel 2010 Basics
Microsoft Excel 2010 Advanced Courseware Excel 2010 Expert
Microsoft PowerPoint 2010 Foundation Training Materials PowerPoint 2010 Foundation
Microsoft PowerPoint 2010 Foundation Training Materials PowerPoint 2010 Intermediate
Microsoft PowerPoint 2010 Foundation Training Materials PowerPoint 2010 Advanced
Microsoft PowerPoint 2010 Foundation Training Materials PowerPoint 2010 Basics
Microsoft PowerPoint 2010 Advanced Courseware PowerPoint 2010 Expert
Access 2010 Foundation
Access 2010 Intermediate
Access 2010 Advanced
 Access 2010 Basics
Microsoft Access 2010 Advanced Courseware Access 2010 Expert 
Microsoft Outlook 2010 Foundation Courseware Outlook 2010 Basics

OFFICE 2007 
COURSEWARE
Microsoft Word 2010 Foundation Training tutorials Word 2007 Foundation
Microsoft Word 2010 Foundation Training tutorials Word 2007 Intermediate
Microsoft Word 2010 Foundation Training tutorials Word 2007 Advanced
 Word 2007 Basics
Microsoft Word 2007 Advanced Courseware Word 2007 Expert
Microsoft Excel 2010 Foundation Training Materials Excel 2007 Foundation
Microsoft Excel 2010 Foundation Training Materials Excel 2007 Intermediate
Microsoft Excel 2010 Foundation Training Materials Excel 2007 Advanced
 Excel 2007 Basics
Microsoft Excel 2007 Advanced Courseware Excel 2007 Expert
Microsoft PowerPoint 2010 Foundation Training Materials PowerPoint 2007 Foundation
Microsoft PowerPoint 2010 Foundation Training Materials PowerPoint 2007 Intermediate
Microsoft PowerPoint 2010 Foundation Training Materials PowerPoint 2007 Advanced
 PowerPoint 2007 Basics
Microsoft PowerPoint 2007 Advanced Courseware PowerPoint 2007 Expert
Access 2007 Foundation
Access 2007 Intermediate
Access 2007 Advanced
 Access 2007 Basics
Microsoft Access 2007 Advanced Courseware Access 2007 Expert
Microsoft Outlook 2010 Foundation Courseware Outlook 2007 Basics

 OFFICE 2003 
COURSEWARE
Microsoft Word 2010 Foundation Training tutorials Word 2003 Foundation
Microsoft Word 2010 Foundation Training tutorials Word 2003 Intermediate
Microsoft Word 2010 Foundation Training tutorials Word 2003 Advanced
Word 2003 Foundations Training Course Word 2003 Basics
Microsoft Word 2003 Advanced Courseware Word 2003 Expert
Microsoft Excel 2010 Foundation Training Materials Excel 2003 Foundation
Microsoft Excel 2010 Foundation Training Materials Excel 2003 Intermediate
Microsoft Excel 2010 Foundation Training Materials Excel 2003 Advanced
Excel Foundations Training Course Excel 2003 Basics
Microsoft Excel 2003 Advanced Courseware Excel 2003 Expert
Microsoft PowerPoint 2010 Foundation Training Materials PowerPoint 2003 Foundation
Microsoft PowerPoint 2010 Foundation Training Materials PowerPoint 2003 Intermediate
Microsoft PowerPoint 2010 Foundation Training Materials PowerPoint 2003 Advanced
PowerPoint Foundations Training Course PowerPoint 2003 Basics
Microsoft PowerPoint 2003 Advanced Courseware PowerPoint 2003 Expert
Access 2003 Foundation
Access 2003 Intermediate
Access 2003 Advanced
Access Foundations Training Course Access 2003 Basics
Microsoft Access 2003 Advanced Courseware Access 2003 Expert
Microsoft Outlook 2010 Foundation Courseware Outlook 2003 Basics
WINDOWS 
COURSEWARE
PC Foundations Courseware PC Basics
 Internet Explorer 8 Training Courses Internet Explorer 8
Windows XP Foundation Training Materials Windows XP Basics
Windows Vista Foundation Training Materials Windows Vista Basics
Windows 7 Foundation Training Materials Windows 7 Basics

SEO training seminars, Perth, WA

Microsoft Access 2010 Foundation

Courseware Training Materials 

Training Course Outline

Database Concepts

  • Database
  • Relational Database
  • Table
  • Record (Row)
  • Field (Column)
  • Data Types

Opening a Database & Security Issues

  • Opening a Database 
  • Trusted Locations 
  • Setting the Default Folder Location 
  • Closing the Access Program

Tables, Fields and Field Types

  • Creating a New Blank Database
  • Adding Fields and Setting the Field Type
  • About Access Data Types
  • Closing and Naming a Table

Table Navigation & Modification

  • Opening a Table within a Database
  • ‘Datasheet View’ vs. ‘Design View’
  • Adding Records to a Table
  • Navigating Through Records 
  • Adjusting Column Width
  • Automatically Resizing a Column Widths
  • Rearranging the Column Order

Field Properties

  • Field Properties
  • Input Masks
  • Validating Numbers
  • Validating Dates
  • Data Entry Required / Not Required
  • Field Properties – Reference Materials
  • Field Properties – Logical Operators
  • Field Properties – General
  • Field Properties – Format
  • Field Properties – Input Mask Characters

Manipulating Tables & Records

  • Renaming a Table
  • Editing Data within a Record
  • Deleting Data within a Record
  • Using the Undo Command
  • Deleting a Single Record
  • Deleting Multiple Records
  • Deleting a Table

Primary Keys and Indexing

  • Defining a Primary Key
  • Indexing 
  • Creating a Single-Field Index
  • Creating a Multiple-Field Index
  • Deleting Multi-Field Indexes

Filtering

  • Text Filters
  • Single Filter
  • Multiple Filters

Sorting

  • Sorting Records
  • Removing a Sort
  • Sorting on Multiple Fields

Searching

  • Searching Through Records

Relationships

  • One-To-Many Relationship
  • Many-To-Many Relationship
  • One-To-One Relationships
  • Creating Relationships between Tables
  • Referential Integrity
  • Cascade Options
  • Cascade Update Related Fields
  • Cascade Delete Related Records
  • Enabling Cascade Options
  • Deleting Relationships

Forms

  • Creating Forms
  • Modifying Forms
  • Saving a Form
  • Form View
  • Adding and Formatting Attachments
  • Modifying Data within Records
  • Deleting Records using a Form
  • Adding Records using a Form
  • Closing Forms
  • Deleting a Form
  • Filtering a Form
  • Removing a Filter from a Form
  • Inserting and Modifying a Form Header
  • Inserting and Modifying a Form Footer

 

Other Microsoft Office 2010 training courses

 


    USA coursework Canada Australia coursework UK coursework International Computer coursework  Privacy Policy  Terms & Conditions
     © 1995-2012 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged. 
     Course content subject to change without notice. HTML Formatted Sample.

   Prices / Ordering  |  SAMPLES  |  FAQs  |  Clients | What's New  |  Company Profile  |  CONTACT US
   ECDL / ICDL Courseware | Site Map | Home | Windows 7 & Microsoft Office 2010 Teaching Resources  
    SEO Perth  | SEO training seminars, Perth, WA

Download Computer Training Sample Courses & office 2010 tutorials

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

www.CheltenhamCourseware.com