Access Book

  • Thread starter Thread starter TLC
  • Start date Start date
T

TLC

Can anyone recommend a good Microsoft Access resource
book? It is needed for possibly beginning through
intermediate.

Thanks!
 
I like John Viescas too, I have his Using Access 2000 but I am not sure if I
would use it for a beginner, I did like half the book, around page 350, and
still not very fluent in how to do a database from scratch, I would
recommend Microsoft's Step by Step series.

--
Manuel Banuelos
BSIT Online Student
University of Phoenix
(e-mail address removed)

rpw said:
If there is a bookstore near you go browse through the books on Access to
Click to expand...
find one that suits you. I have several books now, but if I had to choose
only one it would be Access 2003 Inside Out by John Viescas. It's very
comprehensive, and it includes a section on designing an Access application
in addition to the "how to" build tables, queries, forms, reports, VBA
modules, functions, etc.
 
Everybody has preferences which is why I suggested going to the bookstore
first. Is the Step-by-Step series good through intermediate (as the op
requested)?

I don't know what John has in 'Using A 2000', but the bit he had in 2003 was
just enough for me to get rolling on my first project. It seemed like all
the other books I'd bought told how to build tables, queries, etc. but not
anything on designing it before you start the building. Plus, the language
doesn't seem like it's for PC novices or complete idiots. I have some Excel
skills and some experience using a db too, so the book fit my
personality/skill level.

Rick...
 
The Step-by-Step books are good for complete novices. For intermediate to
advanced all-round Access books, look for books by John Viescas, F. Scott
Barker or Roger Jennings. For books that focus mostly on code and developer
issues, look for the "Beginning Access <version> VBA Programming" book from
Wrox Press, Rick Dobson's books from Microsoft Press, and the "Access
<version> Developer's Handbook", from Sybex. For database design, see
Rebecca Riordan's "Designing Relational Database Systems" (second edition
coming soon, I hear) and Steven Roman's "Access Database Design and
Programming". If you're interested in using Access as a front-end to SQL
Server, look for "Microsoft Access Developer's Guide to SQL Server", by Mary
Chipman and Andy Baron, and if you're interested in ADPs, look for
"Microsoft Access Projects with Microsoft SQL Server", from Microsoft Press.

Don't forget to invest in a good bookshelf - the cheaper ones have been
known to collapse under the weight! :-)

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Those are good choices. A couple I would add (personally) are Alison
Balter's "Mastering Access 2000 Development" (covers basics well and also
VBA) and F. Scott Barker's "Access 2000 Power Programming". Recently I came
across Helen Feddema's "Expert One-on-One Microsoft Access Development" (for
2003 version but covers back to Access 2000). The first two are especially
heavy, so you'll want to choose a slow shipping method or a sturdy bag to
carry them home in, as well as the rugged bookshelves.

-Gary
 
Back
Top