Access 2000 VBA

Target Audience

Experienced users of Access who need to develop and enhance their expertise. In particular, delegates should be confident with the fundamental techniques of Access and have a thorough knowledge of commands and functions. Although not essential a programming background would be advantageous.

Pre-requisites

To fully benefit from this course, attendees are expected to be experienced and confident Access 2003 developers and be familiar with the topics covered in the Access Creating Databases and Power User courses.

On completion of the course, delegates will be able to:

• Understand some of the aspects of developing applications in Access
• Create and assign macros
• Understand the advantages and disadvantages of using macros
• Understand the programming environment
• Understand how forms and modules are used
• Create and work with subroutines and function procedures
• Create and work with 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
• Use the DoCmd object to perform most database operations
• Use DAO to handle working with data in your programs
• Use the debugging features of VBA to locate and identify errors
• Develop safeguards in your program and prevent unforeseen errors

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/Assigning Macros • Creating more Complex Macros • Converting Macros to VBA Code • Why you shouldn't use Macros

VBA Essentials

The Role of Forms • Creating a Startup Form • Understanding Modules • Code Behind Forms • Standard Code Modules • Standard vs Class Modules

VBA Subroutines

Understanding Modules in Access • The Anatomy of a Module • Creating a Subroutine • Creating a Function • Calling Procedures • Passing Parameters • Returning Values • Scoping Procedures

Variable VBA

Overview of Variables • 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 of 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

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

Data Access Objects

Creating a Table with DAO • Removing a Table using DAO • Populating a Table using DAO • Populating a Form using DAO • Dealing with an Empty Table • Navigating 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/Deleting a Watch

Handling Errors in VBA

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

You may also be interested in some of the following related courses below:

Microsoft - Access 2000 - Queries & Reports
Microsoft - Access 2000 - Creating Databases
Microsoft - Access 2000 - Power User
Microsoft - Excel 2000 - VBA

Send this course to a friend
 

Course Fee

We have a rolling programme of Scheduled Public sessions for the majority of standard courses – both in IT Productivity and Management & Soft Skills. Group sizes are limited to ensure optimum learning amongst delegates.

Passport Saving Plans

The advertised rates are on a per delegate basis, however if you have more than one attendee you may be entitled to a discount. To maximise your training budget why not email or contact one of our training consultants to see what rates/discounts may apply for your particular requirement.

Alternatively, if you have regular, ongoing training requirements, you may find one of our Training Passports of interest. Each is designed to provide our clients with significant benefits:
• Far better discounts
• Less administrative overhead
• Better control of your training schedules

Scheduled Training Passports
Enables you to pre-purchase training places on any of our standard scheduled courses.

Private Training Passports
Enables you to pre-purchase private training days against any of our standard courses.

Each of the above passports come with substantial discounts.

To maximise your training budget why not email or contact one of our training consultants who will be happy to provide you with the latest offers on any of our Training Passports. See what rates/discounts may apply for your particular requirement.

Please fill out the form below for more details:

First Name
Last Name
Job Title
Company
Office Telephone
E-mail
Brief Details	Characters Left.