Advanced Development in Microsoft Access Course

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