in
f
Sign Up for eNews
- First Name
- Last Name
- Email Address
- Nearest Training Location
- Interested In: Microsoft Office Professional Development Adobe Scheduled Courses In-house/Customised Training

Items 0

Total $0.00

Select Courses

Odyssey Training is a national provider of professional, computer and management training and consultancy.

VBA for Microsoft Access 2007

Duration
2 Days
Downloads
Practice Files
Meals Provided
Lunch and refresments
Print-Friendly
Print this page
Delivery Methods
In-house, Closed Group
Skills Assessment
Take the test

Expected Outcomes

Create and assign macros and understand the advantages and disadvantages of using macros
Understand the programming environment and how forms and modules are used
Create and work with subroutines, function procedures and variables
Communicate with the user through input boxes and message boxes
Program decision structures using IF and CASE statements
Develop a variety of programming loops for repeating operations

Prerequisites

This course is designed for people with little or no knowledge of VBA. However, an advanced working knowledge of Microsoft Access is essential.

Who Should Attend this Course

This course is designed for people who would like to improve their skills in the use of Visual Basic for Applications in Access to increase productivity by using automation.

Topics Covered [Click to Show All]

Development Basics
Access Development Environment
Splitting Databases
Maintaining Links
Using the Database Splitter
Queries for Reports and Forms
Access Run-Time
Understanding Client/Server Macros and VBA
Creating & Assigning Macros
More Complex Macros
Converting Macros to VBA VBA Essentials
Creating A Startup Form
Understanding Modules
Code behind Forms
Standard Code Modules
Standard vs Class Modules
Naming Conventions VBA Subroutines
The Anatomy of a Module
Creating a Subroutine
Creating a Function
Calling Procedures
Passing Parameters
Returning Values
Scoping Procedures Variable VBA
Creating String Variables
Option Explicit
Working with Numbers
Dealing with Overflows
Working with Decimals and Dates
Default Values
Scoping Variables
Local Variables
Module-Wide Variables
Passing Parameters
Passing Parameters by Value Interactive VBA
The Act of Communicating
Creating a Simple Input Box
Creating Elaborate Input Boxes
Global Positioning
Simple Message Boxes
Creating Larger Messages
Breaking a Message Line
Customise Icons and Buttons
Message Box Functions
Responding to Different Buttons Decisive VBA
Creating an In-Line If
Creating a Block If
Multiple If
Multiple If Using Text
Using Case Statements
Value Ranges in Case Statements
Case Statements with OR
Asking Yes/No Questions Looping VBA
Program Loops
Creating a While and an Until Loop
Taking Care of Counters
Exiting from Loops / For Next Loops The DoCmd Object
Navigating with DoCmd
Moving through Records
Filtering Records with DoCmd
Opening a Form or Report with DoCmd
Closing a Form
Creating Variable Reports ActiveX Data Objects
Creating / Removing / Populating a Table ADO
Populating a Form ADO
Dealing with Empty Table
Navigating a Form
Finding a Record
Updating a Record
Deleting a Record
Adding a New Record Debugging VBA
Setting a BreakPoint
Additional Breakpoints
Stepping Through Procedure
Viewing the Call Stack
Using the Locals and Immediate Windows
Adding a Watch
Deleting a Watch Handling Errors In VBA
Error Handling Overview
Understanding Common Errors
Creating Simple Error Handler
Understanding Object Model
More Elegant Error Handling
Resuming from Errors
Forcing an Error
Creating Custom Errors The DoCmd Object
Navigating with DoCmd
Moving through Records
Filtering Records with DoCmd
Opening a Form or Report with DoCmd
Closing a Form
Creating Variable Reports

ActiveX Data Objects
Creating / Removing / Populating a Table ADO
Populating a Form ADO
Dealing with Empty Table
Navigating a Form
Finding a Record
Updating a Record
Deleting a Record
Adding a New Record

Debugging VBA
Setting a BreakPoint
Additional Breakpoints
Stepping Through Procedure
Viewing the Call Stack
Using the Locals and Immediate Windows
Adding a Watch
Deleting a Watch

Handling Errors In VBA
Error Handling Overview
Understanding Common Errors
Creating Simple Error Handler
Understanding Object Model
More Elegant Error Handling
Resuming from Errors
Forcing an Error
Creating Custom Errors

Computer Training

Microsoft Office 2010

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2010	Microsoft Access 2010 Introduction	Microsoft Access 2010 Intermediate	Microsoft Access 2010 Advanced	VBA for Microsoft Access 2010
Microsoft Excel 2010	Microsoft Excel 2010 Introduction	Microsoft Excel 2010 Intermediate	Microsoft Excel 2010 Advanced	VBA for Microsoft Excel 2010
Office 2010 New Features	Microsoft Office 2010 New Features
Microsoft Outlook 2010	Microsoft Outlook 2010 Introduction		Microsoft Outlook 2010 Advanced
Microsoft Powerpoint 2010	Microsoft PowerPoint 2010 Introduction		Microsoft PowerPoint 2010 Advanced
Microsoft Project 2010	Microsoft Project 2010 Introduction		Microsoft Project 2010 Advanced
Microsoft Visio Professional 2010	Microsoft Visio 2010 Professional Introduction		Microsoft Visio 2010 Professional Advanced
Microsoft Word 2010	Microsoft Word 2010 Introduction	Microsoft Word 2010 Intermediate	Microsoft Word 2010 Advanced	VBA for Microsoft Word 2010
Introduction to Computers	Introduction to Computers

