Product Description
This introductory book teaches you the essentials of Access programming and how to write client/server applications...all at once. In fact, by the end of the first 4 chapters (just 157 pages), you'll be writing your first true client/server application, using Access as the front-end and DAO as the data access method. The data itself can be in an Access database or in an ODBC database such as SQL Server whose tables are linked to Access tables. ... Read more

Customer Reviews (3)

Great Resource
I have been developing applicaitons for a number of year now with Access 97 and have many books I have used.This book has become my most recommended.I have found many books on Access to be either too basic or too advanced for me.This book talks about basic concepts and then adds enough advanced information that almost anyone could learn something from it.The concepts are explained in a very understandable way.I wish I had bought this years ago!

must for anyone who develops serious applications in Access
Client/Server Programming for Access 97 is a must have for anyone who develops serious applications in Access 97. It contains clear, practical guidelines to create and polish client/server applications using Access 97.I recommend this book to both novices and experts since it impossible tobelieve that there will not be something of value for anyone who reads it.It can be read cover to cover or used as a reference. As a footnote, I mustalso add that the paper quality is unusually good and the layoutscompletely avoid descriptions on one page and diagrams on the other.

Excellent coverage of the entire topic
I just finished the book and I loved it! It does a very nice job of covering the entire topic in enough depth to provide real answers, while leaving plenty of room for exploration. I'll be downloading some of theexamples soon. I particularly liked the "Paired-Pages" arrangement wherethe right page summarizes and supplements the material presented on theleft. It delivers the concepts in convenient bite-size pieces withimmediate, built-in reinforcement. It will get my highest recommendation.It now takes it's place on my shelf alongside the other Access "Bible", theSybex Access97 Developer's Handbook. ... Read more

Product Description
Tutorial to guide readers through ADO.NET from the top down, showing readers the hows and whys of using ADO.NET with lots of examples they can mold into their own projects right away. Softcover. ... Read more

Customer Reviews (19)

Keep it in balance
This a good book but I think the author goes a little nuts with datasets. Datasets are not the best solution for every situtation.

Good, but could use more depth
While this is an excellently written book and a very easy read, I find that it doesn't really have the depth for the really sticky problems. It's a great overview, but not a reference work.

Great KJob Shawn
Shawn has given me a lot of good advise on different LISTSERVS.So, I figured it was time I purchased his book and read it.
I guess you could call me the ADO.NET guru at our shop.We all try to specialize in something and this is what I chose 3 years ago.I have read a lot of books and white papers on ADO.NET.
That said, Shawn's book was a quick read for me (about a week, 1-2 hours a night).The book's content is invaluable though if you are learning ADO.NET.
Shawn writes with personality and a little humor.It makes the book fun to read and it flows well.He does not regurgitate the SDK.He introduces a topic, explains it well with a sample or two and a small amount of code (C#) and then moves on.He does not throw volumes of code samples or flow chart\grids at you.One of my pet peeves with tech books is too much code and too many fluffy pictures.There is nothing worst than reading and coming to 10-15 pages of copied\pasted code or 2-3 pages of pretty\fluffy flow charts.Boring IMHO.Stick it on a cd or web site and refer me to it.
Shawn does a nice job covering the things you will need to know and most likely use everyday.He does not waste time covering some cool and neat, that, though it's cool and neat, has little daily value to you as a developer.He covers design techniques very well to.
I did not read the chapter 6, as I am not a fan of typed datasets.
I can honestly state I learned something from every chapter.Most was review, some was "oh yeah, I forgot about that".I especially like the Best Practices section in chapter 11.
My only complaint: he is obviously an Atlanta Braves fan;-(
I would give the book at least a 4, maybe a 4.5 on a 5 scale. Nice job Shawn and thanks for all the tips.

Easily the most useful technical book I've read in years.
I have been a data application developer for over ten years. I've read, on average, two technical books per year on theory or practical application. This book has been my favorite for a number of reasons:

1) It covers the topics that are necessary to develop data applications in a .NET environment.
2) It gets to the point and doesn't waste your time needlessly.
3) It has concrete examples that are applicable to many situations with detailed descriptions.
4) It fully addresses the .NET focus on disconnected data centering around the Dataset. Making the paradigm switch from ADO to ADO.NET can be a daunting task. The sequence and examples of the book put all of the pieces of the puzzle together and allow you to start thinking in terms of disconnected data and not just DataReaders.

Data is the foundation of most every business application and it's essential to have a full understanding of the database/application interaction. Taking ADO.NET for granted is a common mistake, but spending time understanding to movement and manipulation of your data will result in a more stable and successful overall data application.

