Beginning Access {YourVersion} VBA" by Smith & Sussman
Access Developer's Handbook.
http://mspress.microsoft.com/office/office2000/dev.htm
Designing Relational Database Systems", by Rebecca Riordan, from Microsoft
Press. Currently out of print, if you see a used copy anywhere, grab it,
quick.
Beginning Access <version> VBA Programming", from Wrox Press (where
<version> might be 97, 2000, or 2002)
Programming Microsoft Access Version <version>" by Rick Dobson, from
Microsoft Press
Access <version> Developer's Handbook", from Sybex. (The Access 97 edition
was one volume, later editions are in two volumes, both equally
indispensable)
Access DevelopersHandbook", Volume 1 and 2, authored by Getz and company,
published by SYBEX.
Using Microsoft Access 2000", Roger Jennings, Que Corp, 0-7897-1606-2
ACCESS 2002 Bible
'Microsoft Access Database Protection and Security"
http://www.apress.com/book/bookDisplay.html?bID=189
or
http://www.fmsinc.com/toplevel/books.htm
or
FMS Professional Solutions Group
http://www.fmsinc.com/consulting
or
Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com
or
"Running Microsoft Access 2000" by John Viescas is a great overview
type book, with an accompaanying CD with samples and examples that are
referred to in the book.
Microsoft® Office Access 2003 Step by Step
http://www.microsoft.com/products/i...643abc7f-ec43-95dc-3193-01899113eab5&type=ovr
Microsoft® Office Access 2003 Inside Out
http://www.microsoft.com/products/i...47cd483c-3662-0d9b-472d-60d3c217acef&type=ovr
Ken Getz, et. al - Access Developer's Handbook
http://tinyurl.com/392ke
and F. Scott Barker's Access Power Programming
http://tinyurl.com/2u7er
http://www.viescas.com/Info/books.htm#Database Design.
Books (alphabetical order by author) :
Mastering Access (insert version #) Alison Balter
Beginning Access 2000 VBA by Sussman and Smith
Running Access (insert version #) by Viescas
The Access Developer Handbook (by Litwin, Getz, et. al.) is an essential
book for Access developers. However, a beginner might find it a bit
intimidating; I know I do!
If I had to pick just one... it would be Running Access by Viescas.. Others
might have different (and equally valid!) recommendations..
See the recommended lists by John Viescas:
http://www.viescas.com/Info/books.htm
or the one by FMS Inc:
http://www.fmsinc.com/toplevel/books.htm
For SQL Server, I use Kalen Delaney's Inside Microsoft SQL Server 2000 but I
have not used other books so I can't say which one is best but Kalen
Delaney's suit my purpose at the moment. There are plenty of SQL Server
books so you can browse at a well-stocked bookshop.
Web Sites:
www.mvps.org/access/ The motherlode!
users.bigpond.net.au/abrowne1/tips.html
www.lebans.com
www.granite.ab.ca/accsmstr.htm
members.rogers.com/douglas.j.steele/AccessIndex.html
www.rogersaccesslibrary.com/
This is a short list of sites that come quickly to mind; there are many
more!
In addition, I would also strongly suggest the rest of the Microsoft Access
newsgroups at:
microsoft.public.access... etc..
More than anything else, I have found the free answers offered by kind
experts in relevant newsgroups to be invaluable. I have had hundreds of
questions answered over the last year or two, and continue to be grateful!
Finally you might find the following useful (and possibly humorous!)...
http://www.mvps.org/access/tencommandments.htm