Access 97 Bible [Paperback]

Cary N. Prague (Author), Michael R. Irwin (Author)

Book Description

ISBN-10: 0764530356 | ISBN-13: 978-0764530357 | Publication Date: January 20, 1997

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.

Editorial Reviews

Amazon.com Review

Microsoft Access 97 is a powerful database package, and Access 97 Bible provides comprehensive coverage of virtually all of its features. Whether you're a database administrator who works with Access 97 databases or a developer who wants to create powerful database front ends, this book gives you all you need to be productive with Access, which is one of the best end-user database tools.

The book begins with a tour of the extensive capabilities of Access 97, which includes everything from wizards and builders for automatically creating databases, to query and report generation, to a programming language (Visual Basic for Applications) used to create professional database front ends. Early chapters take the beginner through the basics of Access 97, including installing, configuring, and setting up an initial database. Clear prose and plenty of screen shots are the rule, making this a good tutorial for the beginning or intermediate database programmer.

After the basics, the book moves toward creating databases, forms, queries, and reports. Access 97 Bible uses hands-on examples instead of theory and database jargon. Advanced sections look at Access 97 macros and add command processing to your database applications and to the Internet capabilities bundled with the product. Overall, this tool-centered approach in Access 97 Bible is perfect for those who want to be productive right away. This book makes a good case for the idea that Access 97 is all you need for creating robust, functional databases for the small business or corporate department. --Richard Dragan

From the Back Cover

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

See all Editorial Reviews

Product Details

• Paperback: 1176 pages
• Publisher: Wiley (January 20, 1997)
• Language: English
• ISBN-10: 0764530356
• ISBN-13: 978-0764530357
• Product Dimensions: 9.3 x 7.3 x 2.2 inches
• Shipping Weight: 3.4 pounds
• Average Customer Review: 3.6 out of 5 stars  See all reviews (55 customer reviews)
• Amazon Best Sellers Rank: #1,921,385 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

62 of 63 people found the following review helpful:

5.0 out of 5 stars Best Book I ever read for Microsoft Access, December 5, 1999

By A Customer

This review is from: Microsoft® Access 97 Bible (Hardcover)

This book contains one continuous example that builds from chapter to chapter. Many of our employees have used this book to learn Access from. It can teach a person with no knowledge of database by starting from Chapter 1 or Information System Professionals can skip the fluffy concepts in the beginning and get into the meat of Access from chapter 7. The middle 1000 pages explain each and every feature of basic Access tables, queries, forms and reports. For those people who want to program, the second to last section covers events, macros, and VBA. The last 300 pages covers advanced features like security, client/server, and replication, and more. We love this book at our company. The CD has great programs on it from Database Creations, the company that the authors run. Great free programs and code examples and a bunch of demos for their add-on developer tools. They have won a lot of awards and you get many hundreds of dollars of productive software programs and examples.

25 of 25 people found the following review helpful:

2.0 out of 5 stars "Bible" is an overstatement, August 2, 2000

By A Customer

This review is from: Access 97 Bible (Paperback)

Unfortunately, the title leads you to believe there is more content than actually exists. This book is for those who want to create a very basic Access application and database. If you need to write useful pass-through queries, or link meaningfully to external data sources, then you will be disappointed. I am saddened to see that so many technical writers want to use a fluffy example for their books, rather than one based on real life. So many topics (controls, queries, external data sources, SQL) are glossed over that it was difficult to glean any useful tips for more intermediate/advanced problems. The index is horrible. Do yourself a favor and check the book out in person before buying it online at Amazon.

25 of 25 people found the following review helpful:

4.0 out of 5 stars Good for beginners, November 28, 1999

By 

Tom Hiebert - See all my reviews

This review is from: Access 97 Bible (Paperback)

I don't know what everyones problems are with this book. I have read it from cover to cover and enjoyed learning all it had to offer. It isn't made for advanced users, as it states on it's cover. However, for beginners, this book is excellent. It will teach you to do everything needed for creating a general database. However, if you are an advanced user it would be a waste of good money. I was new to database programming, and found that with this book and another on Visual Basic, I was able to program a very impressive database that is currently in use be several users of my organization. It is the backbone of the business. So, if you need to learn Access from the start, this book is an excellent starting point.