1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Programming Access 2003: Hands-On

Building Database Applications with Access and VBA
 
Course: 377   Type: Hands-On Training   Duration: 4 Days
 
 

You Will Learn How To

  • Develop applications with Microsoft Access 2003 using Visual Basic for Applications (VBA)
  • Identify and populate event properties to satisfy design specifications
  • Modify object properties and invoke object methods to customize applications
  • Create VBA statements using variables and built-in functions
  • Apply Data Access Objects (DAO) to incorporate business rules
  • Integrate Access with external applications through automation

Course Benefits

Microsoft Access users can build applications by maximizing rapid application development techniques and advanced VBA capabilities. In this hands-on course, you gain practical experience programming VBA to build Access solutions. You learn to write and debug code that incorporates business rules with Access objects.

Who Should Attend

Those planning to create business solutions with Microsoft Access 2003 or a prior version of Access. Course 307, "Access 2003 Comprehensive Introduction," or similar experience is assumed. Programming experience is useful, but not required.

Hands-On Training

Throughout this course, extensive hands-on exercises provide you with practical experience programming Access using a variety of tools and techniques. Exercises include:
  • Adapting business requirements into VBA code
  • Exploiting Forms and controls by manipulating properties and executing methods
  • Incorporating logic and iteration statements
  • Programming Data Access Objects to manipulate data at the code level
  • Implementing error-handling code

Related Courses

 
Visual Basic is a registered trademark of Microsoft Corporation. Access is a trademark of Microsoft Corporation. 		 

Upcoming Dates


For complete schedule, please visit www.learningtree.com
 
http://www.learningtree.com/courses/377pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Programming Access 2003: Hands-On

Building Database Applications with Access and VBA
 
Course: 377   Type: Hands-On Training   Duration: 4 Days
 
 
Course 377 Content
 

Access Macros and VBA

The power of macros

  • Creating decision-making macros
  • Advantages and disadvantages of macros
  • Converting macros to VBA

Visual Basic Editor

  • Navigating the Project Explorer
  • Editing code with the Code Window

Event-Driven Programming

Building event procedures

  • Binding macros to event properties
  • Building events with wizards

Improving code readability

  • Applying IntelliSense tools
  • Exploiting coding techniques

Event logic

  • Identifying the order of events
  • Assigning requirements to events

Manipulating Objects

Objects and Object models

  • Methods
  • Properties
  • Events
  • Accessing and using individual objects
  • Applying the Access Object Model

Programming Access objects

  • Application
  • Forms collection
  • Form and report object
  • Controls collection
  • Bang (!) vs. Period (.)
  • Exploiting the ComboBox, ListBox, Option Group and TextBox
  • Writing code with the Me keyword

Object Browser

  • Finding objects
  • Object libraries
  • Locating methods, properties and events
  • Gateway into the Help system

Language Concepts

Creating variables

  • Naming rules and conventions
  • Declaring objects
  • Implicit and explicit conversions
  • The scope and life of variables

Implementing built-in functions

  • Date, string and file system functions
  • Integrating symbolic and intrinsic constants

Total Control with VBA

Controlling execution sequence

  • Creating decision-making logic
  • Building iteration statements
  • Queries and the Immediate If (IIf)
  • Populating fixed and dynamic arrays

Sub and function procedures

  • Arguments
  • Calling
  • MsgBox
  • Returning values

Operators and expressions

  • Defining comparative statements
  • Constructing relational expressions

Data Programming

Data Access Objects (DAO)

  • Manipulating data using Recordsets
  • Building and modifying QueryDefs
  • Populating parameter queries

Verifying Form data

  • Bound and unbound forms and controls
  • Changing data sources within code
  • Executing SQL statements

Advanced Functionality

Communicating with SQL Server

  • Utilizing pass-through queries
  • Binding ADO Recordsets to forms

Automation with Access

  • Early vs. late binding
  • Controlling external applications

Trapping Errors and Debugging

Develop error handling

  • Classifying errors
  • Working with the Err object
  • Managing runtime errors

Exploiting debugging tools

  • Testing and validating code
  • Troubleshooting logic issues
 
http://www.learningtree.com/courses/377pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Programming Access 2003: Hands-On Tuition

Building Database Applications with Access and VBA
 
Course: 377   Type: Hands-On Training   Duration: 4 Days
 
 

Course Tuition
$ 2,650 Standard Tuition
Tuition with a Savings Plan
$ 1,660 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,385 Alumni Gold Discount
$ 2,360 Government Discount
 

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,665 per course
  • Savings as much as 40%
  • Only $4,990
Flex Pass
  • 3 courses in 24 months
  • As little as $1,830 per course
  • Save as much as 35%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,150
Training Vouchers
  • Save as much as $950 per course
  • Fully transferable
  • As low as $2,095 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $295 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learningtree.com/courses/377pf.htm