Customer Reviews

Programming Microsoft Access Version 2002 (Core Reference) (Pro Developers)

5 star:		(4)
4 star:		(0)
3 star:		(0)
2 star:		(0)
1 star:		(0)

 

 

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!

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.

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.

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 the
mainframe 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 an
inventory 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.