Microsoft Access 2002 2003: Advanced Development in Microsoft Access

Show more Microsoft Training Courses

About this class

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 training may be available onsite; please contact us if you are interested.

Who will the lesson benefit?

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

Contents of this class

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

Microsoft Access 2002 2003: Advanced Development in Microsoft Access / cm76218

(C) AquinasTraining.co.uk - Contact Us