Using Microsoft Access 2000: Special Edition

I had used Access 97 in two previous jobs, and had to build a small database in one of them. I knew, however, that I could do much more with it, and since I had Office 2000 at home I bought this book to improve my skills in Access 2000. I sought a good, thorough, one volume reference work and found it! As the author discusses early on, the first fifteen chapters walk you through a solid understanding of the basics of Access 2000 (e.g. building an application, tables, queries, forms, and reports). Each chapter has exercises that make use of the sample database that comes with Access, and I strongly recommend that you do these exercises (I only wish Excel had something comparable). I am now interested enough in Access 2000 to go ahead and want to learn SQL and perhaps even VBA. Later chapters of this book contain introductions to those topics, as well as a good chapter on relational database design. I have not used the CD-ROM that comes with the book as much as I had expected, but it contains much material that supplements what is in the book (e.g. an additional database to practice with). My only caution is that this may not be the best book for those who are totally, completely new to Access (you can get the Dummies title for that). However, if you want a well rounded one volume reference book on Access, I strongly recommend this title!

This is not a book for beginners!! If you are an experienced Access programmer, you will get a lot out of this publication. It is well worth the purchase price and an order of magnitude ahead of some books out there that cost considerably more!

I am only on chapter six of this book, and I already LOVE it. I've read MANY Access books, and have never gotten much out of them. Roger has a real gift of being able to guide you thorugh the program smoothly, in a "real world" way. I don't feel like i'm being fed "menu item descriptions". I'm being led thorugh database development, with procedured bewing described on an as needed basis... and yet NOTHING's being left out! Just trust me. If you are new or not 100% competent with Access 2000, and want to ENJOY learning MORE that just how to "click on this to do this", BUY THIS BOOK.

I recently used SEUMA2K as a reference in an introductory course in Database Management Systems. Over the duration of the class I became progressively more impressed with both the breadth of the content and the clarity of the presentation. Obviously, this was not Mr. Jenning's first encounter with Access.I also found that the new features of A2K were very well delineated and the production quality of the book was quite high. I don't quite understand what the reader felt about .asp belonged in a text on A2k - but certainly ADP's were given an adequate discussion given their novelty and lack of specifics from Microsoft.It was also apparent that the author really has a grasp of database systems that goes well beyond Access. The short section on Data Warehouses and OLAP was typical - well beyond Access, but nicely added in context.I can recommend it well.

I've purchased every edition of Roger's "Special Edition Using Access" series since version 2.0. Each edition has fully covered what I've needed to know about the new releases, and has provided insights into enhancements to (or bugs introduced into) existing functionality.Contrary to the remarks by the reviewer from Texas, there's an entire chapter devoted to Data Access Projects (DAP) and another to Access Data Projects (ADP) and the Microsoft Data Engine (MSDE). The possible reason for limited ASP (Active Server Pages) coverage is that Microsoft removed the ability to convert forms to ASP from Access 2000.All in all, I've always considered Roger's books to be the best bet for all serious Access users, beginning to advanced.