About Us Courses Schedules Learning Options Certifications Training Rooms Skills Testing Case Studies Events Contact Us
Training Information Technology Forsythes Group
Courses & Certifications Desktop Applications Microsoft Product Courses Microsoft Word Courses Microsoft Excel Courses Microsoft Access Courses Microsoft Outlook Courses Microsoft Project Courses MS PowerPoint Courses Updating to Office 2007 InfoPath 2003 Microsoft Visio Microsoft Publisher Microsoft Frontpage Windows XP Adobe Product Courses Adobe Acrobat 8 Adobe InDesign Courses Photoshop CS Courses Adobe Photoshop CS-3 Adobe Illustrator Courses Adobe Flash CS3 Dreamweaver 8 Dreamweaver MX MYOB Accounting Corel Draw v12 Crystal Reports Level 1 Crystal Reports Level 2 Technical Professional Development Need further information on Access Courses? Click here Enrollment form VBA for Microsoft Access Dates for next course: Call 02 4969-0690 for the next course date Training Format: Classroom Duration: 2 Price: $1,100.00 Inc GST Overview This course aims to increase your productivity by providing the skills and knowledge to program using VBA in Access 2003 effectively. Prerequisites This course is designed for participants with a sound knowledge of the Access 2003. Learning Outcomes At the completion of this courseware participants will be able to: Understand some of the aspects of developing applications in Access 2003 Create and assign macros and understand the advantages and disadvantages of using macros Understand the programming environment and how forms and modules are used in it Create and work with subroutines and function procedures Create and work with variables Communicate with the user through input boxes and message boxes Program decision structures using IF and CASE statements Develop a variety of programming loops for repeating operations Use the DoCmd object to perform most of the operations associated with a database Use DAO to handle working with data in your programs Use the debugging features of VBA to locate and identify errors Develop safeguards in your program and prevent unforeseen errors. Course Outline 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 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 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 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 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 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 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 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 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 ActiveX Data Objects Tables 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 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 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 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. Forsythes IT & Training provides instructor led computer training on the Microsoft Office and Adobe range of applications. We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia. With our mobile training room we can provide a range of courses on-site at your premises.

	2008 Forsythes IT & Training - All Rights Reserved	Privacy Policy	Terms & Conditions	Site Map	Links & Resources	Home	Website Design - Indelible Image