Microsoft Access 2002 2003: Advanced Development in Microsoft Access

Course Overview

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.

All of our Microsoft delivery partners providers and specialist Microsoft trainers have met our tough rigorous guidelines and we constantly monitor the quality of our Microsoft training to ensure that your needs are met and only the highest quality Microsoft courses are provided.

Related Courses

• Microsoft Access 2003: Introduction for Beginners (1 day)
• Microsoft Access 2003: Advanced (1 day)
• Microsoft Access 2003: Introduction for Beginners (2 day)
• Microsoft Access 2003: Advanced (2 day)
• Microsoft Access 2003: Visual Basic Applications (VBA)
• Microsoft Access 2003: Visual Basic Applications (VBA)
• Microsoft Access 2003: Intermediate (1 day)
• Microsoft Access 2003: Intermediate (2 day)
• Microsoft Access 2003: Programming with VBA

Audience

This course is for computer users needing to work in Microsoft Access 2002/2003.

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