VB123 Book Suggestions
These recommendations include specific recommendations if the technical literature on a topic is very detailed. Topics covered include MS Access, VB, VB Script, Embedded VB. Naturally we need to promote Garry's book first up.
This book is a good general A-Z reference for people who understand a bit of programming and need a general reference for Access 2002. The book takes you through all the things that you would normally be involved in an Access project. There are plenty of pictures to guide you through most tasks. This book would provide a good reference guide for your first few Access projects.
Recommended if you have < 6 months Access experience
Click Here to purchase this book at Amazon
Click Here for more Microsoft Access Books at Amazon
In a recent project, I was required to turn an Excel spreadsheet into the equivalent of a shrink wrapped application. To help with this exercise, I turned to a book as the Excel help really didn't provide me with enough background on how this could be achieved. The book that I selected was "The Definitive Guide to Excel VBA" by Michael Kofler. A couple of weeks later and the Excel spreadsheet now looks like an application because it has the following attributes. It installs like a program, it opens like a program with form based menus, the reports look just like Access Reports and the user is completely sheltered from the complexities of this 5 sheet Excel monster. Really I could not have achieved this without a book like this. Garry Robinson - Editor of Access Unlimited.
Click Here to purchase at Amazon
By Jeffrey P .McManus
When it comes to VB and Data access Jeffrey P is one of the experts he is regularly featured in the Visual Basic Programmers' Journal and has written several books on the subject. This book is a pleasure to read. It is well written in concise and informative language. Every point is illustrated with examples. The Authors code is included on CD.
We learn the concepts of data base design, User Interfaces and query writing. All of the data access technologies are covered DAO, RDO and ADO as well as 3 tier client server systems with ASP and SQL Server.
A whole chapter is devoted to exporting/reporting data. - The whole reason we have databases is to produce a report. Many great data storage systems are let down by their unprofessional reports.
There is excellent reviews and how-tos of third party tools such as Sheridan DataWidgets and VideoSoft VSFLEX controls.
This book is a great step up to the next level of Visual Basic. It is also a must read for anyone taking the MSCD exams 70-175 and 70-176 as it covers concepts that may be lacking in other books devoted to course curriculum.
When I read this book i was floundering with my data access and was so confused i had an application that used a mixture of ADO, DAO and Access Automation. After reading this book I "got straight" and streamlined my application and both it and I are much more happier for the experience.
Rating 5 out of 5 stars. Click Here To purchase this book from Amazon written by Scott McManusClick Here for more books on Visual Basic
For books on promoting web sites, click here
More Details On Some Books
The chapter on Securing your application in the Enterprise book (Access 2000/2002) is over 100 pages in length and covers security for Jet in great detail. There are also very detailed examples on Jet programming using DAO, ADOX and even the new SQL extensions introduced into ADO in Access 2000. There is less detail on security for data pages and ADP projects. Highly recommended if the white security paper (written by the same authors does not go far enough). The Access 97 book also covers the topic but does not have to cover ADO, SQL server and Data Projects.
The chapter in the desktop book on "Form Design and Handling" goes into great detail on the difficult topic of managing multiple instances of forms. If you want to open the same form twice without copying it in the database container, this would be of great value.