Access Database Design & Programming, 3rd Edition
By Steven Roman, PhD
Publisher: O'Reilly Media
Final Release Date: January 2002
Pages: 450

Access Database Design & Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. When using software products with graphical interfaces, we frequently focus so much on the interface that we forget about the general concepts that allow us to understand and use the software effectively. In particular, this book focuses on three areas:

  • Database design. The book provides an enjoyable, informative overview of database design that carefully shows you how to normalize tables to eliminate redundancy without losing data.
  • Queries. The book examines multi-table queries (i.e.,various types of joins) and shows how to implement them indirectly by using the Access interface or directly by using Access SQL.
  • Programming. The book examines the VBA integrated development environment (IDE). It then goes on to provide an excellent introduction to Data Access Objects (DAO), ActiveX Data Objects (ADO), and ADO Extensions for Data Definition and Security (ADOX). These sections serve as a handy introduction and primer for basic database operations,such as modifying a table under program control, dynamically adding and deleting a record, and repositioning a record pointer. The concluding chapter focuses on common programming problems, such as computing running sums and comparing two sets.
Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, Access Database Design &Programming instead focuses on the core concepts, enabling programmers to develop solid, effective database applications. This book also serves as a 'second course' in Access that provides a relatively experienced Access user who is new to programming with the frequently overlooked techniques necessary to develop successfully in the Microsoft Access environment.Anyone interested in learning Access in depth, rather than just scraping the surface, will enjoy and benefit immensely from reading this book.
Table of Contents
Product Details
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyAccess Database Design & Programming, 3rd Edition
 
4.9

(based on 8 reviews)

Ratings Distribution

  • 5 Stars

     

    (7)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 8 customers

Sort by

Displaying reviews 1-8

Back to top

 
5.0

it's really helpful book. ready to buy,

By helmi hamzah

from malang

Verified Reviewer

Comments about oreilly Access Database Design & Programming, 3rd Edition:

wonderful book, the explaining is very clear..

(1 of 2 customers found this review helpful)

 
5.0

Excellent Book

By Motolep

from Undisclosed

Comments about oreilly Access Database Design & Programming, 3rd Edition:

this book is very benefit and very excellent.

Unlike other Access books,most access database books focus about access interfaces , but this books focus on the design & programming rules.

I advise every one who want to learn access database to buy this book .

(4 of 4 customers found this review helpful)

 
5.0

A true no-nonsense book

By Samid_V

from Undisclosed

Comments about oreilly Access Database Design & Programming, 3rd Edition:

In my experience of reading beginner´s books, I have only encountered authors that think you have never seen a computer in your life and keep everything as simplistic as possible. Steven Roman is not that kind of author.

This book is a perfect introduction not only to Access but to Database Design. The author first introduces some mathematical concepts regarding databases and keeps building a strong ground based on that. SQL queries, VBA programming, ActiveX Data Objects, everything is here challenging the reader in a highly gratifying manner.

I look forward to read all the Roman Saga.

(1 of 1 customers found this review helpful)

 
5.0

Access Database Design & Programming

By Alex G

from Undisclosed

Comments about oreilly Access Database Design & Programming, 3rd Edition:

A clear, informative guide to Access programming. I got this book due to it's coverage of ADO and ADOX, as most books only seem to cover this in the context of ASP. It was very informative in these respects but also useful for the sections of Relational Algebra. This book now lives on my desk and I use it at least once a week. A must for anyone who has to programme Access on a regular or semi-regular basis.

(1 of 2 customers found this review helpful)

 
5.0

Access Database Design & Programming, 3rd Edition Review

By *

from Undisclosed

Comments about oreilly Access Database Design & Programming, 3rd Edition:

Good price and well written informative book about access database design and design. Nothing more nothing less!

Emo

 
4.0

Access Database Design & Programming, 3rd Edition Review

By anom

from Undisclosed

Comments about oreilly Access Database Design & Programming, 3rd Edition:

really nice book especially explaining design, DAO, VBA

need more infos on ADO !

 
5.0

Access Database Design & Programming, 3rd Edition Review

By Tristan Blais

from Undisclosed

Comments about oreilly Access Database Design & Programming, 3rd Edition:

I really recommand this book. Its absolutly amazing. Anyone who has a hard time understanding normalization or other database design concepts will find this book a life saver. Its also a great refresher or reference for others who have to use Access from time to time. I'm looking forward to this 3rd Edition. In fact, I'll buy it today. Keep up the great work!

(1 of 1 customers found this review helpful)

 
5.0

Access Database Design & Programming, 3rd Edition Review

By h

from Undisclosed

Comments about oreilly Access Database Design & Programming, 3rd Edition:

as a reader of v.2 i was interested to see what was new in v.3. basically, all of the good stuff in the prior book was kept intact and some new good stuff was added. my primary complaint is that the size has grown enough so that it doesnt use lay-flat binding. as the preface mentions, it added a couple extra chapters at the end for ADOX and some more example problems. the examples are heartily recommended, but the ADOX was difficult to follow (not the authors fault, but rather MS for making it so hard to do). i liked the change in the grammar from 1st plural to 1st singular so that sentences went from "we can do xxx" to "i now do xxx". yet this jarred when i came across politically-correct examples later on that referred to "she can" when i assume the author is male. but this is a nitpick when the book is decidedly general. as a general book on access and db-design it is without peer. if you buy it for no other reason that to understand how to normalize your initial db-design then it is money well-spent.

Displaying reviews 1-8

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $31.99
Formats:  DAISY, ePub, Mobi, PDF
Print & Ebook: $43.99
Print: $39.99