Mr. Wildermuth has done a great job. Highly recommended.

Excellent ADO.NET Book
Even though I am a VB/VB.NET developer and this book uses all C# examples, I found it to be extremely informative and packed with useful information. The concepts are explained in detail, but the author has written in such a clear and lucid style, that they are easy to grasp. If only all computer books were writen as well as this one! If you have been trying to get a firm understanding of ADO.NET, this is the book for you. ... Read more

Product Description
Develop bullet-proof Access applications with our best-selling Access programmer's handbook. Packed with tricks, secrets, and undocumented features, this insider's guide helps you achieve efficient database design, build better user interfaces, develop client/server applications, and plan for interoperability. The companion CD contains all the applications and code described in the book. ... Read more

Customer Reviews (6)

I highly recommend this book.
I am a programmer/analyst and was recommended this book by a friend. I canassure you that this book is one of the most complete and well writtenbooks I have ever seen. The authors go into great detail where it is neededand skim that which is less usefull. The wording might be difficult toundestand at times but the authors almost always offer examples to clearlyillustrate technics and theory. Buy it. Use it. It`s a fantastic ressource.I never use access without it. I would purchase any new edition to thisbook without hesitation.

Is the best book about MS Acces 95 in the market
I'm an Access Developer and this book save me many time, because really have usefull examples for the real world developing. If you are looking for a book about Profesional Access development and Visual Basic, then you must buy this book! All my co-workers was buyed a copy after me! Really is the best of the best!

Excellent Access coverage
This is by far the best book on Access I have read , covering all aspects of Access application development from relational database design to coding to designing a practical user interface. The CD rom is PACKED with useful code and examples.

Forget the rest, this is the best!
The Access 95 Developer's Handbook is *THE* developer's handbook.It covers relational database design theory, VBA, DAO 3.0.You'll learn how to optimize queries, tables, forms, reports, and VBA code.If you want to write your own wizards and add-ins, this book will show you how.Learn to develop multiuser applications and how to use replication and security. If you don't like to read, buy the book anyway and just use the CD. This book has what the others don't

Great book, and I've seen lots of Access development books
A very fine design and very understandable handbook for serious developers and also beginers. highly recommende ... Read more

Product Description
Attention developers: this is the only book dedicated to client/server application development using Access for Windows 95 and SQL Server 6. Written for experienced developers who already know both products, this unique handbook is designed to help you build better enterprise applications for Windows 95. Both the book and its companion CD are loaded with valuable code that not only illustrates key concepts, but also can be used in your own work. ... Read more

Customer Reviews (2)

Excellent buy
The book is in excellent condition, much more than you can expect from buying used books, unbelievable give-away price, excellent package and shipping. I am very happy about it.

Very good coverage
Simple enough for the astute beginner and complete enough for the experienced user. ... Read more

Product Description
Covering beginning through advanced software features, this comprehensive book contains step-by-step instructions, screen illustrations, objectives, tips, notes, chapter summaries, end-of-chapter exercises, projects and SCANS correlations. ... Read more

Product Description
Chart a course for more effective data analysis with Access 2007. With this resource, you’ll learn how Access 2007 offers powerful functionality that may be better suited to your data analysis needs. Learn to analyze large amounts of data in meaningful ways, quickly and easily slice it into various views, automate redundant analysis, and save time—all using Access. If you know a bit about table structures and formulas as well as data analysis, start thinking outside the chart. ... Read more

Customer Reviews (10)

Good Book Problems with Kindle Edition
This is a very good book for doing exactly what the title says.Easy to follow and there are a lot of useful tips on how to design queries and perform solid data analysis using Access.This is not a beginners book on how to use Access but a good learning tool once a few Access fundamentals have been learned elsewhere.

The Kindle edition has problems.Many of the screen shots of the actual examples (in particular of the query builder) are not readable on the kindle (and aren't readable on the kindle for PC), unfortunately for many of the sections this renders the information useless since it means you can't actually read the instructions for what is being demonstrated.

The hardcopy book is a 5 the Kindle version a 1 or 2.Hopefully the Kindle version can be reformatted and redistributed.

This book is amazing!
I consider myself an advanced Excel user. I've recently started using Excel to analyze very large datasets... and have quickly started to realize that Excel may not be the best tool for the job. I was running Subtotals on a 600,000+ line spreadsheet, which was taking HOURS for the progress bar to move.... a coworker saw what I was doing and put the same dataset in Access and got the result I wanted in minutes. That was my "aha!" moment with Access.

After that experience I've tried learning Access by taking an online course (from Microsoft), and reading 1 other book... They just didn't work for me. I'm pretty computer savvy but I just couldn't "get" Access. I'm so used to Excel. So I've been struggling with this.

I've got my new Kindle DX and decided to see what books on Access were out there. Downloaded several samples, and ended up purchasing this one.

This book is targeted towards people like me -- advanced Excel users who realize that Excel isn't always the right tool for the job, who want to learn Access, but have had trouble figuring it out. PERFECT. Exactly what I needed.

It's well written and well paced. It starts out with a lot of comparisons between Excel and Access. I feel like everything is "clicking" now and I'm quickly realizing how incredibly powerful Access is. I wish I had found this book 6 months ago when I started trying to learn it because the online class I had taken, and the other book I had read just didn't work for me. This book has been a life-saver!

I would like to comment specifically on the Kindle edition of this book... I have a Kindle DX. I must admit that I am disappointed in the quality of the pictures. This is not a fault of the Kindle, but a fault of the book. Some of the screenshots (even with zooming in) have such poor quality that it can be difficult to see what is going on. It didn't stop me from getting what I needed out of the book, but that was a little disappointing.

Also one other thing -- I was pleased to find out that the publisher, on their website, has posted all of the databases / tools that are included on the CD-ROM that comes with the regular version of the book. That is much appreciated. There are sample databases that you follow along with. I noticed that, for some of the other Access books on Kindle, the publishers do not offer the additional electronic content online.

All in all, this book was a life-saver for me and has helped me learn Access. I would highly recommend it to other Excel users who are having a hard time making the switch.

A good book to start with
a really good book for "beginners" who is familiar with the basic concept of relationel databases og controllers/analysts who final have discovers the limitations of excel.
It takes you thru the most needs stuff, to get to started. Has good examples that are easy to understand.

Excellent book
has a quick and well written introduction to creating queries in Access. Also covers some more advanced data analysis tools.Well worth the investment.

"Amazon OnLine Reader version of Manual
I just ordered Microsft Access 2007 Data Analysis, and paid the extra $ to usethe "Amazon Online Reader" option.
Upside: as promised, I am able to immediately view the entire book using the Online Reader :-).The material seems excellent and I'm anxious to start working with the solutions the author is trying to provide me, but . . .
Downside: the Online Reader image quality is fuzzy, and renders the small font images and screen captures in the book illegible :-(Tres' aggravating since the details of the solutions are spelled out in text that I Just Can't Quite Read. I'm chomping at the byte for the postman to bring my hard copy!
I have emailed a query to Amazon's customer service folks, asking if there is a user-end fix for this dilemna. But, unless they have a solution, I would have to opin that the book itself appears well written and informative, but the Online Reader Option for this and other manuals with graphics needs refinement before I spend any more money on the service.
PS - Yes, the OnLine Reader problem is not limited to this book. A second book, different author, different publisher, which I purchased on-line Amazon Digital rights to at the same time is also fuzzy at best and the small type is not legible. // ... Read more

Product Description
Here's the insider's guide to developing cleaner, faster, more reliable, and better-looking Access applications. Featuring a member of the Access development team and the editor of Smart Access, this book covers the product's secrets and includes a disk of sample databases, applications, and a "codebase" of tips and tricks discussed in the text. ... Read more

Customer Reviews (10)

Any one chapter is worth the price of the book
If you are looking for an introductory book on Access 2.0, this is not that book. Use the MS manual and the F1 key. A lot. But once you have a basic understanding, and want to build a 'good' app, don't start withoutthis book. If you believe that code can be beautiful and elegant you'llappreciate the book even more. The samples and examples on the accompanyingdisk will save you much more than the price of the book. And you'll learn aton in the process.

Must have MS Access 2.0 book
The best book I have found on MS Access 2.0.I originally bought it because it contains information about how to dynamically resize forms. It it a great reference manual and you can check out some of the code at Sybex website.

Excellent Guide even for Access 95, 97 Developers
I bought the Access 95 version of this book, and later was forced to buy the book to study a particular Access 2 feature. I was struck by how much value the book adds. To me, this is more of an in-depth introduction to Access development than any book outside the "Building Applications" manual. It far surpasses that manual in terms of explanation and samples.

If you only own one Access 2.0 book, this should be it
A ~1400 page book chock full of good information and Access 2.0 application development and Access Basic coding.I've used at least 2 full Post-It tape flag boxes in marking the important sections of my book with colored tabs.This book covers everything from SQL syntax to interface development and writing run-time applications.This is truly a must have book for the Access developer

The Access 2.0 "Bible"
If you are doing any developing on an Access 2.0 platform and want to create better then the average application, this is the book to own.I own three other Access books and the one I keep returning to is the "Handbook".Affectionately refered to as as the "Bible", my friends and I point out page numbers to the solutions we need when brain storming.It covers even undocumented features that are available with winning detail and the disk included allows you to pop the code in right where you need it.Even novice programmers can pick up this book and get on the road to building killer applications. This book helped me build an imaging system for a client and made me look like God's gift to consulting. Now they buy me lunch every time I see them. It is a must for the application developer. I can't wait for the Access 97 version ... Read more

Product Description
Store, retrieve, and present information accurately and effectively with help from this comprehensive resource. Get the most out of Access, a straightforward but extremely versatile information management tool, including an understanding of basic database concepts as well as intermediate to advanced database design and programming. ... Read more

Customer Reviews (5)

Not Easy To Follow
I found the book was difficult to follow.I was looking for a book that would walk me through creating events and setting up forms.Not helpful.I definitely have used more helpful books.

Great Reference
I checked out approximately two dozen books about MS Access from my local library system and found this one to be far and away the best of the bunch. Most books were similar to the "dummies" books that we've all come to know over the years. This book, on the other hand, provides in-depth step-by-step instructions for both the basic and more advanced features available in MS Access. Given the need for timeliness in my work, I generally use this as a reference rather than an instructional tool. I've recommended the book to several coworkers and they have found it useful as well.

Good reference for newbie
Of the various manuals around the office (some being coworkers children's college texts) - I found this book to be the most helpful getting me started.I am very familiar with MS Word and Excel but never had a need to use Access.
This book covered all the basics about table design, relationships, queries, etc.
So far answers to all the problems I've encountered with Access have been found in this book.

If I could tear it in half I would.
Firstly, I am pretty good with computers, a wize and excel and various other applications and to be honest I never have problems figuring things out, until now.This text lacks any supporting information whatsoever.Firstly, unless you have the exact tables they are using it is a wonder anything happens to work.Secondly, could it use more jargon?

This text would be a great reference tool for someone who is well versed in the program, but not to someone using the program.

Office Access 2003 Review
I personally did not like this book.I am pretty new to Access but I am young so I pick these programs up pretty fast.My work involved some advanced query work for data scrubbing.The book goes over every single function but does not go into depth about it.When it described a object (IE: list boxes), i really needed to know how Access stores the data and how i can access it, but the book was no help.I got a feel for the program's functions but could not use this book as a reference when i was coding.I wanted to use this book like i used Excel 2003 Bible, with the detail that I could refer too.Maybe I was looking for too much? ... Read more

Product Description
The inside scoop...for when you want more than the official line!

Microsoft Access 2007 may be a major new update, but to use it with confidence, you'll need to know its quirks and shortcuts. Find out what the manual doesn't always tell you in this insider's guide to using Access 2007 in the real world. What's the best way to use the new features? What are "intelligent" forms? From setting up tables to encrypting databases, first get the official way, then the best way from an expert.

• Unbiased coverage of how to get the most out of Access, from using the Quick Launch Toolbar and Office Button to building a database from scratch
• Savvy, real-world advice on everything from using form views, PivotTables, and PivotCharts to writing questions in the form of a query
• Time-saving techniques and practical guidance on creating smart macros, collaborating with others using SharePoint(r), and adding pizzazz to reports
• Tips and hacks that help you work around Access quirks, avoid pitfalls, and increase your productivity
• Sidebars and tables on sorting rules for special characters, predefined sizes for number data types, and more

Product Description
Get introduced to Access with PICTURE YOURSELF LEARNING MICROSOFT? ACCESS? 2007! Perfect for those who are comfortable using Microsoft Office 2007, but new to Access, the database component of the Office suite of applications. You?ll learn how to create and share databases, including tables, queries, forms, and reports. This book uses a visual approach to learning and is packed with clear, step-by-step instructions and full-color images that will walk you through the basics of all the capabilities of Access. If you?ve never used Access, you can start at the beginning with a tour of the interface and learn how to create a basic database file and input data into it. Once you?re comfortable you?ll discover different ways to create and edit tables with input masks, data validation, and lookups, and how to generate relationships between tables. You?ll learn how to make, edit, and format user input forms for more user-friendly databases, and you?ll find out how to make and run queries that filter and summarize your data into simple statistics. Finally you?ll learn how to generate attractive and easy-to-read reports that you can share in electronic or print form. Picture Yourself Learning Microsoft Access 2007 will help you make the most out of your Access experience. ... Read more

Customer Reviews (1)

The visual approach offers charts and screen samples throughout - in full color
There's no better beginner's introduction to Access on the market than this: it will appeal to any used to Office 2007 but new to Access, its database unit, and it tells how to create and share databases, use queries and forms, and create queries to summarize data. The visual approach offers charts and screen samples throughout - in full color - and covers all the basics.
... Read more

Product Description
This guide is designed to introduce novices to Access, the Microsoft Windows database. The tutorial style aims to provide information on concepts and complex features and covers the skills necessary to design real-world (complex) database applications. ... Read more

Product Description

Customer Reviews (7)

As titled this is a great book for beginners to Access
If you have not used Access 2003 before start with this book, its a great foundation for databases within Access. For those who have used it but are looking to build on their current knowledge you might be disappointed as this is literally a book intended for those who have not built or used a Access database before.

Amazing value
I found this to be perfect for my needs.I have Access 2003 at work.I was creating a database and though I hava had Access 2003 in college, had not used it to its fullest potential for some time. The examples and explanations were perfect!Thank you so much.I highly recommend this for anyone who needs a little help.It is also a very valuable resource.

Susan Manson
Eddington, ME

Not Enough Information
It's clearly written and is clearly aimed at the novice.I'd advise people to see how much they can learn from the program help rather than spend the money on this one.You'll probably need a book but you'll need one that's more comprehensive.

In spite of its actual length, the book seems like it's 20 pages long.It's a friendly, very basic, intro to Access.Unfortunately it's going to leave a lot of beginners hanging when they encounter the myriad real world situations the book doesn't cover.I would not advise buying this book without a reference manual to go with it.Example:I wanted to know the syntax for quoting character strings in comparisons.Nothing.In fact all of the comparison and selection by value examples in the book use numbers or dates.

Not what I had expected
This book leaves alot to be desired. Cover to cover, It seemed way too brief. I felt like I was being coached through a few topics that could be figured out by just playing around with the program. Im confused as to why the authors felt it necessary to sacrifice so many trees in order to offer a step by step walk-through of how to use the program's various wizard modes. It seems to me that anyone could open up access and walk themselves through the wizard without reading any of this book. The other 25%-35% of the book that does cover the design view is way to0 brief to be of any use.You barely get a taste of what's out there. Basically you feel like your still.... searching for the "Missing" information.

VERY WORTHWHILE
If you are new to Access and want to learn how to do things, this book is very helpful.If you are an experienced user and want to become an expert, this book may not have everything you need.We use this manual in conjunction with the Video Professor and between the two, we are now very comfortable with Access. ... Read more

Product Description
This book provides the definitive description of the JDBC(tm) API, the technology that enables universal data access for the Java(tm) programming language. This new edition has been updated and expanded to cover all of the JDBC 2.0 API, including the JDBC 2.0 core API and the JDBC Standard Extension API, the package that facilitates building server-side applications.

Containing in-depth explanations that go beyond the specification, this complete resource pairs a step-by-step tutorial with a comprehensive reference to all of the classes and interfaces.

For those new to Java technology, the book includes an introduction to the Java programming language and to SQL. It builds on this basic knowledge to walk you through creating a JDBC application-from setting up a database and establishing a connection to retrieving values from result sets and using prepared statements. In addition, the authors provide many examples along the way that demonstrate how to execute common tasks. The book proceeds to more advanced topics, focusing on the new features of the JDBC 2.0 API, including scrollable and updatable result sets, batch updates, SQL3 data types, custom mapping, and more.

You will also find an introduction to working with the JDBCmetadata API as well as information on rowsets, the technology thatmakes it possible to handle data sets from virtually any data sourceas JavaBeans(tm) components.

From array to XADataSource, a useful alphabetical reference provides concise but complete information on each class and interface in the JDBC API. Each entry includes an overview as well as a list and explanation of the methods and fields.

A chapter on mapping SQL types and types in the Java programming language, a summary of the new JDBC 2.0 features, and a glossary complete this indispensable resource for all database programmers.Amazon.com Review
The second edition of the JDBC API Tutorial andReference provides a worthwhile tour of the new features in JavaDatabase Connectivity (JDBC) 2.0 and serves well as a reference toSun's new standard for Java database programming.

Once you openthis book, it becomes quickly obvious that it is more comprehensivethan the first edition. The new edition begins with an overview of theJDBC API, including its architecture and overall design. Beginnerswill also be pleased with a short breakdown of the Java programminglanguage and SQL basics.

Early sections of the book walk through anapproachable tutorial of JDBC, concentrating on topics such asconnecting to databases, retrieving result sets, manipulating records,and handling database transactions. There's also coverage of usingstored procedures, including embedded SQL with SQLJ.

The book thenturns to new JDBC 2.0 API features, like scrollable cursors,updateable record sets, and batch updates. Experienced readers willappreciate how the authors show off JDBC 1.0 code before presentingthese new features. An explanation of SQL3 data types supported inJDBC 2.0 follow the discussion of the API features.

The bookprovides extensive support for finding and understanding recordsetsand databases, including the use of the oddly namedResultSetMetaData and DatabaseMetaData classes, whichhave been greatly enhanced in JDBC 2.0. (You can now write Java codethat customizes itself at runtime for almost any SQL platform.) Similar in spirit to the Microsoft OLE DB, the new JDBC 2.0 nowsupports rowsets, which let programmers work with any tabulardata store from within their applications.

Most of the book (over600 pages) functions as a reference containing every JDBC 2.0class. Presented alphabetically, each class comes with an introductorydefinition and a complete listing of its constituent members andmethods (including deprecated APIs). Final sections include a guide to"SQL to Java" mappings and tips for writing JDBC drivers.

Whetheryou are approaching JDBC for the very first time or are ramping upfrom JDBC 1.0, there is perhaps no better source for learning aboutthe enhanced powers of the new JDBC than this "official" guide fromSun. --Richard Dragan ... Read more

Customer Reviews (22)

No choice - a must
Of course this is not a tutorial or introduction of any kind.If you are looking to learn about databases or Java or SQL, look elsewhere.But come back when you are ready to do work!

There are many fine points to JDBC.Sure, the simple stuff is simple, but if you are looking for high reliability or high performance or both, you need to have a thorough understanding of your tools.

You won't find a better book if you are looking to find out exactly how JDBC is supposed to behave.

This book is written by the authors of the JDBC specification.For all intents and purposes, this book IS the JDBC specification.

On my job we treat this book as the JDBC specification.There are a couple of typos here and there, but it does indeed contain a complete description of every JDBC feature.

You will also need an equivalent SQL book to complement this one, because this book is ONLY about JDBC, not SQL. You will also have to reference the ODBC specification at times for some of the more arcane transaction semantics and such. Of course, any real database application is going to involve threads, and there is virtually no discussion of threads in this book, either.This book's singular focus on JDBC is what makes it what it is.

Like most Java books, it is overdue for an upgrade.

A Must For Your Bookshelf!
What can I say... if you do JDBC programming, you must have this book in your bookshelf. Great examples and super coverage of a very wide topic. You'll read it and continue to look back at it. Well worth the money!

an exceptionally comprehensive volume
JDBC is one of the most mature and widely used Java APIs. Even after the arrival of more recent tools and technologies like EJB's CMP and JDO, JDBC still remains a simple, fast, and reliable way of storing objects' state in an RDBMS. While conceptually this technology is quite straightforward, its evolution has made it more complex and voluminous. Many books have been trying to explain the main aspects of it over and over again, but the 3rd edition of "JDBC API Tutorial and Reference" goes far beyond that.

The book is divided into two major sections: the Tutorial and the Reference. Actually, there are four tutorials in the Part One: Basic, Advanced, MetaData, and Rowset. Here well-written explanations are followed by clear and detailed examples.

It is remarkable that Part Two, The Reference, is not your typical API reference with simply method signatures or redundant explanations of their arguments. This is an extremely well thought through description of how to use JDBC 3.0 API to achieve a particular goal. Every class has a solid overview, examples, schemas -- everything one needs to get the job done. The book also contains an Appendix for JDBC driver developers and another Appendix covering JDBC 3.0 API changes.

This book provides the most clear and comprehensive JDBC coverage that I have ever seen. It is not just a matter of its size of over 1200 pages, but although the result of a well designed book structure and clear delivery.

Mature and stable
Almost all practical commercial deployments of Java involve hooking to a back end database. Of the latter, relational databases are the dominant form. The first version of JDBC arose soon after Java was released, because of this compelling need. Since then, Sun has extended the functionality while still striving to keep its learning curve shallow, as compared to Microsoft's ODBC. Indeed, the latest Java 1.4 Standard Edition includes JDBC 3.0 in its entirety.

To document JDBC 3.0, Sun has put out the third edition of this book. The maturity of JDBC is reflected in its heft. The reference portion is voluminous. The tutorial section is like aged whisky; it goes down smoothly. Sun has had plenty of time to sandpaper rough edges and, based on user feedback, to add popularly requested capabilities.

The attraction of this book is that it describes a mature and stable product. In corporate terms, it is safe and conservative. In other words, you can develop with JDBC according to the book and be highly confident of success. At least insofar as your Java GUI conversing with the database. (The design of a GUI or a database is outside the purview of the book.)

The only JDBC book you will need
Whether you are a beginner, intermediate, or advanced JDBC programmer you will find useful information in this book.The book is divided into two sections.The first section is a tutorial on using JDBC which makes up four chapters. The tutorial starts with a look at JDBC 1.0.The next chapter looks at the additional features added to JDBC in 2.0 and 3.0.The third tutorial chapter looks at metadata.The final chapter examines the RowSet interface, which is complex enough to need its own chapter.

The remainder of the book (about 800 pages) is a reference containing a chapter for each class or interface in JDBC.Each chapter contains an overview of a class or interface, sections on anything of either special interest or complexity, and then a list of all the methods of the class or interface with complete descriptions.If a section applies to a particular version of JDBC, the version it applies to is clearly marked.The information contained in the reference is much more than you can find in the APIs.The reference section itself is well laid out to make the information you need easy to find.

This is probably the only JDBC book you will ever need.No matter which version of JDBC your database drivers support, you will find your answers in this book.The book is well written with clear explanations and plenty of code samples (which can be downloaded from the Sun web site) .Anyone working with JDBC will want this book by their side while they are coding. ... Read more

Product Description
This result-oriented primer explores real situations dealing with Web-based databased publishing. The Web Database Construction Kit is a step-by-step guide to publishing databases over the Web using already popular Microsoft Access and Visual Basic environments. ... Read more

Customer Reviews (4)

Not what the book claims to be.
The book is old with no updates, and while the book started off with good explanations, that quickly died.It seems like the book was getting too long, so the authors decided not to cover certain things, or would statethat what they weren't covering was easy to do (like secure transactions). Not a good reference book or how to manual.There are plenty of other goodbooks out there.I can see why the publisher no longer even acknowlegesthis book as theirs anymore.

The book's samples are not Win 98 or NT 4.0 compatible.
If you are running Win98 or NT. Don't Get This Book. The sample VB4 scripts run only on Win95 or NT3.4 and there are no updated versions available.

Well written! Very detailed and usefull material
I found this book to be very easy to read but also very good explaining the contents.The examples are great and also the CD-ROM.

A Very Good to start with Database Dynamic linking....
This book has all the things I need to start doing linking Database with the Web (Intranet) without learning a whole chunk of books. This is also a good book to start if you need to move to a more advanced Wed database programming using either Visual Basic ... Read more

Product Description

Get comfortable with Access 2010. Don’t just read about it: see it, hear it, with step-by-step video tutorials and valuable audio sidebars delivered through the Free Web Edition that comes with every USING book. For the price of the book you get online access anywhere with a web connection--no books to carry, updated content, and the benefit of video and audio learning. Way more than just a book, this is all the help you’ll ever need...where you want, when you want!

Learn fast, learn easy, using web, video, and audio:

• Show Me video walks through tasks you’ve just got to see--including bonus advanced techniques
• Tell Me More audio delivers practical insights straight from the experts

Audio sidebars featuring Ross Pimentel

UNLOCK THE FREE WEB EDITION--To register your USING book, visit quepublishing.com/using.

Customer Reviews (3)

Well written but could be more usable
Using Microsoft Access 2010 is carefully organized to guide users from a beginning to an intermediate level of expertise. The term "beginning" is relative, because Access requires significantly more tech-savvy than any other Office program. It won't hurt if you already have experience with previous versions of Access (although this book does not explain the differences between the 2010 version and any of the previous ones). But if you are a rank beginner, this book is a good place to start. It covers:

*Chapter 1: Manipulating Data with Databases and Tables
*Chapter 2: Using Queries to Retrieve the Data You Need
*Chapter 3: Using Forms to Edit and Enter Table Data
*Chapter 4: Using Reports to Print Information
*Chapter 5: Creating Your Own Databases and Tables
*Chapter 6: Relating the Information in Your Database
*Chapter 7: Enhancing the Queries That You Build
*Chapter 8: Building Powerful Forms
*Chapter 9: Building Powerful Reports
*Chapter 10: Automating Your Database with Macros
*Chapter 11: Sharing Data with Other Applications
*Chapter 12: Working with Web Databases

Author Alison Balter's writing style is crystal clear. However, the numerous screen shots in the print book are not--they are grayed-out, with type so small you need to press your nose against the pages. Perhaps publisher Que expects readers to mostly use the online book and other online material that is also provided. I prefer print books---yet I am still hip enough to be eager to build a new database in the latest version of Access.

Assumes Basic Knowledge of Database: Multimedia features Useful
Since Microsoft does not sell individual components of Microsoft Office, I have always been buying, against my free will, Microsoft Access since 1993 when I first purchased Microsoft Office version 3.0. But other than creating a simple databases like association address book, equipment serial numbers, software CD keys and registration numbers etc. I have never really used Microsoft Access much. So I got this book from Amazon to learn databases and how to use Access. In the description of the book they DO NOT tell you that you are expected to have basic knowledge of database.

But the book assumes some knowledge of database on your part and the first chapter starts with definition of relational database assuming that you already know "...tables, queries, forms, reports, macros, and modules that compose a complete system."

Then it covers manipulating data, using queries, reporting, building forms etc. and the last chapter 12 shows how to create the web databases. Once you know what a database is from another source, this book is straightforward. I wish the first chapter started with explanation of database.

One area the book completely ignores is how to integrate Access with other Microsoft Office components like Excel, Word, One Note etc. After all, the whole point of buying Access as a part of Microsoft Office is moot if you cannot blend it with spreadsheets, documents etc. Why force people to buy Access as a part of Microsoft Office if you cannot incorporateother components in a database?

The idea of providing online access to the book and demonstrating various steps by videos is novel:all publishers and books need to emulate that. Their registration process is cumbersome, first they make you register an account on QUE publisher web site and then to read the book you have to sign in again at the Safaribooksonline web site.

In the online book, at the end of each chapter they have four or more videos showing different steps of using databases. On the left hand side of web site they have a chapter with index of all the media - videos and audio. At the end of each chapter there is also one"Tell Me More" audio and sometimes it is useful. On the book jacket they claim "Tell Me More audio delivers practical insightsstraight from the experts"but I did not find that to be always true. Online access and the videos are really the best part of this book. Are they going to provide the online access for ever?

On the iPad, the text formatted nicely for reading on safarionline website but the videos could not be watched and audio could not be heard. I wish they would make this book more accessible on iPad either on the web site through Safari or in one of the e-readers like iBooks, Inkling etc.

Another feature they have with an icon is "LET ME TRY IT" giving you the illusion that it is multimedia interactive feature requiring your input for the steps. But it is misleading, all they do is describe the steps in text. Making it interactive would be great practice and learning tool. They have also not included any sample databases on the web site so you can play with them. Microsoft Office and other web sites have lot of databases that you can download, play with, and modify for your own use. But providing online access and multimedia is good beginning and interactive learning holds a lot of promise and potentiel. You can also find many videos on Microsoft Accesson YouTube and complement the learning from this book.

Once you get past the delusive descriptions, icons, and elaborate online registration process, the multimedia features of this book are innovative and if you have basic knowledge of database and you want to know how to use Microsoft Access, then this book can be useful.

Detailed Access book available with web edition!
I have referred several other access books but this book is organized in its own way. This book has been clearly organized with headings under each chapter. I like the "Let me try it" section. Sometimes it is boring to go through the text only and that's where this book is different with audio and video files to make your reading more interesting. This book has clear explanations and easy to read especially for people who already know Access. This book explains the types of queries, macros, subforms and subreports very well. It has lots of screenshots to explain the results of queries, reports and forms. It is a great book to read and learn even if you do not know Access earlier. ... Read more

Product Description
A friendly, step-by-step guide to the Microsoft Office database application

Access may be the least understood and most challenging application in the Microsoft Office suite. This guide is designed to help anyone who lacks experience in creating and managing a database learn to use Access 2010 quickly and easily.

In the classic For Dummies tradition, the book provides an education in Access, the interface, and the architecture of a database. It explains the process of building a database, linking information, sharing data, generating reports, and much more.

• As the Microsoft Office database application, Access may be the least understood and most challenging part of the Office suite
• Access 2010 For Dummies walks newcomers through building and using their first database
• Covers linking information in a database, setting relationships, modeling data, and building tables
• Explores how to extract data from Access and get specific answers, create forms, and export data in reports
• A section for more experienced users looks at analyzing errors and creating an interface

Fully updated for the newest version, Access 2010 For Dummies gets new Access users up to speed and helps veterans get the most from the Office database application. ... Read more