|
|
1-800-THE-TREE (1-800-843-8733)
|
|
|
 |
|
Programming Access™ 2003: Hands-OnBuilding 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
Course 377 Content
- Creating decision-making macros
- Advantages and disadvantages of macros
- Converting macros to VBA
- Navigating the Project Explorer
- Editing code with the Code Window
- Binding macros to event properties
- Building events with wizards
- Applying IntelliSense tools
- Exploiting coding techniques
- Identifying the order of events
- Assigning requirements to events
- Methods
- Properties
- Events
- Accessing and using individual objects
- Applying the Access Object Model
- 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
- Finding objects
- Object libraries
- Locating methods, properties and events
- Gateway into the Help system
- Naming rules and conventions
- Declaring objects
- Implicit and explicit conversions
- The scope and life of variables
- Date, string and file system functions
- Integrating symbolic and intrinsic constants
- Creating decision-making logic
- Building iteration statements
- Queries and the Immediate If (IIf)
- Populating fixed and dynamic arrays
- Arguments
- Calling
- MsgBox
- Returning values
- Defining comparative statements
- Constructing relational expressions
- Manipulating data using Recordsets
- Building and modifying QueryDefs
- Populating parameter queries
- Bound and unbound forms and controls
- Changing data sources within code
- Executing SQL statements
- Utilizing pass-through queries
- Binding ADO Recordsets to forms
- Early vs. late binding
- Controlling external applications
- Classifying errors
- Working with the Err object
- Managing runtime errors
- Testing and validating code
- Troubleshooting logic issues
|
Related Courses
Visual Basic is a registered trademark of Microsoft Corporation. Access is a trademark of Microsoft Corporation.
|
|
|
|
|
|
|
Print Friendly
E-mail a Colleague
Course FAQ
Course PDF
Home
