Book recommendations, please

[Top Spin]

I have been fooling around with Access on and off for a couple of
years -- mostly simple applications with only a few tables and simple
relationships. I know the basics for the most part and I have a
general awareness of relational concepts, but I don't feel that I
really fully understand database design.

So, I'd like to get a couple of books to study so I can get a better
comprehension of the design concepts. I am about to tackle some
slightly more complex applications and I would like to do them based
on sound principles.

Here are several books I have heard about.

Database Design for Mere Mortals by Michael Hernandez, John Viescas,
Addison Wesley (2003).

Designing Effective Database Systems by Rebecca Riordan, Microsoft
Press, (2005)

Inside Relational Databases by Mark Whitehorn, Bill Marklyn,
Springer-Verlag (2001)

Any comments on these or other recommendations?



Then I think I would like a book or two on using Access in particular
including UI and form design and other Access-specific tips and
tricks.

The books I have heard about in this area are:

Access 2002 Developer's Handbook Set by Paul Litwin, Ken Getz, Mike
Gunderoy, Sybex (2001)

Alison Balter's Mastering Access 2002 Desktop Development by Alison
Balter, Sams (2001)

Access 2003 Bible by Cary Prague, Michael Irwin, Jennifer Readron,
Wiley (2003)

Access Cookbook, 2nd Edition by Ken Getz, Paul Litwin, Andy Baron,
O'Reilly (2004)

Building Microsoft Access Applications by John Viescas, Microsoft
Press (2005)

Microsoft Office Access 2003 Inside Out by John Viescas, Microsoft
Press (2003)

Using Microsoft Access 2003 by Roger Jennings, Que (2003)

Microsoft Access 2003 Step-by-Step by Microsoft Press (2003)

Thanks

--
Running MS Office 2K Pro
PC: HP Omnibook 6000
OS: Win 2K SP-4 (5.00.2195)
Email: Usenet-20031220 at spamex.com
(11/03/04)

 

[Chris2]

I have been fooling around with Access on and off for a couple of
years -- mostly simple applications with only a few tables and simple
relationships. I know the basics for the most part and I have a
general awareness of relational concepts, but I don't feel that I
really fully understand database design.

So, I'd like to get a couple of books to study so I can get a better
comprehension of the design concepts. I am about to tackle some
slightly more complex applications and I would like to do them based
on sound principles.

Here are several books I have heard about.

Database Design for Mere Mortals by Michael Hernandez, John Viescas,
Addison Wesley (2003).

Designing Effective Database Systems by Rebecca Riordan, Microsoft
Press, (2005)

Inside Relational Databases by Mark Whitehorn, Bill Marklyn,
Springer-Verlag (2001)

Any comments on these or other recommendations?

Some handy sites:

http://www.utexas.edu/its/windows/database/datamodeling/index.html

http://www.datamodel.org/

Access 2002 Developer's Handbook Set by Paul Litwin, Ken Getz, Mike
Gunderoy, Sybex (2001)

Yes, very good.

Access Cookbook, 2nd Edition by Ken Getz, Paul Litwin, Andy Baron,
O'Reilly (2004)

Quite handy, but not universally applicable. Contains solutions to
common problems by category.

 

[Chris Reveille]

Here is some books and links that have helped me. There
are more I am sure

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


Chris