:: COURSES | SEARCH UPCOMING COURSES | COURSE OUTLINES | BOOK ONLINE ::
:: FREE ARTICLES | ONLINE FORUM | MICROSOFT OFFICE SPECIALIST :: 

 

 :: HOME | COMPANY PROFILE | OUR SERVICES | OUR FACILITIES | CONTACT US ::

 

Microsoft Office Specialist 
Access 2003 Core Training Kit

Includes Training Material on Visual Basic For Access


The Microsoft Office Specialist Access Core Self-Paced Training Kits are for those people who prefer to learn at home but still want to achieve the Microsoft Office Specialist Credentials. The Microsoft Office Specialist Self Paced Training Packs are jam packed full of tools and materials to help you achieve the Microsoft Office Specialist Credential.

This Microsoft Office Specialist Access Training Kit was designed by Chris Le Roy a Microsoft Office Specialist Master Instructor, who setup his training company to help anybody achieve the well sought after Microsoft Office Specialist Certifications. 

Just a Few Of Our Prestigous Clientele   

Some of the most prestigous companies and government agencies such as Ergon, Department of Defence, Army, Department of Natural resources, BHP Billiton, BMA Coal from through out Australia and Overseas have even flown to our location, in sunny Townsville, North Queensland to have their personnel trained in our personal facilities here in Australia.

How To Prove Your Skills to these Employers

     Microsoft Office Specialist Certification is recognized world wide. People know you’re Qualified when they see this certificate on a resume.  With over 2 million Microsoft Office Specialist Certificates issued and 96% of employers using the Microsoft Office Suite then having this certification will ensure employers will snap you up.

Who Are We And Why Trust Me?

After 20 years in the IT industry, consulting for many of the companies mentioned above ... I decided to address the issue of poor training material and companies and setup my own. One-on-One Personal Computer Training was my brain child and after looking at the training material both here in Australia and Overseas I set about writing high quality material to address the poor material. 

If you are coming to Townsville, Australia why not drop in and visit us at:

    One-on-One Personal Computer Training
   "The Church"
   571 Ross River Road
   Kirwan Q 4817
   Australia
   Telephone - +61 7 4728 5582
   Fax - +61 7 4728 5905
   Email - info@1-on-1.biz

Just a quick side bar - We bought the building we are in and its called "The Church" cause we converted an old pentecostal church into our training centre. By the way we actually own the church, pretty cool.

My team and I at our centre Currently Train over 2000+ Students per year in Microsoft Office at our centre and that number seems to grow each and every year.

By the way did I mention that my company is a Microsoft Office Specialist Authorised Testing Centre.

 

The Philosophy Behind The Training Material

The philosophy behind this training kit is that you will do a little bit of theory and then a practical exercise until you complete all the material. At the end of each topic, you will have an opportunity to do some questions and case studies to help reinforce the material you have covered. This training philosophy has helped Chris train in excess of 2000 students from his North Queensland based training centre.

There is over 1,000 pages of information relating to the Microsoft Access 2003 Core Exam plus a bonus training manual in Visual Basic for Access which means you have every opportunity to cover the material required.

What's Covered In Each of the Manuals - Contents

Level 1- Manual

8     Introduction to databases

8     Starting and leaving Access

8     Database window, objects and views

8     Screen elements, toolbars, shortcut menus, Undo, Help and the Office Assistant

8     Working in Datasheet View and Form View

8     Entering and editing data

8     Opening and closing databases

8     Creating a database and using the Database Wizard

8     Backup a Database

8     Compact and Repair Databases

8     Creating tables with the Table Wizard or intelligent tables

8     AutoForm, Form Wizard, AutoReport, Report Wizard

8     Creating a Select Query

8     Print Preview, page setup and printing

 

Level 2 - Manual

8     Relationships and creating a table in Design View

8     Moving, copying, renaming and deleting

8     Column widths, row heights and fonts

8     Field properties, Field Builder and working in Table

8     Design View

8     Lookup Wizard

8     Finding, replacing and sorting data

8     Select Query window, QBE grid and criteria

8     Form Design View

8     Working with controls in forms and reports

8     Format Painter, AutoFormat and tab order

8     Working in Report Design View

8     Simple reports and mailing labels

 

Material Covered in the Module 2 Manual (Both Levels are combined in the one manual)

Level 3

8     Relationships, primary key, joins, referential integrity and cascade options

8     AutoLookup, filtering and indexes

8     Field and table properties

8     Operators, expressions and functions

8     Calculations in forms and reports

8     Selecting records in queries

8     Multi-table forms

8     Form properties, form sections, form tabs and form appearance

8     Option groups, combo boxes and command buttons

8     Creating forms and reports without a Wizard

8     Editing and formatting reports

8     Sorting and grouping

