Skip to main content

Access 97 Bible

Access 97 Bible

Cary N. Prague, Michael R. Irwin

ISBN: 978-0-764-53035-7

Feb 1997

1176 pages

Select type: Paperback

Product not available for purchase


Access 97, the world's most popular database program is out at last -- and more feature-packed than ever before. With Access 97 Bible you'll discover just how feature-packed it is. Here, Access experts Cary N. Prague and Michael R. Irwin share the results of their rare and thorough prerelease examination. From designing, creating, and using Access 97 databases to merging them with other Office applications, generating time-saving reports, and automating routine tasks using Visual Basic, Access 97 Bible serves as the best possible single-source reference. Plus, on the book's accompanying bonus CD-ROM, you get indispensable resources and utilities, including Check Writer, a library of business forms, command bar images, all the examples from the book (ready for you to adapt for your own use), and two bonus chapters: An Introduction to VBA Programming" and "The Access 97 Programming Environment.

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.

PART VI: Appendixes.

Appendix A: Microsoft Access for Windows 95 Specifications.

Appendix B: Mountain Animal Hospital Tables.

Appendix C: What's on the CD-ROM.


Hungry Minds, Inc., End-User License Agreement.