Go to the Home Page	Microsoft® Access Stage Four Versions 2002 and 2003
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 more new and advanced skills in database design. The course will build on the information presented in the Stage One, Two and Three Course Outlines. Participants will be introduced to the more advanced intricacies in developing an Access application such as sub-forms and sub-reports and database functions.
	Who Should Attend: Participants of this course must be completely conversant with the material covered in the Access Stage One, Access Stage Two and Access Stage Three Course Outlines.
	Course Outline/Table of Contents: Moving existing data from Excel into Access Preparing Excel Data in Excel ready for Importing into Access Importing Excel Spreadsheet into Access Using the Append Query to append Data from Imported Table into Existing Table Relationships Intricacies of Form Design One to Many to Many Subforms. More than one Subform within a Mainform Linking Subforms to Subforms Functions in Mainform Summarising Subform Data Create a Report that only Prints for Current Mainform/Subform Record Using Tab Controls including subforms Database Functions in mainforms and subforms Creating Chart (Graph) Forms Link the query to an Interface form to report varied criteria Working with Queries that control what is reported Reported Join Types in a Query Report Functions including DSUM, DAVG, DCOUNT, DMAX, DMIN Creating Graph Reports Distribution of the Database Creating the Individual Linked Databases Linked Table Manager Import Objects Solutions Database for Database Application ideas Duration: Three or more people one full 6 hour courses will be necessary. One or two people will need 3 two hour sessions.

Copyright Disclaimer