 |
Customer Service or Enrol: 0800 282 353 or +44 1372 364610 |
 |
|
 |
| |
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
Course Content
- Creating decision-making macros
- Implementing organisational techniques for macros
- Incorporating temporary variables
- Interfacing with the user
- Trapping macro errors
- Mastering event driven programming
- Binding macros to event properties
- Identifying limitations of macros
- Converting macros to VBA
- Exploring the DoCmd
- Navigating the Project Explorer
- Writing code with IntelliSense
- Troubleshooting code with debugging techniques
- Methods
- Properties
- Events
- Communicating with individual 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
- Identifying the order of events
- Assigning requirements to events
- Cancelling the event sequence
- Finding objects
- Object libraries
- Locating methods, properties and events
- Gateway into the Help system
- Naming rules and conventions
- Declaring objects
- Implicit vs. explicit data type conversions
- Specifying the scope and life of variables
- Date, string and file system functions
- Utilising domain aggregate functions
- Integrating symbolic and intrinsic constants
- Creating decision-making logic
- Building iteration statements
- Queries and the Immediate If (IIf)
- Developing comparative statements
- Designing relational expressions
- Defining procedures with arguments
- Returning values with functions
- Executing action SQL statements
- Retrieving data into Recordsets
- Building and modifying parameterised queries
- Interacting with unbound controls
- Changing data sources within code
- Classifying errors
- Working with the Err object
- Logging and error notification
- Creating error handling strategies
- Customising the ribbon
- Configuring start-up options
- Creating and controlling ribbons in Access
- Locking down the database
|
Access is a trademark of Microsoft Corporation.
|
|
|
|
|
| |
| Customer Service or Enrol: 0800 282 353 or +44 1372 364610 |
|
|
Print Friendly
E-mail a Colleague
Course PDF
Course FAQ
Home
