Skip to main content

Access 2003 Bible

Access 2003 Bible

Cary N. Prague, Michael R. Irwin, Jennifer Reardon

ISBN: 978-0-764-55705-7

Oct 2003

1320 pages

Select type: E-Book

Product not available for purchase


  • The most comprehensive reference on this popular database management tool, fully updated with the new features of Access "X" including increased use of XML and Web services
  • Explores the new, tighter integration with SharePoint and BizTalk in Office "X" that enables greater flexibility for gathering and manipulating data
  • Written by an international bestselling author team with several books to their credit, including previous editions of Access Bible
  • Gets Access beginners started with hundreds of examples, tips, and techniques for getting the most from Access
  • Offers advanced programming information for serious professionals
  • CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak

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

Missing sample database Access Auto Auctions from CD
Missing sample database Access Auto Auctions Data from CD
ChapterPageDetailsDatePrint Run
CDCD software AccVerify & Website Promotion Suite
At the first printing of the Office 2003 Bibles, complete software instructions were inadvertently left off the CD-ROMs. To use trial software AccVerify and Website Promotion Suite, please go to to receive a password. We apologize for the error and any inconvenience it has caused.

CDCD sample database files
We are sorry for any inconvenience that you may have had with the sample database files Access Auto Auctions and Access Auto Auctions Data that were not included on the CD. These database files are available on the download page. The databases have been compressed in .rar format. You will need to uncompress them with WinRAR which is available on the CD-ROM or can be downloaded at