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 Foundation

Computer 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

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