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

Building Applications with Access 2007: Hands-On

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

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

Related Courses

 
Access is a trademark of Microsoft Corporation. 		 

Upcoming Dates

Feb 24 - 27, 2009
 New York
Mar 10 - 13, 2009
 Washington, DC (Rockville, MD)
Mar 24 - 27, 2009
 Ottawa
Mar 31 - Apr 3, 2009
 Toronto
Jul 21 - 24, 2009
 Ottawa
Jul 28 - 31, 2009
 Toronto

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

Building Applications with Access 2007: Hands-On

 
Course: 971   Type: Hands-On Training   Duration: 4 Days
 
 
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
 
http://www.lerningtree.com/courses/971pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Building Applications with Access 2007: Hands-On Tuition

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

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,625 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 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,670 per course
  • Savings as much as 45%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,625 per course
  • Save as much as 45%
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,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 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 $305 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.lerningtree.com/courses/971pf.htm