Programming Microsoft Access Version 2002 (Core Reference) [With CDROM]

by Rick Dobson

No Synopsis Available.

• Format: Paperback
• Language: English
• ISBN: 0735614059
• ISBN13: 9780735614055
• Release Date: January 2001
• Publisher: Microsoft Press
• Length: 1111 Pages
• Weight: 4.15 lbs.
• Dimensions: 2.2" x 7.6" x 9.6"

Customer Reviews

This is the most "MUST HAVE" Access book

This book really helped me to have a kickstart to become a professional access programmer.... it contains the best tricks to do whatever you want with Access....Besides the writer has writen the book in a way that is very comprehensive for every one....After this book I`m a real fan of Rick Dobson...He knows how to lead you to make you professional....

Great Help

I have read your book and applied some of the programming methods mentioned in it and found it very helpful.I have 20 years of software development experience mainly in themainframe area both here in Sydney, Australia and Boston, Mass. I recently decided to start my own consulting firm and develop business applications using Access. In the past four months, I have used your book to learn Access in order to develop aninventory and billing software package for one of my clients. I can honestly tell you that I learned a lot from your book, and I can even say that without your book, I would've not been able to finish the project.

Includes Much That You Will Not Find Elsewhere

This complete reference book is actually three books in one. It is the clearest available introduction to VBA coding. It provides explanations with a huge collection of Access VBA code. And it is a thorough presentation of what is new and powerful in Access 2002, especially concerning integration with SQL Server.This book is just the thing for anyone who wants to become a serious Access user or developer. It is the answer to the prayers of many Access users who have wanted a reference that would finally take them from the limited GUI Access interface into the more full and flexible features of VBA coding. The coding in this very large book is so extensive that I bet you could, if you wanted to, do every future Access project with just code and without reference to the GUI interface. You can tell that Rick Dobson loves to code and to pass on what he has learned.The explanations are very readable and give you the background necessary to actually understand why things work the way they do. Much attention is given to keeping you out of trouble by conveying a very clear understanding of operational issues not covered elsewhere. This includes successful integration of different versions of Access and SQL Server, getting the reference libraries correct, and even using Access with FrontPage (now included in Office XP Professional).If this reference indicates the way Microsoft Press books are headed, then I am going to look to add more of them to my reference collection in the future.Clarity, comprehensive, and Code, code, code!

Must have for Access Developers

Being a seasoned Access Veteran, I found the book most helpful in explaining ADO (New in Access 2000), explaining class modules and using Access with SQL Server. Most MS Press books in the past that have dealt with Access / VBA have been fairly "light" on these subjects, but this one goes in depth on these subjects. Also the chapter on XML does a good job introducing the platform to novice developers.Next to The Access Developer's Handbook Series by Litwin, Getz etc..and F. Scott Barker's Power Programming, I would say this is a "must have" for any serious Access Developer.

How to Deploy SQL and Web Solutions w/ Access XP

This book builds on Dobson's prior book "SQL Server with Access 2000" and ferrets out good solutions to some everyday needs like image processing and dynamically populated combo boxes. I'm a small business owner whose time is precious, but needs to get big picture solutions so not to be reworking stop gap efforts to streamline my operations. Being pressured to grow my application to many users (both trusted LAN and anonymous Web) and being comfortable with the graphical interfaces of Access, I found the the need to learn about programming ADO recordsets, Data Access Pages and ASP while determining the best solution. I have been overwelmed by the flexibility of MS solutions and options that are possible and needed some guidance in plain language to explain such terms as Objects, Properties and Methods, and what they meant to be programmed. Chapter 2 does a good job of that which is followed by a useful summary of the ADO library. Data Access Projects are lined out well along with some practical tips to incorporating SQL Server 2000 as a data source. He further builds upon this model and shows how to dynamically (!) create web pages from the Access Project using MS Frontpage XP, the resultants being Active Server Pages! I have found while the Access 2002 graphical tools are helpful, Dobson explores how to control the code behind the power of the XP Office release.I have found the code to be tight and well commented. I'd urge anyone interested in harnessing the full power and speed of deployment of Access 2002 and the Office XP suite to add this book to their "How To" library.