TableDesign and relationships

[Wilfredo Perez]

I am new to access and the database world. I need a good book so I can
understand good table design and relationships, I would like to get into VBA
and start making application, first in access than in SQL. I have played
with access before.

 

[tina]

i often recommend Database Design for Mere Mortals by Michael Hernandez. the
data modeling principles and methodology that you'll learn from that book
will apply to any relational database, regardless of what software you use
to implement it. you need to learn relational design principles *before* you
learn to use the software of your choice (such as Access). and unless you
already have a background in programming languages, suggest you take the
time to learn how to use the software *before* you get into more advanced
development using VBA. one good text that will give you a solid foundation
in using the Access program is Microsoft Access <version> Bible by Prague
and Irwin.

hth

 

[mnature]

"Access Database Design & Programming" by Steven Roman, put out by O'Reilly
publishing. Mine is a 3rd Edition, and covers up to Office 2003. Most large
bookstores will have a whole section devoted to O'Reilly computer books.