|
vb123.com |
|
|
Home Contact Us Order Software Search vb123 The Magazine that Access Developers loved to read and write for is back Article Index Here or Purchase Here
RSS &
Newsletter
Get Good Help
Like FMS Products? The Toolbox About The Editor Garry
Robinson writes for a number of popular computer magazines, is now a
book author and has worked on 100+ Access databases. He is based in
Sydney, Australia
|
The
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.
 Read what Peter Vogel, Editor of Smart Access had to say about the book... |
Is Your Database Secure ? Need to know more about how to protect
your database investment. Confused about Access security. Then have a
look at the book that Garry's wrote for Apress in 2003.
It covers best practise security and protection for
Access 97 upwards |
|
This book comes in developers and enterprise editions and can
be purchased together. If you are new to Microsoft Access, this book is
not for you. By chapter 3 of the desktop edition, the material is very
detailed visual basic code. These are books that you purchase when you
think you are starting to get on top of programming in Access. That
said, they generally have solutions that can be reworked for most complex
situations.
More... Purchase at Amazon Desktop
2000 Enterprise
2000
Both 2000 |
Microsoft Access Inside Out
by Helen Fedemma
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
The Definitive Guide to Excel VBA
by Michael Kofler
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
Database Access with Visual Basic 6.
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 McManus
Click Here for more books on Visual BasicFor books on promoting web sites, click here
More Details On Some Books
Access Developers Handbook 2000
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.