|
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
|