|
|
|
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
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
|
<< Back to Excel, Office and Access
Related Courses
Access is a registered trademark of Microsoft Corporation.
|
|
Course Dates
UK Dates | | 28 Feb - 2 Mar | London enrol | | 24-27 Jul | London enrol | | 15-18 Jan | London enrol | US East Coast Dates | | 13-16 Mar | New York enrol* | | 29 May - 1 Jun | Washington, DC enrol* |
*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.
More Dates and Locations.
|
|
|
|
On-Site &
Custom Training
Bring this or any Learning Tree course to your location or have it customised for your organisation.
|
Participants building a distributable Access application.
|
|
Average Attendee Evaluation
|
Evaluations in the last 12 months |
|
5 stars:
|
|
70% |
|
4 stars:
|
|
23% |
|
3 stars:
|
|
7% |
|
2 stars:
|
|
0% |
|
1 star:
|
|
0% |
|
"Learning Tree does a really good job of providing worthwhile hands-on exercises. Some similar exercises other training providers used were pointless because they simply weren't practical. With Learning Tree, you come away feeling it was a really positive and useful experience".
– G. Steindl
Minitab, Inc.
|
|
 |
|
E-mail 
Print 
Q&A 
PDF 
Facebook 
Twitter
