This course is designed to introduce experienced Access users to the Visual Basic for Applications (VBA) programming language. It will show how to use VBA to extend the capabilities of Access forms, and how to use detain Access database files from other Office applications.
Questions & Answers
Ask a question and other users will answer you
This course is designed to introduce experienced Access users to the Visual Basic for Applications (VBA) programming language. It will show how to use VBA to extend the capabilities of Access forms, and how to use detain Access database files from other Office applications.All the Open Scheduled VBA courses delivered by PPI Learning Services are suitable for all delegates no matter what version of Office they are working with in their own company's environment. We have chosen the middle ground as the delivery mechanism; so all VBA course will be delivered using Office 2000. If a specific version of VBA is required, then a private VBA course will need to be arranged with the PPI Learning Services Sales Executive.Course content
- The Visual Basic programming environment in Access, when to useVBArather than macros, the object browser.
- The Visual Basic editor, Visual Basic modules, editor options, editor views.
- The concepts of object-oriented programming, Visual Basic syntax.
- The structure of procedures, the declaration section, comments, keywords, indenting code, navigating code using the keyboard, bookmarks, the last position command, getting assistance from the editor when entering code.
- Declaring variables, variable scope, variable type, type conversion functions, constants, arrays.
- Control structures
- The with statement
- If statements
- Select Case
- Do Loop
- For Next Loops
- User interaction
- The MsgBox statement
- The InputBox function
- Pausing code execution, locating errors in code, handling run-time errors, setting bookmarks, setting breakpoints, tracing the execution path using the call stack, setting watches.
- Viewing variable and array values in break mode, compiling program code.
- Manipulating record sets withVBA, finding records in a recordset, creating and deleting tables or queries withVBA.
- Using ActiveX data objects (ado) to open and work with databases from other office programs such as Word or Excel.