Microsoft Access Developer Course – VBA in Access Part 1 – Automation

Is it right for me?

Our VBA in Access Part 1 course is designed for existing experienced users of Access who need to use VBA to automate their databases.

You must be able to confidently create fully relational databases including tables, forms, reports and queries before attending this course. Previous programming experience would be an advantage.

What will I get out of it?

By the end of the course you will be able to:

• Write your own code for use on command buttons, forms and reports
• Set up user messages
• Use the debug tools
• Write error handling routines and edit Access error messages
• Write your own functions, e.g. conversion functions, date functions

Versions available

2003, 2007, 2010

Related courses in our range

• VBA in Access Part 2 - Access Objects and DAO
• SQL Foundation
• Access Query Writing
• Access Advanced Forms and Interfaces

What does it cover?

Objects/properties/events/methods

• Different events
• Form events
• Control events
• Report events
• Attaching code

The Visual Basic environment

• Steps to creating a VBA procedure
• Class modules
• Procedures
• Adding command buttons

Object properties

• Object properties
• Setting properties at design time
• Setting properties at run time
• Using WITH

Event Procedures

• Writing event procedures
• Code structure
• Adding comments

Setting keyboard events

• Using KeyUp and KeyDown events

Statements and functions

• Writing statements and functions
• Input boxes
• Message boxes

Variables

• Creating variables
• Naming conventions
• Data types
• Declaring more than one variable
• Concatenation
• Scope of variables

Constants

• Declaring and using constants
• Scope of constants

Debugging

• Errors
• Compiling
• Setting breakpoints
• Working in break mode
• Debug tools

VB error handling

• Writing error handling routines

Access error handling

• Replacing standard error messages

Conditional statements

• IF statement
• SELECT CASE statement
• Tests

General procedures

• Scope of procedures
• Calling procedures
• Sub procedures
• Standard modules

Function procedures

• Creating functions
• Parameters or arguments
• Optional arguments
• Default values