Advanced Development in Microsoft Access Course

The Course shows you how to move from creating simple applications to creating enterprise-wide, robust applications for multiple users. You’ll learn how to debug and handle errors, how to use ADO to work with data programmatically, how to secure your data with Microsoft Access security, and how to scale up to an Access client/server solution. This course is for computer users needing to work in Microsoft Access 2002/2003.

Topics covered on the 4 day Advanced Development in Microsoft Access course

Mastering Debugging

• Why Do You Need Debugging?
• Getting Started with Debugging
• Stepping Through Code
• Evaluating Expressions
• Tips on Effective Debugging

Taking Advantage of Queries

• Understanding Joins
• Action Queries
• Access SQL

Managing Data with ADO

• Introducing ActiveX Data Objects
• Retrieving Data with ADO
• Searching for Data in a Recordset
• Updating Data with ADO

Using Error Handling to Bullet-Proof Your Code

• Handling Runtime Errors
• The Error Handling Standard
• Taking a Closer Look
• Who Handles Errors?

Designing Multiuser Applications

• Multiuser Architectures
• Locking
• Keeping Recordsets Current
• Transaction Processing

Exploring Replication

• Replication Basics
• Replicating a Database
• Changes Access Makes to a Database When You Replicate It
• Synchronizing Replicas
• Conflict Management
• Partial Replication

Automating Office Applications

• What Is Automation?
• Working with Other Applications
• Example: Building an Excel Chart
• MailMerge with Word
• Access as an Automation Server

Securing Your Applications

• Choosing the Right Security System
• Workgroups
• Users and Groups
• Permissions
• Using the Security Wizard to Properly Secure Your Database

Building Access Data Projects

• Introduction to Access Projects
• Creating a New Project
• Creating SQL Server Tables
• Creating SQL Server Database Diagrams
• Creating SQL Server Views
• Creating SQL Server Stored Procedures

Developing Client/Server Applications with Access

• Introduction to Client/Server
• MDB vs. ADP
• Designing Client/Server Applications
• Designing MDB Client/Server Applications
• Designing ADP Client/Server Applications

Deploying Access Applications

• The Finishing Touches
• Managing VBA Code
• Introducing the Access Runtime Version
• Developing Runtime Applications
• Deploying Access Applications

Appendix A: The Reddick VBA Naming Conventions, Version 6.0

Appendix B: Useful VBA Functions