Microsoft Access is the desktop database design product from the Microsoft Office professional suite. This course teaches experienced Access users about the greater advantages to be gained by combining the built-in features of Access with the programming capabilities of Visual Basic for Applications (VBA).
The course is designed to give delegates a thorough overview of programming within the Access environment, enabling them to improve the functionality of their Access databases, whilst providing a useful introduction to programming, in particular the Visual Basic programming language.
Skills Gained
At the end of the course you will be able to:
- Create macros to automate tasks, as well as understand their limits
- Create macros which carry out different actions according to a condition
- Understand what VBA is
- Understand the Access object model, and make use of its properties, methods and events
- Work with forms to create better user interface
- Declare variables, and manipulate them
- Write code which looks at a condition and carries out different actions accordingly
- Write code which repeats an action a specified number of times
- Write code using built in VBA functions
- Write user defined functions, frequently used pieces of code
- Trap errors, to avoid users seeing problems
- Find problems in your own code
Prerequisites
The course is aimed at those with no previous programming experience, who are looking to develop databases that go beyond what Access alone is capable of.
Delegates must have an excellent working knowledge of Microsoft Access. You must be able to create tables, queries, forms and reports.
Course Outline
Session 1- Macros: Creating basic macros and attaching them to events
Session 2 - Advanced macros: Group and Conditional macros
Session 3 - Introduction to the Object Model
Session 4 - Using the VBA Integrated Development Environment
Session 5 - Collections, Variables and Notation
Session 6 - Message Boxes and Input Boxes
Session 7 - Control Structures I: Branching with if and select case
Session 8 - Control Structures II: Looping with for each, do while and do until
Session 9 - Using built-in VBA functions
Session 10 - Control Structures III: Jumping; creating your own Methods & Functions!
Session 11 - Error trapping and debugging
Session 12 - Workshop and practise time
