Application Overview:
Microsoft Access
Microsoft Access is a relational database management system which combines the relational Microsoft Jet Database Engine with a graphical user interface. Access can use data stored in Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant data container. You can create a macro which is an action or set of actions that you can use to automate tasks. to perform a specific action. Microsoft Access lets you also create a macro group which is a collection of related macros that are stored together under a single macro name to perform a series of actions. The collection is often referred to simply as a macro.
Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create robust databases that can be searched, sorted, analysed, reported, updated and shared with other users.
Microsoft Office 2007-2010 Training Courses
Microsoft Access 07/10
Introduction
Microsoft Access 07/10
Intermediate
Microsoft Access 07/10
Macros
Microsoft Access VBA
Introduction
Microsoft Excel 07/10
Introduction
Microsoft Excel 07/10
Intermediate/Advanced
Microsoft Excel 07/10
Formulas and Functions
Microsoft Excel 07/10
Macros
Microsoft Excel 2007
Upgrade
Microsoft Excel 2010
Upgrade
Microsoft Office 2010
Upgrade
Microsoft OneNote 07/10
Introduction 
Microsoft Outlook 2007
Introduction/Intermediate
Microsoft Outlook 2010
Introduction/Intermediate
Microsoft PowerPoint 07/10
Introduction
Microsoft PowerPoint 2007
Intermediate/Advanced
Microsoft PowerPoint 2010
Intermediate/Advanced
Microsoft PowerPoint 2007
Upgrade
Microsoft PowerPoint 2010
Upgrade
Microsoft Project 2007
Introduction
Microsoft Project 2007
Intermediate
Microsoft Project 2010
Introduction
Microsoft Project 2010
Intermediate
Microsoft Publisher 2007
Introduction
Microsoft SharePoint 2007
Introduction
Microsoft SharePoint 2010
Introduction
Microsoft SharePoint 2010
Upgrade
Microsoft Visio 2007
Introduction
Microsoft Visio 2010
Introduction
Microsoft Word 07/10
Introduction
Microsoft Word 07/10
Intermediate/Advanced
Microsoft Word 07/10
Styles and Forms
Microsoft Word 2007
Upgrade
Microsoft Word 2010
Upgrade
Microsoft Access VBA
Visual Basic 2007/2010
Introduction
Course Information
Duration: Two-Day Course
Platform: Windows Only
Fee: $645 CDN (+HST)
This class is limited to eight people.
Course Overview
This two day, hands on course will provide you with the basic understanding of Microsoft Access Visual Basic. You'll learn to create sub procedures to automate data in Access forms.
Course Content
- Visual Basic Windows
- Editor Options
- Viewing the code
- Access Visual Basic Objects
- Object Properties
- Access VBA Constants
- Programmatically Accessing object Properties
- Types of Properties
- Methods of an Object
- Messages and Events of Objects
- Events
- Variables and Data Types
- Operators and Operands
- Indentation in the code window importance
- Visual Basic Operators
- Comments
- The Edit Toolbar
- Carriage Return-Line Feed (vbCrLf) & vbNewLine
- Introduction to Procedures
- Comparison Operators
- Visual Basic Conversion Functions
- Conditional statements:
- If, If Then, If Then Else, If Then, ElseIf
- Case Else
- Message Boxes
- Input Boxes
- Loops in Access VBA
- Do ...Loops
- For ...Next
- For ... Each
- Error Handling (Time Permitting)
- Debugging and the Immediate Window
- Properties for a VBA Project
- Project Name
- Project Protection
- Display Options
(PDF 55 kb)