MICROSOFT ACCESS 97 BIBLE, GOLD EDITION

Now you can meet all of your database needs with a single source - Microsoft Access 97 Bible, GOLD Edition. With more than 1,500 pages of complete Access coverage, Microsoft Access 97 Bible, GOLD Edition, delivers the most up-to-date information on advanced programming, optimization, security, and replication.

An all-star team of Access authors details every Access feature including:
* Multitable, action, and other advanced queries
* Large database management
* Automation with macros and VBA
* Complex data validation
* Custom toolbars, dialog boxes, and pull-down help menus
* Web publishing including sections on corporate intranets
* Add-ins, wizards, and multimedia elements
Microsoft Access 97 Bible, GOLD Edition, also features a companion CD-ROM with all of the code from the book as well as award-winning business applications such as Check Writer, Flex Search, and much more.

About the Authors Cary N. Prague, a Microsoft Certified Professional, is an internationally best-selling author and lecturer in the database industry. He is also the president of Database Creations, Inc., the world's largest Microsoft Access add-on company. This direct-mail business creates and markets add-on software, books, and video training for personal computer databases. Its Web site is at www.databasecreations.com. Cary also manages a very successful consulting company that is a Microsoft Certified Solution Provider, specializing in Microsoft Access application. His local and national clients include many Fortune 500 software companies, manufacturers, defense contractors, and insurance companies. Cary is one of the best-selling authors in the computer database management market. He has written nearly 35 books, which have sold almost one million copies, covering such software as Microsoft Access, Borland's dBASE IV, Paradox, R:Base, and Framework. He is currently writing several new Access 2000 books. He was a contributing editor for Access Advisor magazine and continues to write for it. Michael R. Irwin is considered one of the leading authorities on automated database and Internet management systems. He is a noted worldwide lecturer, a winner of national and international awards, a best-selling author, and a developer of client/server, Internet, intranet, and PC-based database management systems. Mr. Irwin has extensive database knowledge gained from working as a developer and analyst for the Information Systems Division of the Washington, D.C., Metropolitan Police Department for over 20 years. Since retiring in June 1992, he runs his own consulting firm, Database Integrators, specializing in Internet database integration and emphasizing client/server and net solutions. With consulting offices in Cincinnati, Ohio, and Manila, Philippines, his company does training and development of Internet and database applications. Michael has authored numerous database books, several of them consistently on best-seller lists. His most recent works include the Access 97 Bible (IDG Books Worldwide); he has also written a book on Asian customs and cultures, to be released in 1999. His books are published in over 24 languages worldwide. Michael has developed and markets several add-on software products for the Internet and productivity-related applications, many of which can be obtained from his various Internet sites or on many common download sites. He has also developed and distributes several development tools and add-ins for a wide range of developer applications.

Preface.

Acknowledgments.

PART I: First Things First.

Chapter 1: What Is Access 97?

Chapter 2: Installing Access 97.

Chapter 3: Getting Started with Access 97.

Chapter 4: A Review of Database Concepts.

Chapter 5: A Hands-On Tour of Access 97.

Chapter 6: A Case Study in Database Design.

PART II: Basic Database Usage.

Chapter 7: Creating Database Tables.

Chapter 8: Entering, Changing, Deleting, and Displaying Data.

Chapter 9: Creating and Using Simple Data-Entry Forms.

Chapter 10: Understanding and Using Simple Queries.

Chapter 11: Creating and Printing Simple Reports.

Chapter 12: Setting Relationships Between Tables.

PART III: Using Access in Your Work.

Chapter 13: Using Operators, Functions, and Expressions.

Chapter 14: Creating Relations and Joins in Queries.

Chapter 15: Creating Select Queries.

Chapter 16: Understanding Controls and Properties.

Chapter 17: Creating and Customizing Data-Entry Forms.

Chapter 18: Creating Great-Looking Forms.

Chapter 19: Adding Data-Validation Controls to Forms.

Chapter 20: Using OLE Objects, Graphs, and ActiveX Custom Controls.

Chapter 21: Creating and Customizing Reports.

Chapter 22: Database Publishing and Printing.

Chapter 23: Creating Calculations and Summaries in Reports.

PART IV: Advanced Database Features.

Chapter 24: Working with External Data.

Chapter 25: Advanced Select Queries.

Chapter 26: Creating Action Queries.

Chapter 27: Advanced Query Topics.

Chapter 28: Creating and Using Subforms.

Chapter 29: Creating Mailing Labels and Mail Merge Reports.

PART V: Applications in Access.

Chapter 30: An Introduction to Macros and Events.

Chapter 31: Using Macros in Forms and Reports.

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

Chapter 33: Using the Internet Features of Access 97.

Chapter 34: Introduction to Applications with VBA.

Chapter 35: The Access Programming Environment.

PART VI: Advanced Access Topics.

Chapter 36: Optimizing Performance.

Chapter 37: Securing an Access Application.

Chapter 38: Creating Help Systems in Access 97.

Chapter 39: Distributing Applications with the Office Developer Edition.

Chapter 40: Integrating with Microsoft Office.

Chapter 41: Exploring Replication.

Chapter 42: Exploring Add-Ins and Libraries.

Appendix A: Microsoft Access 97 Specifications.

Appendix B: Mountain Animal Hospital Tables.

Appendix C: What's On the Access 97 Bible, Gold Edition CD-ROM.

Appendix D: Example CD Object Cross-Reference Guide.

Appendix E: Example CD Chapter Cross-Reference Guide.

Index.

End-User License Agreement.

CD-ROM Installation Instructions.