Programming Microsoft Office Access 2003 (Core Reference) (Pro-Developer)

Rick Dobson, Microsoft Press

ISBN:0735619425, Edition: , 2003-10-01

Price: $49.99

Table of Contents

Programming Microsoft Office Access 2003

Introduction

Chapter 1 - Data Access Models: Part I
ADO Overview
The Connection Object
The Recordset Object
The Field Object
Summary

Chapter 2 - Data Access Models: Part II
Command and Parameter Objects
The Errors Collection
Recordsets, Records, Streams, and the Web
Summary

Chapter 3 - The ADOX Library and Tables
Overview of the ADOX Model
Creating a New Database
Enumerating Tables
Using the AllTables Collection
Populating Tables with Data
Summary

Chapter 4 - Jet SQL, the ADOX Library, and Queries
Jet SQL Syntax for Select Queries
Managing Row-Returning Queries with ADOX
Creating and Running Action Queries with ADOX
Introduction to Jet SQL's DDL
Summary

Chapter 5 - Forms, Controls, and Data
Using the Form Timer Event
Switchboard Forms
Linking Forms to a Single Record Source
Processing Main/Subforms
Formatting Controls on Main and Subforms
Looking Up and Displaying Data
Manipulating Forms with VBA
Summary

Chapter 6 - Reports, Controls, and Data
Report Architecture and Creation Strategies
Creating Reports Programmatically
Creating Reports with Wizards
Creating Reports in Design View
Distributing Reports Using Snapshots
Making Reports Dynamic
Dynamically Updating Reports
Manipulating Reports and Report Controls
Summary

Chapter 7 - Designing and Using PivotTables and PivotCharts
Overview of PivotTables
Overview of PivotCharts
Creating PivotTables Programmatically
Programmatically Creating PivotCharts
Summary

Chapter 8 - Microsoft Office Objects
Using the Shared Office Objects
DocumentProperty, CurrentDB, and CurrentProject Objects
FileSearch Object
CommandBar Object
Summary

Chapter 9 - Integrating Access with Other Office Applications
Linking Access to Other Office Applications
Working with Excel from Access
Working with Outlook from Access
Working with Word from Access
Summary

Chapter 10 - Database Security
Securing Files Without User-Level Security
Overview of User-Level Security
User-Level Security via ADOX
User-Level Security via Jet SQL and ADO
Access 2003 Security Innovations
Summary

Chapter 11 - Using Access to Build SQL Server Solutions: Part I
Access Projects and SQL Server Versions
Creating and Opening Access Projects
Books Online and Other SQL Server Learning Resources
Tables and Database Diagrams
Adding a Table from a Database Diagram
SQL Server Views
Creating and Using Stored Procedures
Managing Input Parameters, Output Parameters, and Return Values
Updating and Deleting Records from Parameter Values
Triggers
User-Defined Functions
Summary

Chapter 12 - Using Access to Build SQL Server Solutions: Part II
Extending AutoForm-Generated Forms
Creating Unbound Combo Boxes on Forms
SQL Server Form Issues
Programming Reports in Access Projects
Summary

Chapter 13 - Using Access to Build SQL Server Solutions: Part III
Overview of SQL Server Database Security Concepts
SQL-DMO Programming
Programming Login and User Accounts
Programming Roles and Permissions
Summary

Chapter 14 - Access Does the Web
Overview of Web Technologies
Using FrontPage 2003
Getting Started with Forms on Data Access Pages
Programming Events on Data Access Pages
Managing Images on a Data Access Page
Creating Interactive Reports with Computed Fields
Programming Data Access Pages with VBA
Office 2003 Web Components
Summary

Chapter 15 - XML and Access
Introduction to XML Technologies
Manually Using XML from Access 2003
Programmatically Using XML from Access 2003
Summary

Index

List of Figures
List of Tables
List of Sidebars