Microsoft Access 2000, Level 3

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 

Level 3

Cost: $599 + GST

Set of 6 CD's

All 3 levels
Cost: $1395 + GST

Set of 15 CD's

data programmatically, how to secure your data with Microsoft Access security, and how to scale up to an Access client/server solution

CD-ROM 10

Mastering Debugging
18.1 Why Do You Need Debugging?
18.2 Getting Started with Debugging
18.3 Stepping Through Code
18.4 Evaluating Expressions
18.5 Tips on Effective Debugging

Taking Advantage of Queries
19.1 Understanding Joins
19.2 Action Queries
19.3 Access SQL

CD-ROM 11

Managing Data with ADO
20.1 Introducing ActiveX Data Objects
20.2 Retrieving Data with ADO
20.3 Searching for Data in a Recordset
20.4 Updating Data with ADO

Using Error Handling to Bullet-Proof Your Code
21.1 Handling Run-Time Errors
21.2 The Error Handling Standard
21.3 Taking a Closer Look
21.4 Who Handles Errors?

CD-ROM 12

Designing Multiuser Applications
22.1 Multiuser Architectures
22.2 Locking
22.3 Keeping Recordsets Current
22.4 Transaction Processing

Exploring Replication
23.1 Replication Basics
23.2 Replicating a Database
23.3 Changes Access Makes to a Database When You Replicate it
23.4 Synchronizing Replicas
23.5 Conflict Management
23.6 Partial Replication

CD-ROM 13

Automating Office Applications
24.1 What Is Automation?
24.2 Working with Other Applications
24.3 Example: Building an Excel Chart
24.4 MailMerge with Word
24.5 Access as an Automation Server

CD-ROM 14

Securing Your Applications
25.1 Choosing the Right Security System
25.2 Workgroups
25.3 Users and Groups
25.4 Permissions
25.5 Using the Security Wizard to Properly Secure Your Database

Building Access Data Projects
26.1 Introduction to Access Projects
26.2 Creating a New Project
26.3 Creating SQL Server Objects
26.4 Creating SQL Server Database Diagrams
26.5 Creating SQL Server Views
26.6 Creating SQL Server Stored Procedures

CD-ROM 15

Developing Access 2000 Client/Server Applications
27.1 Introduction to Client/Server
27.2 MDB versus ADP
27.3 Designing Client/Server Applications
27.4 Designing MDB Client/Server Applications
27.5 Designing ADP Client/Server Applications

Deploying Access Applications
28.1 The Finishing Touches
28.2 Managing VBA Code
28.3 Introducing the Access Runtime Version
28.4 Developing Runtime Applications
28.5 Deploying Access Applications