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

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

Microsoft Access 2010 Intermediate

Computer 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

Privacy Policy
© 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

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