Microsoft Access 2007: Building Applications with microsoft Access

Course Overview

Getting the most out of your organisation's databases can require expanding the abilities 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.

If you have a question about this Microsoft training course, call one of our advisors who will be happy to help answers any queries you may have.

Related Courses

• Microsoft Access 2007: Introduction for Beginners (2 day)
• Microsoft Access 2007: Introduction for Beginners (1 day)
• Microsoft Access 2007: Advanced (1 day)
• Microsoft Access 2007: Level 4 (1 day)
• Microsoft Access 2007: Visual Basic for Applications (VBA)
• Microsoft Access 2007: Intermediate (1 day)
• Microsoft Access 2007: Introduction and Intermediate
• Microsoft Access 2007: Advanced
• Microsoft Access 2007: Intermediate
• Microsoft Access 2007: Introduction for Beginners

Audience

This course benefits those planning to create business solutions with Microsoft Access. Experience with Access at the level of Course 970, " Access 2007 Introduction ", is assumed. Programming experience is recommended, but not required.

Skills Gained

• 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 Outline

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

• Traversing 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 Objects (DAO)

• Executing action SQL statements
• Retrieving data into Recordsets
• Building and modifying parametised queries

Designing intelligent forms

• Interacting with unbound forms and 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