8     Form letters with Access and Word

 

Level 4

8     Subdatasheets, subforms and subreports

8     Crosstab queries, parameter queries, query Wizards and action queries

8     Importing, exporting and linking

8     Bound and unbound objects

8     Hyperlinks, static web pages and data access pages

8     Creating, running and editing macros

8     Macro groups and conditions for actions

8     Using macros for events in forms and reports

8     Command buttons and customised toolbars

8     Introduction to automated applications

8     Switchboards, dialogue boxes, menus and toolbars

 

Visual Basic For Access Manual (Both Levels are combined in the one manual)

 

Level 1 (Day 1)

8     The Access Development Environment

8     Importance of Splitting Databases

8     Maintaining Links

8     Using the Database Splitter

8     Using Queries for Reports and Forms

8     Access Run Time

8     Understanding Client/Server

8     Creating and Assigning Macros

8     Converting Macros to VBA Code

8     Why you shouldn’t use macros

8     Role of Forms and creating a start-up form

8     Code Behind forms

8     Standard Code modules

8     Class Code Modules

8     Naming Conventions

8     Creating a Subroutine, Function, Procedures

8     Passing Parameters and Returning Values

8     Creating Strings, working with numbers and dealing with Overflows.

8     Passing Parameters

8     Message Boxes, Breaking a Message Box

 

Level 2 (Day 2)

8     Creating an Inline If

8     Multiple If

8     Using Case

8     Asking Yes No Questions

8     Program Loops

8     Creating an Unlimited Loop

8     For Each Loops and For Next Loops

8     Navigating with DoCmd

8     Filtering Records

8     Opening a Form and Report

8     Closing Forms

8     DAO, Creating a Table and Populating a table

8     Dealing with an Empty Table

8     Debugging VBA using Breakpoints

8     Stepping through a procedure

8     Handling errors and forcing and error

8     Error Handling

 

Testimonials


The best way to find out the quality of a training kit and manuals is simply to see some of the feedback from others. These testimonials are from students like you who have used these manuals. We asked them one simple question.

    What did you find most helpful or valuable?

  • All Of It!! G. Hogg

  • Step By Step Instruction in Course Manual as well as shortcuts and illustrations. C. Falconer

  • Shortcuts D. Stephenson

  • Manual to take home to revise and go over content learnt B. Hock

  • The Exercise Books Were Most Helpful D Carmichael

  • The Info Given and Hints Given Towards the Programs N Whalen

  • The Real life experiences shared! J Kearns

    What Do You Get In Each Microsoft Office Specialist Kit?

    Each of these brand new Microsoft Office Specialist kits contain a range of items that include:

    • Microsoft Office Access 2003 Level 1 Manual and Exercise CDROM 
      (Value $75.00)  200+ Page Manual

    • Microsoft Office Access 2003 Level 2 Manual and Exercise CDROM 
      (Value $75.00) 200 + Page Manual

    • Microsoft Office Access 2003 Module 2 Manual and Exercise CDROM
      (Value $75.00)

    • Microsoft Office Visual Basic for Access 2003 Manual and Exercise CDROM (Value $75.00)

    • Self Test Software - Microsoft Office Pre-Assessment Exam CDROM 
      (Value $66)

    • 2 hours of Support Via Our Internet Live Support System (Value $116)
           Our website at www.1-on-1.biz will take you to our live support system.

      Your First Special Bonus!

    • FREE Computer Buyers Guide (Value $15.00)

    • FREE High Performance Super Learning and Relaxation Music (Value $29.00)

    • FREE Seminar Bag to carry all your learning materials (Value $49.00)

       


      You Can't Loose 
      With Our Money-Back Guarantee

      Your satisfaction is guaranteed with our 100%, no-questions-asked iron-clad money back guarantee. If you aren't absolutely thrilled with our product, just contact us within 90 days and we'll refund 100% of your purchase price. No questions asked.

       

      How Will This Kit Be Sent To You!

      This kit is NOT an ebook.  The kit is a proper package that will be forwarded to you by mail.  Delivery normally takes  a week however if you would prefer we can send it overnight to you.

      How to Sit The Microsoft Office Specialist Exams!

      There are about 100 different sites throughout Australia that offer the Microsoft Office Specialist Exams.  You can undertake the exams at our testing centre in Townsville, North Queensland Australia.  Alternatively,  you will be provided a list of all the testing centres in this kit when you purchase it.

      I will also give you information on how to access  a full list of all testing centres through out the world 

 

NEWSLETTER

:: HOME | COMPANY PROFILE | OUR SERVICES | OUR FACILITIES | COURSE SCHEDULE | CONTACT US ::

Copyright © 2006 One-on-One Personal Computer Training
For Comments or Questions About this Website Please E-mail - info@1-on-1.biz