Skandus

 

Home
Services
Visual Basic
Office Tips
Geology
Archaeology
Contact
Downloads
Book Reviews
Publications
 

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.

  Access Developers Handbook 2000 
 by Litwin, Getz and Gilbert

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...  
Recommended for advanced programmers

Purchase at Amazon Desktop 2000  Enterprise 2000  Both 2000  
Access 97

  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 Basic

VBScript Books

The following table of books, are ones that I have found useful in learning VBS. Many of the books are new, as when I was first learning it during VBS 5.0 most of the books were old and based on VBS 3.0 and some of the commands and a lot of the examples on web sites and in books just did not work with the Version 4.0 Browsers.

Click Here WINDOWS SCRIPTING HOST: This book, is Directed more at Network and systems people using the Windows scripting Host to automate their system. Particularly useful if you intend replacing those pesky *.BAT files we have come to love.
Click Here Windows Scripting Bible: A basic but good introduction to Visual Basic Script. All examples are doubled up in J Script (In case you want  to learn it as well!). Aimed more at the Sys Admin side, but still a good start.
Click Here SAM'S Teach Your Self Windows Scripting Host: AS Usual a catapult launch into the world of scripting. IT won't teach you how to program, but it does teach you the syntax and commands. A good mix of internet and Sys Admin examples.
Click Here VBSCRIPT IN A NUTSHELL: Paul Lomax, one of the early adopters of the earlier VBSCRIPT languages on the web is one of the Co-Authors. A good start say I. Good beginner as well as no nonsense reference.
Click Here Learning : Another Paul Lomax book, good start for beginners, however this was written in 1997 and before version 5.0 of the scripting host. Some of the examples will not work with ver 4.0 Browsers.
Click Here VBscript Programmer's Reference: This is an excellent book, however it was written in 1999 and covers Version 5.0 of the WSH, none the less and excellent coverage of server and client applications in internet and Sys admin. Also has good coverage of ASP.
 written by Scott McManus

eMbedded Visual Basic Books

Click Here eMbedded Visual Basic: Windows CE and Pocket PC Mobile Applications. This book has only just come on the market, Nov 2001. It is an offering form SAMS group and as you would expect is an entry level into application development. It assumes you are able to do basic programming in VB. It does have some good gruntty stuff though on socket communications using IrDA and TCP/IP.  
Click Here The Windows CE Technology Tutorial: Windows Powered Solutions for the Developer: I admit, this was my bible and kick start to programming for My HP Jornada 720. In conjunction with a Visual Basic Programmers Journal article (I think reproduced here at Microsoft) written for the old VB 6.0 add in software. I recommend this book strongly as it outlines both C++ and VB as well as the CE operating system. Active Sync is also incorporated for a complete approach to developing in the Small end of town!
Click Here Pocket PC Database Development with eMbedded Visual Basic:Aimed only at the VB market and concentrating on killer apps!
Click Here Windows CE 3.0 Application Programming (With CD-ROM): Aimed at the operating system, very good though, with all examples in eMbedded C++
Click Here Pocket PC, Handheld PC Developer's Guide With Microsoft Embedded Visual Basic: This is authored by one of the co authors of the above book and concentrates only on using VB. It is to be released September 2001
 written by Scott McManus

 

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. 

Purchase Here

 

books video music