Access 2003 Bible

Preface xi

Acknowledgments  xxxi

Part I: Creating Desktop Applications 1

Section I: Working with Data Tables and Queries 1

Chapter 1: Understanding Data 3

Chapter 2: Creating and Building Tables 35

Chapter 3: Entering Data into Tables and Forms 85

Chapter 4: Creating and Understanding Relationships 123

Chapter 5: Displaying Selected Data with Queries 153

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

Chapter 7: Working with External Data 247

Section II: Building Forms and Reports 299

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

Chapter 9: Building and Manipulating Forms and Controls 321

Chapter 10: Creating Bound Forms and Placing Controls 349

Chapter 11: Adding Data-Validation Features to Forms 391

Chapter 12: Creating Professional-Looking Forms and Reports 421

Chapter 13: Understanding and Creating Reports 443

Chapter 14: Working with Subforms 503

Chapter 15: Creating Calculations and Summaries in Reports 539

Chapter 16: Presenting Data with Special Report Types 575

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

Section III: Automating Your Applications 653

Chapter 18: Understanding Visual Basic and the VBA Editor 655

Chapter 19: Introduction to Programming and Events 679

Chapter 20: Working with Expressions and Functions 713

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

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

Chapter 23: Calling Subprocedures and Functions 771

Chapter 24: Effective Debugging and Error Handling in VBA 783

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

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

Part II: Creating Enterprise Applications 883

Section IV: Upsizing to SQL Server and MSDE 2000 883

Chapter 27: Upsizing Data to a SQL Server Database 885

Chapter 28: Working with Access Projects 903

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

Part III: Creating Web Applications 945

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

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

Chapter 31: Building and Working with Data Access Pages 981

Chapter 32: XML, Access, and InfoPath 1037

Part IV: Advanced Access Database Topics 1081

Chapter 33: Exchanging Data with Office Applications 1083

Chapter 34: Adding Security to Applications 1101

Chapter 35: Creating Help Systems 1143

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

Chapter 37: Working with Action and SQL Queries 1229

Chapter 38: Increasing the Speed of an Application 1265

Chapter 39: Preparing Your Application for Distribution 1309

Part V: Appendixes and Reference Material 1331

Appendix A: Access 2003 Specifications 1333

Appendix B: Access Auto Auction Tables 1339

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

Appendix D: Using Standard Naming Conventions 1355

Index 1363