Duration
3 days
Outline
Introduction to VBA
- Review of Microsoft Access’s Components
- Visual Basic Editor
- View Menu
- Visual Basic Editor Components
- Understanding Visual Basic Windows
- Project Explorer
- Properties Window
- Code Window
- Immediate Window
- Where do you code your VBA programs?
- What is the difference between Standard & Class Modules
- Understanding VBA Procedures
- Sub .. End sub Procedure
- Procedures Scope
- Function .. End Function Procedure
- Debugging Your Code
- Considering Types of Program Errors
- Debugging Tools
Creating a Simple VBA Program
- Creating a Standard Module
- Creating a Procedure
- Understanding Syntax
- Getting keyword help
- Information about arguments
- About named arguments
Microsoft Access Object Model
- Understanding Object Models
- Understanding properties and methods
- Properties
- Methods
- Events
Controlling Forms with VBA
- Displaying Custom Messages
- Displaying a message box
- DoCmd Object
- Using the DoCmd Object
- Form Object
- Using the Form Object
- Control Object
- Using the Control Object
Exploring the VB Language
- Storing Information in Variables
- Data Type Summary
- Making Decisions
- Select…Case Statement
- Repeating Actions with a Loop
- Other VBA Structures
- Comments
- Line Continuation
More Access Objects
- Add a Value to a Bound Combo Box
- ListBox Object
- ListBox.AddItem Method
- Option Group Control
Handling Run-Time Errors in VBA
- Errors and Error Handling
- Routing Execution When an Error Occurs
- The On Error Statement
- The Resume Statement
- Exiting a Procedure
- Handling Errors in Nested Procedures
- Getting Information About an Error
- The Err Object
- The Error Object and Errors Collection
- The AccessError Method
- The Error Event
Using DAO to Access Data
- Data Access Objects
- Referring to DAO Objects
- How to: Create a DAO Recordset From a Table In the Current Database
- How to: Create a DAO Recordset From a Form
- How to: Extract Data from a Record in a DAO Recordset
- How to: Move Through a DAO Recordset
- Building SQL Statements with DAO
Customizing Database UI and Setting Options
- Set Startup Properties and Options in Code
- How to: Hide the Ribbon When Access Starts
Database Security
- Security for the ACCDB File Format
- Securing VBA Code in ACCDB
- Locking the VBA Project
- Password Protecting the VBA Project
- Removing Password from the VBA Project
Programme scope, delivery arrangements and suitability are confirmed during enquiry.