1-800-THE-TREE (1-800-843-8733)
 

Building Applications with Access™ 2007: Hands-On

 
Course: 971     Type: Hands-On Training     Duration: 4 Days

Quick Enroll    

You Will Learn How To
  • Develop distributable applications with Microsoft Access 2007
  • Incorporate design requirements to enhance application functionality
  • Customize applications by dynamically setting properties and executing methods
  • Assemble expressions into VBA statements using variables and intrinsic functions
  • Control program flow with loops and decision-making logic
  • Apply Data Access Objects (DAO) to incorporate business rules

Course Benefits
Getting the most out of your organization's databases can require expanding the capabilities of your applications. Microsoft Access 2007 provides the tools to build custom applications for department, workgroup or enterprise-wide use that can decrease the time and effort needed to accomplish business objectives. In this course, you gain the skills necessary to develop, integrate and customize Access applications.

Who Should Attend
Those planning to create and support business solutions with Microsoft Access. Experience with Access at the level of Course 970, "Access 2007 Comprehensive Introduction," is assumed. Programming knowledge is recommended but not required.

Hands-On Training
Extensive hands-on exercises, centered around a single case study, provide you with practical experience programming Access. Exercises include:
  • Adapting business requirements into macros and VBA code
  • Exploiting Forms and controls by manipulating properties and executing methods
  • Empowering your code using built-in functions
  • Incorporating logic and iteration statements
  • Programming Data Access Objects to manipulate data at the code level
  • Implementing error-handling code

Course 971 Content
Automating Access with Macros
Designing complex macros
  • Creating decision-making macros
  • Implementing organizational techniques for macros
  • Incorporating temporary variables
  • Interfacing with the user
Maximizing macro functionality
  • Trapping macro errors
  • Mastering event driven programming
  • Binding macros to event properties
Transitioning to VBA
Beyond the macro object
  • Identifying limitations of macros
  • Converting macros to VBA
  • Exploring the DoCmd
Exploring the Visual Basic Editor
  • Navigating the Project Explorer
  • Writing code with IntelliSense
  • Troubleshooting code with debugging techniques
Programming Access Objects
Negotiating the Object Model
  • Methods
  • Properties
  • Events
  • Communicating with individual objects
Interfacing with 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
Applying event logic
  • Identifying the order of events
  • Assigning requirements to events
  • Canceling the event sequence
Demystifying the Object Browser
  • Finding objects
  • Object libraries
  • Locating methods, properties and events
  • Gateway into the Help system
Constructing VBA Expressions
Working with variables
  • Naming rules and conventions
  • Declaring objects
  • Implicit vs. explicit data type conversions
  • Specifying the scope and life of variables
Implementing built-in functions
  • Date, string and file system functions
  • Utilizing domain aggregate functions
  • Integrating symbolic and intrinsic constants
Controlling Program Execution
Structuring code sequences
  • Creating decision-making logic
  • Building iteration statements
  • Queries and the Immediate If (IIf)
Logical and comparison operators
  • Developing comparative statements
  • Designing relational expressions
Optimizing code for scalability and reuse
  • Defining procedures with arguments
  • Returning values with functions
Manipulating and Managing Data
Data Access Objects (DAO)
  • Executing action SQL statements
  • Retrieving data into Recordsets
  • Building and modifying parameterized queries
Designing intelligent forms
  • Interacting with unbound controls
  • Changing data sources within code
Processing Runtime Errors
  • Classifying errors
  • Working with the Err object
  • Logging and error notification
  • Creating error handling strategies
Getting Ready for Distribution
  • Customizing the ribbon
  • Configuring start-up options
  • Creating and controlling ribbons in Access
  • Locking down the database

Related Courses
Access is a trademark of Microsoft Corporation.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save an EXTRA $200 on a 10-Day Training Pass!

Building Applications with Access™ 2007: Hands-On
Upcoming Dates
Sep 2 - 5, 2008
 Washington, DC (Alexandria, VA)
Nov 4 - 7, 2008
 Chicago (Schaumburg)
Nov 18 - 21, 2008
 Los Angeles
Nov 18 - 21, 2008
 New York
Nov 25 - 28, 2008
 Ottawa
Dec 2 - 5, 2008
 Toronto
Dec 2 - 5, 2008
 Washington, DC (Alexandria, VA)
Dec 9 - 12, 2008
 Washington, DC (Reston, VA)
Feb 10 - 13, 2009
 Chicago (Schaumburg)
Feb 24 - 27, 2009
 New York

Building Applications with Access™ 2007: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,650 Standard Tuition
Tuition with a Savings Plan
$ 1,580 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
 

 

Building Applications with Access™ 2007: Hands-On
Building Applications with Access™ 2007: Hands-On
Participants building a distributable Access application.


Certification Core Course CPE 23 Credits 1 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733