• 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