Any book by John Viescas is excellent for beginning through advanced Access.
The Access Developer's Handbook by Ken Getz and others is excellent for
programming.
Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.
You can thank the FTC of the USA for making this disclaimer necessary.
