Microsoft Access VBA Programming (Level 4) 2003 2007 2010 2013 2016 & 365
Training
In Newcastle Upon Tyne
Description
-
Type
Training
-
Level
Advanced
-
Location
Newcastle upon tyne
-
Duration
2 Days
-
Start date
Different dates available
Microsoft Access VBA Programming (Level 4) is an advanced training course. Participants will learn how to add Visual Basic coding to add extra functionality to a Microsoft Access database.
Important information
Documents
- Course content
Facilities
Location
Start date
Start date
About this course
This course is intended for participants who have a thorough knowledge of Microsoft Access.
Certificate of participation can be obtained if required.
On receiving your request we will contact you to explain course content, including course dates and payment options.
Reviews
Subjects
- Microsoft Access
- VBA Programming in Access
- Programming
- Microsoft Access VBA Modules
- Visual Basic Applications
- Access Forms
- MS Access Message Box Function
- Looping Commands
- Access Programming
- Programming Techniques
Teachers and trainers (1)
Chris Edmondson
IT Trainer
Course programme
Course review:
1 VBA Development Environment
- When to use VBA
- Options
- Navigation
2 Creating Modules, Functions and Sub-routines
- New Modules
- Creating a Function or Procedure
- Passing Arguments and Returning values
3 Using Variables and Expressions
- Naming Conventions
- Declarations
- Assigning Values
4 Declaring Variables and Data Types
- Dimension Statement
- Data Types
5 Branching and Looping commands
- Indenting Code
- If … Then
- Select Case
- For … Next
- Do … Loop
6 Arguments
- Named and Optional
7 “Bugs"
- Types of Error
- Syntax or Logical
- Debug Window
- Breakpoints
- Using Message Boxes
8 Example Functions
- Text Functions
- Date Examples
9 Event Procedures on Forms
- Using the Builder
- Form Events and Properties
- Form Modules
- Validation Procedures
10 Writing Event Procedures
- Bespoke Functions
- Changing Controls
11 Trapping Errors
- On Error
- Error Codes
12 Manipulating Record Sets
- Opening Databases
- Recordset Objects
- Manipulating Data
- Finding Data
- Modifying Queries
Microsoft Access VBA Programming (Level 4) 2003 2007 2010 2013 2016 & 365