0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

Building Applications with Microsoft Access®: Hands-On

 
Course: 971   Duration: 4 Days
 
 

You Will Learn How To

  • Develop distributable applications with Microsoft Access
  • 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 program flow with loops and decision-making logic
  • Programmatically control data access to incorporate business rules

Course Benefits

Microsoft Access provides the tools to build custom applications that can decrease the time and effort needed to accomplish business objectives. In this course, you gain the skills necessary to expand the capabilities of your applications. Through extensive hands-on exercises, you learn how to develop, integrate and customise Access applications using macros, expressions, VBA and Structured Query Language (SQL).

Who Should Attend

Those planning to create, support and enhance business solutions with Microsoft Access. Experience with Access at the level of Course 970, "Microsoft Access Comprehensive Introduction", is assumed. A basic understanding of any programming language is recommended but not required.

Hands-On Training

Extensive hands-on exercises, centred 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
  • Programmatically manipulating data using VBA
  • Implementing error-handling code

Related Courses

  • 209 VBA Programming 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
  • 137 SQL Server 2008 Comprehensive Introduction
  • 925 SQL Programming Language Introduction

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

Upcoming Dates

Live online classroom training.Attend highlighted events in person or live, online via Learning Tree AnyWareTM.

UK Dates

28 Feb - 2 MarLondon
24-27 JulLondon
15-18 JanLondon

US East Coast Dates

13-16 MarNew York*
29 May - 1 JunWashington, DC*

*New York and Washington, DC Courses – Available online with a run time of 2pm to 9pm BST.

For AnyWare enrolments, please register at least 10 days prior to the start of the course.


For complete schedule, please visit www.learningtree.co.uk
 
http://www.learningtree.co.uk/courses/uk971.htm
 
 
0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

Building Applications with Microsoft Access®: Hands-On

 
Course: 971   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 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

Optimising code for scalability and reuse

  • Defining procedures with arguments
  • Returning values with functions

Manipulating and Managing Data

Data access

  • 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
Productivity through Education®
 
 

Building Applications with Microsoft Access®: Hands-On

 
Course: 971   Duration: 4 Days
 
 
Course Fees
£ 1,925Standard Fee
Fee with a Savings Plan
£ 1,2252-Course Passport
£ 1,0853-Course Passport
£ 1,0004-Course Passport
£ 1,600Voucher 10-Pack

Your Course Fee Entitles You To...

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

Savings Plans

2-Course Passport
  • 2 Courses in 12 months for £2,450
  • As little as £1,225 per course
  • Savings up to 45% per course
3-Course Passport
  • 3 Courses in 24 months for £3,250
  • As little as £1,085 per course
  • Savings up to 50% per course
4-Course Passport
  • 4 Courses in 24 months for £4,000
  • As little as £1,000 per course
  • Savings up to 55% per course
Training Vouchers
  • Save as much as £675 per course
  • Fully transferable
  • As low as £1,600 per course
* 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 enrolment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learningtree.co.uk/courses/uk971.htm