Synopses & Reviews
Access 97 Bible Master the Basics and Beyond of Access 97! Watch your productivity zoom to new heights as you master the world's most popular database program. With a special emphasis on running your business more efficiently using Access 97, this one-stop tutorial/reference is packed with hands-on lessons and power tips from two database experts. Learn how to link Access to other Office programs, set up multiple reports, build multi-table queries, and share and analyze information over the Web or your corporate intranet! Whether you're a first-time user or a database pro, you'll find all the information you need in this comprehensive guide. Inside, Find 100% of What You Need to Know
- Learn how to design, create, and use databases
- Merge Access 97 databases with other Office applications
- Build customized database tables and relationships
- Create group summaries, totals, calculations, and mail merge reports and labels
- Automate routine tasks using macros and Visual Basic for Applications (VBA)
- Import external data files from dBASE, Paradox, SQL Server, Excel, 1-2-3, and FoxPro into your databases
- Incorporate Access 97 information on your intranet or on the Internet
Inside! Create Powerful Business Applications with Productivity Tools on CD!
- Check Writer
- Sample library of common business forms
- Command bar image samples
- All examples from the book and step-by-steps for each example
- Two Bonus chapters "An Introduction to VBA Programming" and "The Access 97 Programming Environment"
www.hungryminds.com System Requirements: 486/66 PC Windows 95 or NT 16MB RAM Access 97
This reference book and CD ROM package covers special troubleshooting techniques and emphasizes how useful Access can be running a business. The enclosed CD ROM enables the user to build and customize powerful databases, created with a variety of forms, reports amd macros.
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.
System requirements for disk: 486/66 PC; Windows 95 or NT; 16MB RAM; Access 97.
About the Author
About the Authors Cary N. Prague is a winner of the Computer Press Association's Book of the Year Award. 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, Software International. He is also the coauthor of IDG Books Worldwide's Access Secrets®. Michael R. Irwin is an internationally known lecturer and author on the topic of databases. He is the coauthor of IDG Books Worldwide's Access for Windows® 95 Bible, third Edition.
Table of Contents
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.