0800 282 353 or +44 1372 364610
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
  • Customise applications by dynamically setting properties and executing methods
  • Assemble expressions into VBA statements using variables and intrinsic functions
  • Control programme flow with loops and decision-making logic
  • Apply Data Access Objects (DAO) to incorporate business rules

Course Benefits

Getting the most out of your organisation'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 customise 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

  • 209 VBA Programming Comprehensive Introduction
  • 131 SQL Server 2005 Comprehensive Introduction
  • 382 Relational Database Design
  • 315 Developing User Requirements
  • 419 C# Programming
  • 511 .NET Best Practices and Design Patterns
  • 296 Project Management: Skills for Success

 
Access is a trademark of Microsoft Corporation.
   Building Applications with Access 2007

Upcoming Dates

2 - 5 Sep, 2008
London
18 - 21 Nov, 2008
London
3 - 6 Feb, 2009
London
14 - 17 Apr, 2009
London
30 Jun - 3 Jul, 2009
London

For complete schedule, please visit www.learningtree.co.uk
 
http://www.learningtree.co.uk/courses/uk971.htm
 
 
0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

Building Applications with Access™ 2007: Hands-On

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

Automating Access with Macros

Designing complex macros

  • Creating decision-making macros
  • Implementing organisational techniques for macros
  • Incorporating temporary variables
  • Interfacing with the user

Maximising 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
  • Cancelling 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
  • Utilising domain aggregate functions
  • Integrating symbolic and intrinsic constants

Controlling Programme 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

Optimising 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 parameterised 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

  • Customising the ribbon
  • Configuring start-up options
  • Creating and controlling ribbons in Access
  • Locking down the database
 
http://www.learningtree.co.uk/courses/uk971.htm
 
 
0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

Building Applications with Access™ 2007: Hands-On Tuition

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

Course 971 Tuition

£ 1,695Standard Tuition
Tuition with a Savings Plan
£ 98010-Day Training Pass
£ 915Flex-Training Pass
£ 1,46010-Training Vouchers
£ 1,5605-Training Vouchers
£ 1,525Alumni Gold Tuition

Your Course Fee Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Lunch
  • Course Completion Certificate
  • FREE participation in the Learning Tree Professional Certification Programmes (including related exams)
  
 

Tuition Savings Plans

Flex-Training Pass
  • 3 Courses for £2 750
  • As little as £915
  • Savings as much as 50%
  • 3 courses in 24 months
10-Day Training Pass
  • Save as much as £770 per course
  • Any combination of courses
  • Only £2,450
Training Vouchers
  • Save as much as £535 per course
  • Fully transferable
  • As low as £1,460 per course
Alumni Gold Discount Attend your first course and you will receive a personalised Alumni Gold Discount card, entitling you to save as much as £200 on each course you take in the following 24 months. Take just one course every two years, and you will be entitled to ongoing discounts...year after year. You save 10%.
* Exact savings may vary depending on courses selected.

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 fee.

Enrolling is Easy and Flexible!

Enrol 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.co.uk/courses/uk971.htm