Programming in VBA using Access

ELECTUS
Adelaide, SA, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This 3 day program aims to increase your productivity by providing the skills and knowledge to program VBA in Access effectively.


Development Basics

· The Access Development Environment

· The Importance of Splitting Databases

· Maintaining Links

· Using The Database Splitter

· Using Queries for Reports and Forms

· Access Run-Time

· Understanding Client/Server

Macros And VBA

· Creating Macros

· Assigning Macros

· Creating More Complex Macros

· Converting Macros to VBA Code

· Why you shouldn’t use Macros

VBA Essentials

· Creating a Startup Form

· Understanding Modules

· Code Behind Forms

· Standard Code Modules

· Standard Vs Class Modules

· Naming Conventions

VBA Subroutines

· Understanding Modules

· 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

· Working With Dates

· Default Values

· Scoping Variables

· Local Variables

· Module-Wide Variables

· Passing Parameters

· Passing Parameters By Value
Interactive VBA

· The Act o Communicating

· Creating a Simple Input Box

· Creating More Elaborate Input Boxes

· Global Positioning

· Simple Message Boxes

· Creating Larger Messages

· Breaking a Message Line

· Customising Icons and Buttons

· Message Box Functions

· Responding to Different Buttons

Decisive VBA

· Decisions Overview

· 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 Loop

· Taking Care of Counters

· Creating an Until Loop

· For Each Loops

· Exiting From Loops

· For Next Loops

The DoCmd Object

· Navigating with DoCmd

· Moving Through Records

· Filtering Records with DoCmd

· Opening a Form with DoCmd

· Opening a Report with DoCmd

· Closing a Form

· Creating Variable Reports


ActiveX Data Objects - Tables

· Setting References using VBA

· Creating a Table with ADO

· Removing a Table using ADO

· Populating a Form using ADO

· Dealing with an Empty Table

ADO Forms & Recordsets

· Navigating Records in a Form

· Finding a Record

· Updating a Record

· Deleting a Record

· Adding a New Record

Debugging VBA

· Setting a BreakPoint

· Setting Additional Breakpoints

· Stepping Through a 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 a Simple Error Handler

· Understanding the Error Object Model

· More Elegant Error Handling

· Resuming from Errors

· Forcing an Error

· Creating Custom Errors

...''

Phone:08 8221 5517

School Address:

37 Angas St
Adelaide SA 5000

Jobs & Resumes: Adelaide
Houses & Roommates: Adelaide

Premiere 6.5 Advanced
Project 2003 Advanced
Project 2003
Publisher 2003
Visio 2003 Professional Advanced
Visio 2003 Professional
Flash MX 2004 Advanced
Flash MX 2004
HTML
HTML/CSS Advanced
Programming in VBA using Excel
Programming in VBA Using Word
Visual Basic
Certificate III in Business Administration
Certificate IV in Business Administration
Excel Formulas and Functions
Excel Pivot Tables & Filtering
Access Query and Reports

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.