"Top Spin" wrote in message
...
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/da...ing/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.