Call on 1300 794 006 Advanced Search

Home > Desktop Applications > Microsoft Access > Microsoft Access 2007

VBA Access 2007 Book a course:   Location: Sydney Melbourne Brisbane Date: Choose a date... 25 Jul 12 - 27 Jul 12 19 Nov 12 - 21 Nov 12 {None} 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM   Duration: 3 Days Time: 9:00 AM - 5:00 PM   Price: $1,650.00 inc. GST Print Preview | Send to a friend    Learning Method: Instructor Led Duration: 3 Days Overview: This course aims to increase your productivity by providing the skills and knowledge to program using VBA in Access 2007 effectively. Target Audience: This course is intended for people who wish to improve their knowledge and skills in the use of Access 2007 VBA. Pre-requisites: This course is designed for participants with a sound knowledge of the Access 2007. Outline: Expand All Module 1: Development Basics The Access Development Environment The Importance Of Splitting Databases Maintaining Links Using The Database Splitter Using Queries For Reports And Forms Access Run-Time Understanding Client/Server Quick Reference Module 2: Macros and VBA Macro Overview Creating Macros Assigning Macros Creating More Complex Macros Converting Macros To VBA Code Why You Shouldn't Use Macros Quick Reference Module 3: VBA Essentials Programming Environment Overview The Role Of Forms Creating A Startup Form Understanding Modules Code Behind Forms Standard Code Modules Standard Vs Class Modules Naming Conventions Quick Reference Module 4: VBA Subroutines Understanding Modules In Access The Anatomy Of A Module Creating A Subroutine Creating A Function Calling Procedures Passing Parameters Returning Values Scoping Procedures Quick Reference Module 5: Variable VBA Overview Of Variables Creating String Variables Option Explicit Working With Numbers Dealing With Overflows Working With Decimals Working With Dates Default Values Scoping Variables Local Variables Module-Wide Variables Passing Parameters Passing Parameters By Value Quick Reference Module 6: Interactive VBA The Act Of Communicating Creating A Simple Input Box Creating More Elaborate Input Boxes Global Positioning Simple Message Boxes Creating Larger Messages Breaking A Message Line Customising Icons And Buttons Message Box Functions Responding To Different Buttons Quick Reference Module 7: Decisive VBA Decisions Overview Creating An In-Line If Creating A Block If Multiple If Multiple If Using Text Using Case Statements Value Ranges In Case Statements Case Statements With OR Asking Yes/No Questions Quick Reference Module 8: Looping VBA Program Loops Creating A While Loop Taking Care Of Counters Creating An Until Loop For Each Loops Exiting From Loops For Next Loops Quick Reference Module 9: The DoCmd Object Overview Of DoCmd Navigating With DoCmd Moving Through Records Filtering Records With DoCmd Opening A Form With DoCmd Opening A Report With DoCmd Closing A Form Creating Variable Reports Quick Reference Module 10: ActiveX Data Objects Table Overview Of ADO Setting References Using VBA Creating A Table With ADO Removing A Table Using ADO Populating A Form Using ADO Dealing With An Empty Table Quick Reference Module 11: ADO Forms & Recordsets Overview of ADO Forms Navigating Records In A Form Finding A Record Updating A Record Deleting A Record Adding A New Record Quick Reference Module 12: Debugging VBA Overview Of Debugging Setting A BreakPoint Setting Additional Breakpoints Stepping Through A Procedure Viewing The Call Stack Using The Locals And Immediate Windows Adding A Watch Deleting A Watch Quick Reference Module 13: Handling Errors In VBA Error Handling Overview Understanding Common Errors Creating A Simple Error Handler Understanding The Error Object Model More Elegant Error Handling Resuming From Errors Forcing An Error Creating Custom Errors Quick Reference

Course Ratings Averaged from 60 responses. Instructor's Knowledge Training Quality Training Objectives Training Overall Courseware Quality What do these ratings mean? Extraordinary Great Good Average Poor Name: Company: Phone: Email: Location: BrisbaneCanberraCrn-CairnsMelbournePerthSydney How can we assist you?: Bookmark & Share

Home | Search | Site Map | Legal | Privacy Policy | Terms of Use | Contact | Links & Resources | Career Opportunities

Copyright © 2009 New Horizons Learning Centres Holdings Pty Ltd. All rights reserved. ABN: 86 168 459 086

Developed by Globe Web Services