Level 3 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.
MS Access Training Prerequisites
Programming in MS Access – Level 2.
MS Access Training Audience
Computer users needing to work in Microsoft Access 2002/2003.
MS Access Training Course Duration
3 Days
MS Access Training Course outline
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