Acknowledgments.

Part I: Creating Desktop Applications.

Section I: Working with Data Tables and Queries.

Chapter 1: Understanding Data.

Chapter 2: Creating and Building Tables.

Chapter 3: Entering Data into Tables and Forms.

Chapter 4: Creating and Understanding Relationships.

Chapter 5: Displaying Selected Data with Queries.

Chapter 6: Using Operators and Expressions in Multi-table Select Queries.

Chapter 7: Working with External Data.

Section II: Building Forms and Reports.

Chapter 8: Understanding the Many Uses of Forms and Controls.

Chapter 9: Building and Manipulating Forms and Controls.

Chapter 10: Creating Bound Forms and Placing Controls.

Chapter 11: Adding Data-Validation Features to Forms.

Chapter 12: Creating Professional-Looking Forms and Reports.

Chapter 13: Understanding and Creating Reports.

Chapter 14: Working with Subforms.

Chapter 15: Creating Calculations and Summaries in Reports.

Chapter 16: Presenting Data with Special Report Types.

Chapter 17: Using OLE Objects, Graphs, Pivot Tables/Charts, and ActiveX Controls.

Section III: Automating Your Applications.

Chapter 18: Understanding Visual Basic and the VBA Editor.

Chapter 19: Introduction to Programming and Events.

Chapter 20: Working with Expressions and Functions.

Chapter 21: Working with SQL, Recordsets, and ADO.

Chapter 22: Automating, Searches, Filters, and Query Parameters.

Chapter 23: Calling Subprocedures and Functions.

Chapter 24: Effective Debugging and Error Handling in VBA.

Chapter 25: Creating Switchboards, Command Bars, Menus, Toolbars, and Dialog Boxes.

Chapter 26: Programming Continuous Forms, Tab Dialogs, and Command Buttons.

Part II: Creating Enterprise Applications.

Section IV: Upsizing to SQL Server and MSDE 2000.

Chapter 27: Upsizing Data to a SQL Server Database.

Chapter 28: Working with Access Projects.

Chapter 29: Working with Access Projects and SQL Server Tables and Queries.

Part III: Creating Web Applications.

Section V: Creating Data Access Pages and Using XML and InfoPath.

Chapter 30: Using and Creating Access Objects for Intranets and the Internet.

Chapter 31: Building and Working with Data Access Pages.

Chapter 32: XML, Access, and InfoPath.

Part IV: Advanced Access Database Topics.

Chapter 33: Exchanging Data with Office Applications.

Chapter 34: Adding Security to Applications.

Chapter 35: Creating Help Systems.

Chapter 36: Working with Advanced Select Queries and Other Query Topics.

Chapter 37: Working with Action and SQL Queries.

Chapter 38: Increasing the Speed of an Application.

Chapter 39: Preparing Your Application for Distribution.

Part V: Appendixes and Reference Material.

Appendix A: Access 2003 Specifications.

Appendix B: Access Auto Auction Tables.

Appendix C: Using the CD-ROM Included with the Book.

Appendix D: Using Standard Naming Conventions.

Index.