Go to the Home Page

Microsoft® Access Stage Three

Versions 2007 and 2010

Training
Access 2007 and 2010 (NEW!)

• Stage One
• Stage Two
• Stage Three
• Exercise Files
• e-Learning

Skill Assessments (2007 or 2010)

• Stage One Quick
• Stage Two Quick
• Stage Three Quick

Access 2002 and 2003

• Stage One
• Stage Two
• Stage Three
• Stage Four
• Stage Five
• Exercise Files
• e-Learning

Skill Assessments (2002 or 2003)

• Stage One Quick
• Stage Two Quick
• Stage Three Quick
• All Stages Full

Related Web Sites

• Microsoft Office Exams
• www.cathi.co.nz
• www.bayrodders.co.nz

Course Objectives:
The aim of this course is to provide participants with new and advanced skills in database design. The course will build on the basics established in the Stage One and Stage Two Course Outlines. Participants will be introduced to skills necessary to improve the database design and functionality with an icon to start the database from the desktop, and customised toolbars, menus and security leading the user through the database.

All Access courses are based on the Microsoft Certified Application Specialist exams, if you complete Stage One, Two and Three you should consider sitting the Microsoft Certified Application Specialist exam.

If you require training in a version of Access other than Access 2002, 2003 or 2007 please contact Catherine.

Course Outline/Table of Contents:

• MODULE 18. SUBFORMS

  • Creating the Subform

  • Embedding a Subform

  • APPLYING AUTO FORMATS

  • APPLYING, MODIFYING AND REMOVING CONDITIONAL FORMATTING

• MODULE 19. ADVANCED QUERIES

  • Find Unmatched Records

  • INNER AND OUTER JOINS

  • Adding and Removing Fields

  • Find Duplicates

  • CROSSTAB AND SUB-QUERIES

• MODULE 20. CREATE ACTION QUERIES

  • Make Table Query

  • To Run the Action Query

  • Update Query

  • APPEND QUERY

  • DELETE QUERY

  • QUERIES FROM FILTERS

• MODULE 21. SUB-REPORTS

• MODULE 22. CREATING AND MODIFYING CHARTS

• MODULE 23. EXPORTING AS PDF OR XPS FORMAT

• MODULE 24. BUILDING YOUR ACCESS APPLICATION

  • AUTOMATING WITH MACROS

  • CREATING INTERFACE FORMS

  • MACRO CONDITIONS

  • CREATING THE AUTOEXEC MACRO

  • MODIFY DATABASE OPTIONS

  • CUSTOMISING STARTUP

  • CREATING A DATABASE ICON

  • AUTOKEYS MACRO

• MODULE 25. SPLITTING DATABASES

  • LINKING TABLES

  • Working with Object Dependencies 

Duration: Three or more people a full 6 hour course. One or two people will need 2 or 3 two hour sessions.

Upon completion of Stage One, Two and Three, the participant should consider sitting the Microsoft Certified Application Specialist Access Exam.