VBA Access 2007

		Book a course:
		State:	Choose a state... NSW QLD	Date: What is OLL?
		City:		Time:
		Price:

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