Quick Navigation
Microsoft Access 2007 VBA course
Download PDF version of Access 2007 VBA course outline
Overview
This course enables delegates to get good understanding of the features available in the VBA language to help them on the way to becoming proficient database application developers.
Audience
Delegates planning to create and support customised databases in a business environment.
Course Objectives
At the end of this course, delegates will be able to use VBA to custom build applications.
Prerequisites
This course requires a sound working knowledge of Access including creating tables, queries, forms, reports, relationships and macros. No previous programming experience is necessary. According to the audience’s abilities and requirements the course will be tailored at the trainer’s discretion.
Course Contents (2 days)
- Introduction
- Design – things to think about..
- VBA v Macros
- Converting Macros to VBA Modules
- Visual Basic Editor
- Overview of Menus and Toolbars
- Project Explorer & Object explorer
- Local, Immediate and Watch Windows
- Short cuts
- Programming Basics
- Programming elements & data types
- Objects, Properties and Methods
- Adding comments
- Code Layout
- Location of Code
- Programming Structure/Execution
- Sub and Function Statements
- Decision Code
- If Statements
- Select Case Statement
- Loops - Do; For; For Each
- Handling Events
- to a text box & combo box
- to coordinate events across two forms
- Assigning the OnUndo and the Unload event
procedure for a form - With Statement
- Msgbox and Inputbox
- Variables
- Types of Variables (& constants)
- Using Parameters
- Variable Lifetime and Scope
- Working With Forms
- Dialogue boxes – properties and controls
- Referring to Form Controls
- Form and Control Events
- Controlling Controls
- Using buttons on forms
- Switchboard Forms & objects
- Switchboard Manager
- Creating and using splash screen forms
- Automating splash screens
- Setting label properties
- Displaying a splash screen form on start-up
- Opening a switchboard form after a
splash screen form
- Accessing Data
- Using SQL statements
- Using ActiveX Data Objects (ADO)
to work with other data sets
- Error Handling
- Trapping runtime Errors
- Err Object
- Debugging Techniques
- Finishing It Off
- Customising toolbars
- Applying Macros to command buttons
- Configuring start-up options
- Applying security to the database
- Working with and creating an MDE file