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 2000 Courseware Training Materials
Foundation Level Course

   

Courseware Training Manual

1. Introduction to database concepts

  • What is a database?
  • Tables and relationships
  • The Access application window

2. Database design and table creation

  • Design and document your database
  • Define your needs
  • Basic design rules
  • Determine relationships
  • Creating a database
  • Using the table wizard
  • Adding fields using the table wizard
  • Creating a table without a wizard
  • Adding fields to a new table
  • Field properties
  • The input mask property
  • Setting a primary key
  • Adding records to a table datasheet

3. Formatting a table

  • Editing records
  • Selecting records, fields and columns
  • Deleting records and fields
  • Viewing or setting datasheet default values
  • Re-ordering columns and fields
  • Changing column width and row height
  • Hiding and un-hiding columns
  • Freezing columns
  • Formatting datasheet cells
  • Changing datasheet fonts
  • Copying and moving fields and records
  • Printing

4. Relationships

  • Defining relationships
  • Opening the relationships window
  • Adding tables to the relationships window
  • Making relationships
  • Referential integrity
  • Editing relationships

5. Locating and replacing information

  • A simple search
  • Wildcards
  • Finding specific values
  • Find and replace
  • Sorting records
  • What is a filter?
  • Filtering records

6. Creating simple queries

  • Opening an existing query
  • Creating queries
  • The query grid
  • Logical operators in criteria
  • Text in criteria - wildcards
  • Multiple criteria and alternative criteria
  • Calculated fields
  • Summary queries
  • Update queries
  • Append queries
  • Make-table queries

7. Creating calculated fields

  • Creating calculated fields
  • Using the expression builder

8. Introducing forms

  • Basic form layout types
  • Creating a form using autoform
  • Creating a form using the form wizard
  • Different ways of viewing forms

9. More about creating forms

  • Creating forms without using the form wizard
  • The form design view window
  • Manipulating form design
  • Types of control
  • The toolbox
  • Creating a combo box control
  • Changing form properties
  • Using forms with subforms
  • Creating a form with a subform
  • Controlling data input
  • Changing tab order
  • Adding command buttons
  • Adding page breaks
  • Switchboards

10. Reports

  • Opening and viewing existing reports
  • Printing reports
  • Creating a report using autoreports
  • Creating reports using the report wizard
  • Using the label wizard
  • Using the chart wizard
  • Grouping levels in reports
  • Creating a report without a wizard
  • Creating controls
  • Setting properties

 

  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 

   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.