Computer Training Materials

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

Region |    
UK/Ireland | USA/Canada Australia/International  

 

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

Training Courses

Microsoft Office 2010
Word 2010 Foundation
 Word 2010 Intermediate
 Word 2010 Advanced
 Word 2010 Basics
 Word 2010 Expert
Excel 2010 Foundation
 Excel 2010 Intermediate
 Excel 2010 Advanced
 Excel 2010 Expert
Excel 2010 Basics
PowerPoint 2010 Foundation
 PowerPoint 2010 Intermediate
 PowerPoint 2010 Advanced
 PowerPoint 2010 Basics
 PowerPoint 2010 Expert
Access 2010 Foundation
 Access 2010 Intermediate
 Access 2010 Advanced
 Access 2010 Basics
 Access 2010 Expert 
Outlook 2010 Basics

Microsoft Office 2007
Word 2007 Foundation
 Word 2007 Intermediate
 Word 2007 Advanced
 Word 2007 Basics
 Word 2007 Expert
Excel 2007 Foundation
 Excel 2007 Intermediate
 Excel 2007 Advanced
 Excel 2007 Basics
 Excel 2007 Expert
PowerPoint 2007 Foundation
 PowerPoint 2007 Intermediate
 PowerPoint 2007 Advanced
 PowerPoint 2007 Basics
 PowerPoint 2007 Expert
Access 2007 Foundation
 Access 2007 Intermediate
 Access 2007 Advanced
 Access 2007 Basics
 Access 2007 Expert
Outlook 2007 Basics

 Microsoft Office 2003
Word 2003 Foundation
 Word 2003 Intermediate
Word 2003 Advanced
 Word 2003 Basics
 Word 2003 Expert
Excel 2003 Foundation
 Excel 2003 Intermediate
 Excel 2003 Advanced
 Excel 2003 Basics
 Excel 2003 Expert
PowerPoint 2003 Foundation
 PowerPoint 2003 Intermediate
 PowerPoint 2003 Advanced
 PowerPoint 2003 Basics
 PowerPoint 2003 Expert
Access 2003 Foundation
 Access 2003 Intermediate
 Access 2003 Advanced
 Access 2003 Basics
 Access 2003 Expert
Outlook 2003 Basics

 ECDL / ICDL COURSEWARE
UK/ BCS ECDL
International ECDL/ ICDL

 ICT/WINDOWS COURSEWARE
PC Basics
 Internet Explorer 8
Windows XP Basics
 Windows Vista Basics
 Windows 7 Basics

 

Site Map

SEO Training Courses

 

Microsoft Access 2010 Intermediate

Courseware Training Materials

Training Course Outline

Queries

  • Creating a Query
  • Adding Criteria to a Query
  • Running a Query
  • Editing Criteria In a Query
  • Saving a Query
  • Creating a Two Table Query and Sorting the results
  • Refining a Query
  • Wildcards
  • Deleting a Query
  • Hiding and Un-Hiding Query Fields

Reports

  • Creating a Report
  • Using the Report Wizard
  • Modifying the Layout of a Report
  • Widening a Report Column
  • Modifying the Report Title
  • Adding a Logo to a Report
  • Formatting a Form using Themes
  • Modifying Field Names within a Report
  • Inserting and Formatting the Date & Time
  • Adding Existing Fields to a Report
  • Resizing Reports For Printing
  • Totals
  • Closing a Report
  • Deleting a Report

Exporting

  • Exporting a Table As an Excel File
  • Exporting a Table As a Text File
  • Exporting a Table As a Text CSV File
  • Exporting a Table As a PDF File
  • Exporting a Table As an XML File

Printing

  • Print Previewing
  • Portrait and Landscape
  • Adjusting Layout In Print Preview
  • Margins
  • Printing a Complete Table
  • Printing Selected Records
  • Printing a Query or Reports
  • Printing Forms

Reference: the Access 2010 Interface

  • Opening a Database 
  • Opening a Table
  • The Ribbon (Toolbar)
  • Ribbon Tabs
  • Groups
  • Dialog Box Launcher
  • Navigating 
  • Contextual Tabs
  • Minimising the Ribbon
  • The File Tab
  • Microsoft Access Help
  • Closing Access 2010

Database Terminology & Theory

  • Database
  • Table
  • Record
  • Field
  • Field Data Types
  • Field Properties
  • Primary Key
  • Types of Database

Trusted Locations

  • Setting a trusted location

Fields

  • Creating a Lookup within a Field.
  • Modifying a Lookup within a Field.
  • Deleting a Lookup within a Field.
  • Creating an Input Mask.
  • Modifying an Input Mask.
  • Deleting an Input Mask.
  • Modifying a Field to Require Data Entry.
  • Modifying a Field So That It Does Not Require Data Entry.

Relationships

  • Creating and modifying a One-To-One Relationship.
  • Creating and modifying a One-To-Many Relationship.
  • Creating and modifying a Many-To-Many Relationship using a Junction Table.
  • Enforcing Referential Integrity.
  • Automatic Updating of Related Fields.
  • Automatic Deletion of Related Records.

Joins

  • Inner Join.
  • Outer Join.
  • Subtract Join.
  • Self Join.

 

Other Microsoft Office 2010 training courses

  Download Educational Computer Training Sample CoursesAustralian computer training materials UK course book Irish Resourses  USA coursework Canada International Computer coursework  Privacy Policy  Terms & Conditions
 © 1995-2012 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged.      
 Course content subject to change without notice. 100% Australian owned company.  
 HTML Formatted Sample      Microsoft Word - Microsoft Excel - Microsoft PowerPoint - Microsoft Access 
 Microsoft Windows |Prices / Ordering | SAMPLES | FAQs | Clients | What's New  | Company Profile
 Contact Us | ECDL / ICDL Courseware | Site Map | Home Page | 
 SEO Services Perth Australia | SEO training seminars, Perth, WA | SEO Perth Video |

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