Special Edition Using Microsoft Access 2002 [Paperback]

Roger Jennings (Author)

Book Description

ISBN-10: 078972510X | ISBN-13: 978-0789725103 | Publication Date: July 1, 2001

Special Edition Using Access 2002 is a reader's authoritative guide to mastering the essential facets of this powerful database development platform. Detailed, step-by-step instructions guide the reader through the process of designing and using Access tables, queries, forms and reports.

Special Edition Using Access 2002 will include comprehensive coverage of the transition to MSDE/SQL Server for all multi-user applications, expanded coverage of Web Applications, and expanded coverage of XML.

This book contains elements such as Tips, Notes, cautions, cross-references and Troubleshooting information, giving the text a "Layered" quality that meets the needs of readers with different learning styles.

Editorial Reviews

From the Back Cover

Special Edition Using Access 2002 is a reader's authoritative guide to mastering the essential facets of this powerful database development platform. Detailed, step-by-step instructions guide the reader through the process of designing and using Access tables, queries, forms and reports.

Special Edition Using Access 2002 will include comprehensive coverage of the transition to MSDE/SQL Server for all multi-user applications, expanded coverage of Web Applications, and expanded coverage of XML.

This book contains elements such as Tips, Notes, cautions, cross-references and Troubleshooting information, giving the text a "Layered" quality that meets the needs of readers with different learning styles.

About the Author

Roger Jennings is an author and consultant specializing in Windows client/server databases and network operating systems. He was a member of the Microsoft technical beta testing team for all seven editions of Microsoft Access; every release of Visual Basic since version 2.0; Windows 3.1; Windows for Workgroups 3.1 and 3.11; Windows 95, 98, Me, and XP; Windows NT 3.5, 3.51, 4.0, Server; Windows 2000 Server and its successor (collectively called Windows 2000+ in this book); and Microsoft SQL Server 6.0, 6.5, 7.0, and 2000. Roger was one of the founding members of Microsoft's Access Insiders group.

Roger's books have more than one million English copies in print and have been translated into 20+ languages. He's the author of Que's Special Edition Using Microsoft Access titles for Access versions 1.0, 1.1, 2.0, 95, 97 (first and second editions), and 2000, and Platinum Edition Using Access 97. He also wrote Que's Special Edition Using Microsoft Windows NT Server 4, Special Edition Using Microsoft Windows 2000 Server, Unveiling Microsoft Windows 95, Access Hot Tips, and Discover Microsoft Windows 3.1 Multimedia. For Pearson Technology Group's Sams imprint, he's written two editions of Access Developer's Guide, three editions of Database Developers Guide with Visual Basic (for versions 3.0, 4.0, and 6.0), and is series editor for the Roger Jennings' Database Workshop titles.

Roger is a contributing editor for Fawcette Technical Publication's Visual Basic Programmer's Journal (http://www.vbpj.com/); his "Database Design" columns and feature articles on Microsoft database technology appear regularly in VBPJ.

Roger co-authored with Microsoft's Greg Nelson "A Client/Server Application: From Concept to Reality" presentation and white paper on Access 2.0, which appeared on the Microsoft Developer's Network CD-ROM and in the Microsoft Developer Network News. An Access 2002 version of the application described in the white paper is in the \Seua10\Chaptr14 folder of the accompanying CD-ROM.

Roger has more than 25 years of computer-related experience, beginning with his work on the Wang 700 desktop calculator/computer. He's a principal of OakLeaf Systems, a Northern California software consulting firm and is the Webmaster for OakLeaf Music, http://www.oakmusic.com/. You can contact Roger at [e-mail].

Product Details

• Paperback: 1488 pages
• Publisher: Que (July 1, 2001)
• Language: English
• ISBN-10: 078972510X
• ISBN-13: 978-0789725103
• Product Dimensions: 9.1 x 7.5 x 2.3 inches
• Shipping Weight: 5.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #1,928,162 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

19 of 19 people found the following review helpful:

5.0 out of 5 stars Special Edition: Special, March 26, 2002

By A Customer

This review is from: Special Edition Using Microsoft Access 2002 (Paperback)

This book, along with many of the other books in the Special Edition collection have earned my attention and purchases over the past 3-4 years. I have learned just about everything I know about building websites, making up databases, word processing, etc. either online or through books related to specific software packages. When I went to develop my first database in MS Access 2000, I bought every single book on the topic. Very few times, did I discover myself finding the information I needed in other books except the Special Edition one.

When we made our XP upgrade, the decision was simple: Special Edition Using Microsoft Access 2002. It will be the only book on the subject purchased---and a good decision it was!

Yes, you have to read. Yes, you have to use the index. Yes, you have to stop and think about what you are looking up and wanting to do. When you have those decisions made, the book is waiting there for you with all the answers written very simply and in an easy--to-read manner.

17 of 17 people found the following review helpful:

4.0 out of 5 stars I chose this over other books I could browse in a bookstore, August 20, 2001

By 

"webfielding" (Scottsbluff, NE United States) - See all my reviews

This review is from: Special Edition Using Microsoft Access 2002 (Paperback)

Access 2002 is in it's infancy, as are the books being published about it. I have Access experiencing dating back to 1994, and am only rusty because I have been doing more client-server DB development in the meantime.

That being said, I recently chose this book in a bookstore, where I could also browse some other thick tomes, such as the Access 2002 Bible. From the table of contents, it just seemed this book would have more information than the others on advanced aspects of Access.

For instance of the 1400 (!!) pages, the last half are devoted to "Upgrading to SQL Server 2000 Databases", "Publishing Data to Intranets and the Internet", and "Programming and Converting Access Applications": these are parts 5, 6 & 7 respectively. The contents further indicate that these chapters will cover topics such as Transact-SQL/Stored Procedures, XML, Visual Basic for Apps, ADO, etcetera, all of which (except maybe XML) I'd touched on before in a prior Intranet/SQL Server application.

I have not yet read all 1400 pages -- I have a life after all! But after reading the first couple of chapters, I am confident this book will meet my needs. For instance, the first chapter provides a great overview of features new to Access 2002, with plenty of references to the points later in the book for those who want that extra detail immediately.

I also think this would be a good book for newer -- but still "serious" -- Access and/or Database users, because the first 700 pages are all about the basics of database design and the interface provided by Access, such as forms and reports. I will try to follow up when I have read more, but so far so good.

11 of 13 people found the following review helpful:

3.0 out of 5 stars Not for beginners., December 4, 2001

By 

"coldfr0nt" (Brooklyn, NY United States) - See all my reviews

This review is from: Special Edition Using Microsoft Access 2002 (Paperback)

Despite the back of the book as suggested for Beginning to Advanced students, this is not something I would wholeheartedly recommend. It is more for the Intermediate and above.
There is a lot of detail given, but the manner in which it is presented leads to more head-scratching than moments of revelation. If you are just starting out, choose another book. If you need a reference, pick this one. If you're not sure where you fall, take the safe path and read reviews for other books.