+353-1-416-8900REST OF WORLD
+44-20-3973-8888REST OF WORLD
1-917-300-0470EAST COAST U.S
1-800-526-8630U.S. (TOLL FREE)


Access 2002 Bible. Gold Edition

  • ID: 2246659
  • Book
  • November 2001
  • 1664 Pages
  • John Wiley and Sons Ltd
1 of 3
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 Creations

∗ Speed Ferret, Office Converter, and Solutions::PIM Professional demos

∗ All examples and code from the book

∗ A searchable e–version of the book

[external URL] System Requirements: Pentium–class PC running Windows 9x/Me/2000 or XP, CD–ROM drive. See About the CD appendix for details.
Note: Product cover images may vary from those shown
2 of 3


PART I: First Things First.

Chapter 1: What Is Access 2002?

Chapter 2: Installing and Running Access 2002.

Chapter 3: A Hands–on Tour of Access 2002.

Chapter 4: Database Concepts and Design.

PART II: Creating the Objects.

Chapter 5: Creating Database Tables.

Chapter 6: Setting Relationships Between Tables.

Chapter 7: Working with Information in Tables.

Chapter 8: Creating and Using Simple Data–Entry Forms.

Chapter 9: Understanding and Creating Simple Queries.

Chapter 10: Creating and Working with Simple Reports.

PART III: Using Access in Your Work.

Chapter 11: Using Operators, Functions, and Expressions.

Chapter 12: Creating Relations and Joins in Queries.

Chapter 13: Working with Select Queries.

Chapter 14: Understanding Form Controls.

Chapter 15: Creating and Customizing Data–Entry Forms.

Chapter 16: Creating Great Looking Forms.

Chapter 17: Adding Data–Validation Controls to Forms.

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

Chapter 19: Creating and Customizing Reports.

Chapter 20: Presentation–Quality Reports and Printing.

Chapter 21: Creating Calculations and Summaries in Reports.

PART IV: Advanced Access Database Topics.

Chapter 22: Working with External Data.

Chapter 23: Working with Advanced Select Queries.

Chapter 24: Working with Action Queries.

Chapter 25: Advanced Query Topics.

Chapter 26: Working with Subforms.

Chapter 27: Creating Mail Merge and Label Reports.

PART V: Access Application Tools.

Chapter 28: Working with Macros and Events.

Chapter 29: Using Macros in Forms and Reports.

Chapter 30: Working with Visual Basic in Access 2002.

Chapter 31: Using Visual Basic in Forms and Reports.

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

PART VI: Access and the External World.

Chapter 33 Moving from Jet to the SQL Server 2000 Desktop Engine.

Chapter 34: Working with Access Projects.

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

Chapter 36: Building Web Applications, Data Access Pages, and XML.

PART VII: Advanced Topics in Access 2002.

Chapter 37: Optimizing Performance.

Chapter 38: Securing an Access Application.

Chapter 39: Creating Help Systems in Access 2002.

Chapter 40: Using the Microsoft Office XP Developer.

Chapter 41: Integrating with Microsoft Office XP.

Chapter 42: Exploring Replication.

Chapter 43: Exploring Add–Ins and Libraries.

Appendix A: Access 2002 Specifications.

Appendix B: Mountain Animal Hospital Tables.

Appendix C: What′s on the CD–ROM.


Hungry Minds, Inc. End–User License Agreement.

CD–ROM Installation Instructions.
Note: Product cover images may vary from those shown
3 of 3
Cary N. Prague 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.

Michael R. Irwin is an internationally known lecturer and author on the topic of databases. He is considered one of the leading authorities on automated database management systems.
Note: Product cover images may vary from those shown