Access 2002 Bible

Summary

The Ultimate Guide to Access 2002 In this indispensable resource, three of the world's best-known Access experts share everything they've learned through years of building and managing Access databases. With over 400 pages of bonus content on designing advanced queries, working with subforms, creating mail merge reports, and using events and macros, this deluxe Gold Edition will answer all your questions and help you develop state-of-the-art database systems. Encyclopedic Coverage of Access 2002 Design flexible databases using the proven seven-step method Set relationships between multiple tables to facilitate queries Generate reports, including mail merge reports and mailing labels Integrate data from other Office applications or other databases Create live Web forms using XML and Data Access Pages Build SQL Server applications with stored procedures and triggers Use macros, VBA, and ADO (Active Data Objects) to automate manual processes Develop custom toolbars, dialog boxes, and help systems 2 Bonus CD-ROMs!Demos of Check Writer, EZ File Manager, EZ Access Developer's Suite, and other tools from Database CreationsSpeed Ferret, Office Converter, and Solutions:: PIM Professional demosAll examples and code from the bookA searchable e-version of the bookwww.hungryminds.com System Requirements: Pentium-class PC running Windows 9x/Me/2000 or XP, CD-ROM drive. See About the CD appendix for details.

Author Biography

<B>Cary N. Prague</B> is an international bestselling author and lecturer in the database industry. He has written 35 books on databases and developed the award-winning Check Writer program. He is founder of the world's largest Access add-on company, Cary Prague Books and Software.

Preface

Acknowledgments

Part I: First Things First

(116)

What Is Access 2002?

(20)

Installing and Running Access 2002

(32)

A Hands-on Tour of Access 2002

(26)

Database Concepts and Design

(36)

Part II: Creating the Objects

117

(198)

Creating Database Tables

119

(46)

Setting Relationships Between Tables

165

(46)

Working with Information in Tables

211

(38)

Creating and Using Simple Data-Entry Forms

249

(20)

Understanding and Creating Simple Queries

269

(26)

Creating and Working with Simple Reports

295

(20)

Part III: Using Access in Your Work

315

(374)

Using Operators, Functions, and Expressions

317

(26)

Creating Relations and Joins in Queries

343

(26)

Working with Select Queries

369

(26)

Understanding Form Controls

395

(28)

Creating and Customizing Data-Entry Forms

423

(48)

Creating Great Looking Forms

471

(22)

Adding Data Validation Controls to Forms

493

(26)

Using OLE Objects, Graphs, Pivot Tables/Charts, and ActiveX Controls

519

(52)

Creating and Customizing Reports

571

(52)

Presentation-Quality Reports and Printing

623

(32)

Creating Calculations and Summaries in Reports

655

(34)

Part IV: Advanced Access Database Topics

689

(202)

Working with External Data

691

(50)

Working with Advanced Select Queries

741

(32)

Working with Action Queries

773

(28)

Advanced Query Topics

801

(32)

Working with Subforms

833

(30)

Creating Mail Merge and Label Reports

863

(28)

Part V: Access Application Tools

891

(220)

Working with Macros and Events

893

(24)

Using Macros in Forms and Reports

917

(44)

Working with Visual Basic in Access 2002

961

(32)

Using Visual Basic in Forms and Reports

993

(56)

Creating Switchboards, Command Bars, Menus, Toolbars, and Dialog Boxes

1049

(62)

Part VI: Access and the External World

1111

(162)

Moving from Jet to the SQL Server 2000 Desktop Engine

1113

(38)

Working with Access Projects

1151

(28)

Using and Creating Access Objects for Intranets and the Internet

1179

(38)

Building Web Applications, Data Access Pages, and XML

1217

(56)

Part VII: Advanced Topics in Access 2002

1273

(260)

Optimizing Performance

1275

(44)

Securing an Access Application

1319

(48)

Creating Help Systems in Access 2002

1367

(34)

Using the Microsoft Office XP Developer

1401

(36)

Integrating with Microsoft Office XP

1437

(26)

Exploring Replication

1463

(36)

Exploring Add-Ins and Libraries

1499

(34)

Appendix A: Access 2002 Specifications

1533

(6)

Appendix B: Mountain Animal Hospital Tables

1539

(8)

Appendix C: What's on the CD-ROM

1547

(10)

Index

1557

(59)

Hungry Minds, Inc. End-User License Agreement

1616

(2)

CD-ROM Installation Instructions

1618

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.