Special Edition Using Access 97 (2nd Edition) (Using ... (Que)) [Paperback]

Roger Jennings (Author)

Book Description

ISBN-10: 0789714523 | ISBN-13: 978-0789714527 | Publication Date: October 9, 1997 | Edition: 2

Special Edition Using Access 97, Second Edition, is your authoritative guide to mastering every facet of this powerful 32-bit database development platform. Get started quickly by using the Database Wizard to create a working Access 97 application in less than 30 minutes. Detailed, step-by-step instructions guide you through the process of designing and using Access tables, queries, forms, and reports. Newly added chapters on advanced VBA 5.0 techniques pave your way to Access programming expertise. Plus, you get full coverage of the latest updates to Access 97, including report Snapshot technology from Office Service Release 1 and the Upsizing Wizard for SQL Server 6.5+.

Editorial Reviews

From the Publisher

Special Edition Using Access 97, 2nd Edition is a tutorial. Readers will learn to how to build an Access 97 database from scratch and how to work with existing databases. They will learn to build forms, reports, and program more complex applications as they develop their skillsSpecial Edition Using Access 97, 2nd Edition is a reference. After readers have built their database, they will refer back to the text for daily troubleshooting or to install new featuresThe one true must have Access 97 resource with start to finish coverage - Making the best even better: All new coverage for the #1 Access book on the market

- Over 300,000 units of Special Edition Access have been sold within the past 3 years

- Expanded coverage of VBA and Office integration

From the Back Cover

Special Edition Using Access 97, Second Edition, is your authoritative guide to mastering every facet of this powerful 32-bit database development platform. Get started quickly by using the Database Wizard to create a working Access 97 application in less than 30 minutes. Detailed, step-by-step instructions guide you through the process of designing and using Access tables, queries, forms, and reports. Newly added chapters on advanced VBA 5.0 techniques pave your way to Access programming expertise. Plus, you get full coverage of the latest updates to Access 97, including report Snapshot technology from Office Service Release 1 and the Upsizing Wizard for SQL Server 6.5+.

Product Details

• Paperback: 1312 pages
• Publisher: Que; 2 edition (October 9, 1997)
• Language: English
• ISBN-10: 0789714523
• ISBN-13: 978-0789714527
• Product Dimensions: 9 x 7.6 x 2.1 inches
• Shipping Weight: 4.8 pounds
• Average Customer Review: 2.6 out of 5 stars  See all reviews (16 customer reviews)
• Amazon Best Sellers Rank: #3,729,660 in Books (See Top 100 in Books)

More About the Author

I'm the principal consultant of OakLeaf Systems, a Windows Azure MVP and the author of 30+ books on Microsoft operating systems (Windows NT and Windows 2000 Server), Windows Azure, databases (SQL Server, SQL Azure and Access), .NET data access, Web services and InfoPath 2003. The books have more than 1.25 million English copies in print and have been translated into 20+ languages.

My latest books are "Microsoft Access 2010 In Depth" (12th edition) for Que Publishing and "Cloud Computing with the Microsoft Azure Services Platform" for Wiley/Wrox.

I'm also the curator of the OakLeaf Systems (http://oakleafblog.blogspot.com) and Access In Depth (http://acccessindepth.blogspot.com) blogs, a contributing editor of 1105 Media's "Visual Studio Magazine" and a frequent contributor to their "Redmond Developer News" newsletter.

OakLeaf's Code of Federal Regulations (CFR) Web service won the charter Microsoft .NET Best award for horizontal XML Web service solutions.

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

4.0 out of 5 stars Great book. Helps you design and structure your database, February 4, 2000

By A Customer

This review is from: Special Edition Using Access 97 (2nd Edition) (Using ... (Que)) (Paperback)

I found this book extremely helpful in building a database from scratch for work without any prior database experience. What separates this book from the rest of the books for beginners is that it goes well beyond the "and you press the wizard button to create a table" and actually gives you the fundamentals needed to design and architect your database. It shows you how to organize your information to get the most out of the relational database capabilities and minimize duplication of information. It shows you via examples what the capabilities of Access are. The book allowed me to have the basic framework up and running in under 3 days and then build on it modularly. If you want to follow the main design example provided in the book (Jennings designs a database throughout the book) you have to read the book sequentially. I have no time to read 1000+ pages, however, the index and cross references have been extremelly helpful in taking me to the exact point where the author is dealing with my particular problem so I can get a quick answer. No book has a magic wand to teach you a subject but this book is as useful as they come.

2 of 2 people found the following review helpful:

5.0 out of 5 stars Superlative book for beginner to intermediate users, April 4, 2001

By 

M. Monica (Central Square, NY) - See all my reviews
(REAL NAME)   

This review is from: Special Edition Using Access 97 (2nd Edition) (Using ... (Que)) (Paperback)

If you are learning Access from the ground up this is a great book for you...this is not a VBA programming guide. If you want to learn VBA that is an entirely different topic. However, there is no one Access/VBA magic book that can cover everything because the Access/VBA universe is so large.

I have used Access and VBA for 6 years and this by far covers more topics than most other books do. I use this book as a reference on occasion and it is often borrowed off my shelf by the end users here at my company. Although there is some VBA code and advanced items in this book I would recommend this book to beginners and intermediate users of Access. The book covers: tables, queries, forms, reports, macros, and some VBA code (modules). There is also a little bit of Internet programming with Access 97 but that section is out-of-date with the advent of ASP.

Bottom line is this is an excellent choice for a reference book for more advanced users and an even better choice for people looking to learn a lot about Access 97.

4 of 5 people found the following review helpful:

1.0 out of 5 stars I HATE THIS BOOK!, December 2, 1999

By 

jsparks (St. Louis, MO USA) - See all my reviews

This review is from: Special Edition Using Access 97 (2nd Edition) (Using ... (Que)) (Paperback)

I can't believe that some people gave this book 5 stars. The content of the book MIGHT be worth 3 or 4 stars, but any chance of that is flushed by the way the book is written.

The problem I have with this book is the excessive cross referencing. At the beginning of the book the author says that the book is written in a linear manner: You should read the book from front to back because each chapter builds on the knowledge you gained in the previous chapters. However, it feels like every other paragraph is referring me to some other chapter, either telling me what I will learn later or what I should have already learned earlier. These cross referencing comments are stuck right in the middle of text about a difficult subject, which takes away from the books continuity and readability. And it's not just the cross-referenceing of chapters. Constantly I read about a feature of Access and then read a sentence like 'This behavior is similar to that of Borland's Paradox.' I don't care about Paradox, that's why I (got) a book about Access. The constant references to other book titles, other chapters, and other database managers make this book very hard to read, and thus very hard to grasp the concepts of Access. 1 Star. Dont buy it. Find another book about Access. At this point, I'm tempted to highlight all the garbage in this book and ship it to the author.

Dont bother with the "For Dummies" series as one reader suggested either. I have found the resources I need on the Web and in the quality electronic documentation that comes with Access. If you can read this Web site and have Access installed on your computer, you have everything you need to learn Access inside and out...