Microsoft Office 2007

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2007	Microsoft Access 2007 Introduction	Microsoft Access 2007 Intermediate	Microsoft Access 2007 Advanced	VBA for Microsoft Access 2007
Microsoft Excel 2007	Microsoft Excel 2007 Introduction	Microsoft Excel 2007 Intermediate	Microsoft Excel 2007 Advanced	VBA for Microsoft Excel 2007
Office 2007 New Features	Microsoft Office 2007 New Features
Microsoft Outlook 2007	Microsoft Outlook 2007 Introduction		Microsoft Outlook 2007 Advanced
Microsoft Powerpoint 2007	Microsoft PowerPoint 2007 Introduction		Microsoft PowerPoint 2007 Advanced
Microsoft Project 2007	Microsoft Project 2007 Introduction		Microsoft Project 2007 Advanced
Microsoft Visio Professional 2007	Microsoft Visio 2007 Introduction		Microsoft Visio 2007 Professional Advanced
Microsoft Word 2007	Microsoft Word 2007 Introduction	Microsoft Word 2007 Intermediate	Microsoft Word 2007 Advanced	VBA for Microsoft Word 2007

Microsoft Office 2003

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2003	Microsoft Access 2003 Introduction	Microsoft Access 2003 Intermediate	Microsoft Access 2003 Advanced	VBA for Microsoft Access 2003
Microsoft Excel 2003	Microsoft Excel 2003 Introduction	Microsoft Excel 2003 Intermediate	Microsoft Excel 2003 Advanced	VBA for Microsoft Excel 2003
Microsoft Outlook 2003	Microsoft Outlook 2003 Introduction		Microsoft Outlook 2003 Advanced
Microsoft Powerpoint 2003	Microsoft PowerPoint 2003 Introduction		Microsoft PowerPoint 2003 Advanced
Microsoft Project 2003	Microsoft Project 2003 Introduction		Microsoft Project 2003 Advanced
Microsoft Visio Professional 2003	Microsoft Visio 2003 Introduction		Microsoft Visio 2003 Advanced
Microsoft Word 2003	Microsoft Word 2003 Introduction	Microsoft Word 2003 Intermediate	Microsoft Word 2003 Advanced	VBA for Microsoft Word 2003

Microsoft Sharepoint 2010

Adobe Publishing and Web

	Introduction	Advanced
Adobe Acrobat 9.0	Adobe Acrobat 9.0 Introduction	Adobe Acrobat 9.0 Advanced
Adobe Acrobat X	Adobe Acrobat X Introduction	Adobe Acrobat X Advanced
Adobe Captivate 5	Adobe Captivate Introduction
Adobe Dreamweaver CS4	Adobe Dreamweaver CS4 Introduction
Adobe Dreamweaver CS5	Adobe Dreamweaver CS5 Introduction
Adobe Illustrator CS4	Adobe Illustrator CS4 Introduction
Adobe Illustrator CS5	Adobe Illustrator CS5 Introduction
Adobe InDesign CS4	Adobe InDesign CS4 Introduction	Adobe InDesign CS4 Advanced
Adobe InDesign CS5	Adobe InDesign CS5 Introduction	Adobe InDesign CS5 Advanced
Adobe Photoshop CS4	Adobe Photoshop CS4 Introduction	Adobe Photoshop CS4 Advanced
Adobe Photoshop CS5	Adobe Photoshop CS5 Introduction	Adobe Photoshop CS5 Advanced

“Excellent presenter. Very helpful and content was explained well. More than met my expectations.”
Carmel – Governance Officer

Copyright
Privacy
Collection Statement

Microsoft Certified Silver Learning Partner Odyssey Training is a national Australian provider of professional, technical and management training and consultancy. We run customised training and scheduled training courses in Brisbane, Cairns, Melbourne, Sydney and Townsville. We have been a major outsource partner for local and national projects across the private and public sectors. Quality Assurance System conforming to AS/NZS ISO 9001:2008 (Certification no. 1075). Odyssey Training is also a signatory to the Government’s Information Technology Conditions v5 (GITC v5) – Q-953.

Training Schedules

Partnering with employers across Australia. Training your people, bringing out their best!

Experience that speaks for itself.

Build your team, your way!

We are an Australian training company, developing Australia’s professionals.

VBA for Microsoft Access 2007

Related Courses

Duration

Downloads

Meals Provided

Print-Friendly

Delivery Methods

Skills Assessment

Expected Outcomes

Prerequisites

Who Should Attend this Course

Topics Covered [Click to Show All]

Training Courses