Sams Teach Yourself Access 2000 Programming in 24 Hours

• Developing Access add-ins to customize and ectend Access 2000
  
• Creating Web pages with database content for the Internet or your intranet
  
• Creating graphical user interfaces in Access 2000
  
• Building Full-featured Access 2000 applications
  
• Using existing solutions and creating new ones with objectoriented programming
  
• Programming wiht ActiveX' Data Objects (ADO)
  
• Using SQL with it Access 2000
  
• Writing robust, bug-free applications
  using exception-hand ing re techniques

Table of contents

Part I: Access Programming 101

What's New in Access 2000

Exploring VBA

Storing Your Program's Data

Controlling Program Flow and Performing Calculations

Part II: Writing Code to Manage Your Access Data

Learning to Write Conditional Code

Managing Your Database

Using Advanced Data to Manage Data

Solving Problems a Piece at a Time

Part III: Using Access Resources to Get the Job Done

Using Macros as Learning Aids

Employing Access Predefined Solutions

Part IV: Defining Data Types and Using Arrays and Collections Making the

Complex Simple: Creating Your Own Data Types

Managing Varying Amounts of Data

Storing Information in a Collection

Part V: Database Programming in Access

Managing Your Code

Data Programming Made Easy with ADODB

Using Advanced SQL Techniques

Part VI: Mastering Error Handling IV

Removing Bugs

Adding Code to Handle Errors

Part VII: Creating Access User Interfaces

Creating Custom Forms

Adding Data to Web Pages

Part VIII: Object-Oriented Programming in Access

Class Programming Basics

Adding Capabilities to Your Data Types

Access Add-ins

Managing Outlook Contact Information

Part IX Appendixes

Index