text.skipToContent text.skipToNavigation
  1. Home
  2. Computer Science & IT
  3. F. Scott Barker's Microsoft Access 2002 Power Programming

F. Scott Barker's Microsoft Access 2002 Power Programming, 1st edition

  • F Scott Barker

Published by Sams Publishing (September 13th 2001) - Copyright © 2002

1st edition

F. Scott Barker's Microsoft Access 2002 Power Programming

ISBN-13: 9780672321023

Includes: Paperback
Free delivery
$54.99

What's included

  • Paperback

    You'll get a bound printed text.

Overview

Table of contents

(NOTE: Each chapter concludes with a Summary.)

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 Collections. Comparing 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 Code.

For teachers

All the material you need to teach your courses.

Discover teaching material