Table of Contents
BackCover
Programming Microsoft Office Access 2003
Introduction
Organization of the Book
Installing and Using the Samples and Demo Files
Support Information
System Requirements
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
Index_Numbers
Index_A
Index_B
Index_C
Index_D
Index_E
Index_F
Index_G
Index_H
Index_I
Index_J
Index_K-L
Index_M
Index_N
Index_O
Index_P
Index_Q-R
Index_S
Index_T
Index_U
Index_V
Index_W
Index_X
List of Figures
List of Tables
List of Sidebars