Cover image for F. Scott Barker's Access 2002 power programming
F. Scott Barker's Access 2002 power programming
Barker, F. Scott.
Personal Author:
Publication Information:
Indianapolis, Ind. : Sams, [2002]

Physical Description:
xxi, 933 pages : illustrations ; 24 cm
General Note:
Includes index.
Title Subject:
Subject Term:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D3 B3655 2002 Adult Non-Fiction Central Closed Stacks

On Order



F. Scott Barker's Access 2002 Power Programming gives many practical techniques for the corporate and independent developer.

The main topics covered are:

The Root of Power Programming; Manipulating and Presenting Data; Extending Access with Interoperability; Adding the Professional Look and Distributing Applications; Managing Databases; Adding Finishing Touches.

New features of Access 2002 will be covered thoroughly, including:

A whole new chapter devoted to Data Pages, which is Microsoft's way of bringing the Web interface into everyday office solutions. A new chapter clarifying the confusion over ADP/MDB and DAO/ADO. Including when and where to use each. There are a number of new additions to VBA which developers will need good exposure to in order to take advantage of them. A number of changes have been implemented in the form design with control features added.

Author Notes

F. Scott Barker holds a B.S. in computer science and has worked as a database developer for more than 15 years, first with Clipper and then for the last eight years with Microsoft Access, Visual Basic, and SQL Server.

While working at Microsoft for two years, Scott was on the Microsoft Access and FoxPro teams. He now contracts with Microsoft and the Access team by developing in-house tools used throughout Microsoft. With his company, Applications Plus, Scott also does contract development for companies in the banking, medical, and insurance industries.

Scott has trained for Application Developers Training Company and others all around the United States. He is a frequent speaker at Access conferences throughout the U.S., Canada, and Europe. Through his classes and conferences, Scott has trained thousands of developers.

Scott has written articles for Smart Access (Pinnacle), Data Based Advisor Magazine (Advisor), Access, VB, SQL Advisor (Advisor), Microsoft Office & VBA Developer (Informant Communications), and the German VBA Magazin. Scott is the author of Using Access 97, published by Que Corporation, and of Sams/Que's Access Power Programming books for Access versions 95, 97, and 2000. He has also tech edited/reviewed a number of books.

Table of Contents

A Letter from the Author
I The Root of Power Programming
1 Macros Are for Weenies; Code Is Cool!
Understanding Where Macros End and Code Begins
Looking at Macro-to-Code Changes
Converting Existing Macros to VBA Code
2 Coding in Access 2002 with VBA
Getting Started with Programming
Getting Started with VBA
Programming with Objects
Using Properties and Methods
Using Collections
Customizing a Form
Coding Class Modules
3 Making Access Project and Data Technologies Choices
Using Microsoft Database Versus Access Database Project
Using DAO Versus ADO Versus XML
4 Working with Access Collections and Objects
Creating Custom CollectionsComparing Custom Collections to Arrays
Accessing the Access Object Model
Programming Multiple Copies of the Same Form
5 Introducing ActiveX Data Objects
Looking at ADO's Object Models
Referencing the Type Libraries
Opening a Connection to a Database
Creating a Recordset
Working with Queries
Working with Tables
6 Using XML with Access 2002
Getting to Know XML
Working with XML with the Access User Interface
Coding with XML and VBA in Access 2002
Taking Advantage of the Other Office Applications' _XML Support
7 Handling Your Errors in Access with VBA
Examining Access's Runtime Error Handling
Working with the Err and Error Objects
Working with the ADO Errors Collection
Creating User-Defined Errors
Using Custom Error Logs to Track Errors
Creating a Centralized Error-Handling Routine
A Last Look at Error-Handling Issues
II Manipulating and Presenting Data
8 Using Queries to Get the Most Out of Your Data
Understanding Where Queries Are Used in Access
Working with Select Queries
Working with Action Queries
Performing Advanced Query Operations
Adding More Power with VBA
Driving Reports and Forms with Queries
Solving Problems with Queries
Examining the Architecture of the Query Resolution Process
Optimizing Queries with Jet
Understanding Optimization Techniques
Using Unconventional Optimization Techniques
Using the Analyzer Wizards
Looking at Access 2002's New Query Feature
9 Creating Powerful Forms
Increasing Form Performance
Looking at Access 2002's New Form Features
Looking at Access 2002's New Form Features
Taking Advantage of Other Form Features
Reusing Forms to Perform Standard Tasks
Increasing Tabbed Form Performance
10 Expanding the Power of Your Forms with Controls
Setting Up a Field's Lookup Properties for Use on Forms
Tapping into the Power of Combo Boxes
Working with the Access Tab Control
Morphing Access Controls
Programming Multiselect ListBox Controls
Getting Relief with the Subform/Subreport Wizard
Giving Controls Spreadsheet-Type Cursor Movements
Manipulating Controls Through