Go to the Home Page	Microsoft® Access Stage Two 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 the course is to provide participants with new and advanced skills in database design, that is complex relationships, designing forms and reports from scratch and creating calculations and parameters in queries. The course will build on the basics established in the Stage One Course Outline. Participants will be introduced to skills necessary to improve the database design and functionality. 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.
	Who Should Attend: Participants of this course must be completely conversant with the material covered in the Access Stage One Course Outline.
	Course Outline/Table of Contents: MODULE 12. ESTABLISHING TABLE RELATIONSHIPS UNDERSTANDING RELATIONSHIPS, TYPES OF RELATIONSHIPS AND PREREQUISITE TO DEFINING RELATIONSHIPS ENFORCED REFERENTIAL INTEGRITY USING CASCADE UPDATE AND CASCADE DELETE PRINT RELATIONSHIPS USING THE TABLE ANALYZER MODULE 13. WORKING WITH FORMS CREATING A FORM USING THE FORM TOOL CREATING AND MODIFYING A FORM IN LAYOUT VIEW Adding, Moving, Resizing and Deleting Controls CREATING A FORM IN DESIGN VIEW Form Record Source Add Existing Fields Resizing Fields on a Form Aligning Fields Control Layouts Adding Titles and Labels to your Form Formatting Controls Using Drawing Tools ADDING AND MODIFYING CALCULATED CONTROLS SETTING TAB ORDER ADDING SECTIONS Form Header and Form Footer Steps To Add or Remove a Form Header and Form Footer Steps To Modify Section Properties Steps To Add or Remove a Page Header and Page Footer Detail Section Setting Section Properties Setting Form Properties CREATING A COMBO BOX Control Wizards Combo Box Properties STEPS TO CREATING A LIST BOX Steps to Creating an Option Group To Add a Logo or Picture ADDING MACROS TO A FORM CREATING SPLIT FORMS CREATING DATASHEET FORMS CREATING MULTIPLE ITEM FORMS CREATING PIVOTTABLE FORMS MODULE 14. IMPORTING AND EXPORTING DATA IMPORTING DATA FROM OTHER APPLICATIONS Saving and Running Import Specifications EXPORTING DATA TO OTHER APPLICATIONS Saving and Running Export Specifications MODULE 15. QUERIES DESIGNING SELECT QUERIES BASED ON MORE THAN ONE TABLE CALCULATIONS IN QUERIES AND ALIASES FORMATTING CALCULATIONS THE GROUP BY OR TOTALS FUNCTION PARAMETER QUERIES MODULE 16. REPORT DESIGN CREATING A BLANK REPORT IN DESIGN VIEW REPORT RECORD SOURCE REPORT SECTIONS USING GROUPING AND SORTING Adding Titles and Labels to your Report Add Existing Fields CREATING A CALCULATION FIELD Page Numbering Calculation Date Calculation MODULE 17. DATABASE MANAGEMENT BACKING UP AND RESTORING A DATABASE COMPACTING AND REPAIRING A DATABASE MODIFYING DATABASE PROPERTIES USING THE DATABASE DOCUMENTER SAVING A DATABASE TO A PREVIOUS VERSION OPENING DATABASES SAVING A DATABASE WITH A PASSWORD 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.

Copyright Disclaimer

Course Outline/Table of Contents:

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