Access Database Design and Programming, 2nd Edition
By Steven Roman, PhD
Publisher: O'Reilly Media
Released: July 1999
Pages: 432

When using software products with graphical interfaces, we frequently focus so much on the details of how to use the interface that we forget about the more general concepts that allow us to understand and put the software to effective use. This is particularly true of a powerful database product like Microsoft Access. Novice, and sometimes even experienced, programmers are so concerned with how something is done in Access that they often lose sight of the general principles that underlie their database applications.

Access Database Design & Programming, 2nd Edition, an update to the bestselling first edition, features:

  • A discussion of Access' new VBA Integrated Development Environment, which, for the first time, is the one used by Word, Excel, and PowerPoint
  • An expansion of the discussion of the VBA language itself, in response to reader requests
  • A discussion of Microsoft's latest data access technology, called Active Data Objects (or ADO), along with a discussion of Open Database Connectivity(ODBC), which is intimately connected with ADO

Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, this book focuses instead on the core concepts, enabling programmers to develop solid, effective database applications. As a result, important topics such as designing forms and reports, database security, database replication, and programming for multiuser applications are simply not discussed. This book is a kind of "second course" in Access that provides a relatively experienced Access user who is new to programming with the frequently overlooked techniques necessary to successfully develop in the Microsoft Access environment. Anyone interested in learning Access in-depth, rather than just scraping the surface, will enjoy and immensely benefit from reading this book.

Although this book is really an introduction directed to intermediate Microsoft Access users who are novice programmers, it should appeal to all levels of Access developers. For novice programmers, it focuses on a key body of knowledge that is typically neglected, but is nevertheless essential for developing effective database applications. For intermediate and advanced developers, its treatment of database design and queries provides a handy treatment that otherwise has to be gleaned from relatively uninteresting textbooks, while its programming chapters constitute a handy reference to some basic operations that can be performed using DAO or the Access object model.

Table of Contents
Product Details
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyAccess Database Design and Programming, 2nd Edition
 
4.5

(based on 15 reviews)

Ratings Distribution

  • 5 Stars

     

    (11)

  • 4 Stars

     

    (3)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (1)

Reviewed by 15 customers

Sort by

Displaying reviews 1-10

Back to top

Previous | Next »

 
5.0

A timeless reference, an excellent start

By jsglazer

from Washington, DC

About Me Designer, Developer, Maker

Verified Reviewer

Pros

  • Accurate
  • Concise
  • Easy to understand
  • Helpful examples
  • Well-written

Cons

    Best Uses

    • Intermediate
    • Novice
    • Student

    Comments about oreilly Access Database Design and Programming, 2nd Edition:

    While it is highly unusual to use the word timeless to describe a tech book, ADD&P truly fits this moniker. I bought the second edition a decade ago. Across multiple jobs, three continents, and several versions of Access, the book continues to provide value as a quick reference for how-tos and as refresher on db design and theory. ADD&P addresses a perennial challenge for new developers--that is, there exist many ways to build functionality...which to use and why? ADD&P provides enough theory that the reader can understand and use a seemingly endless variety of answers (from this book, other Access books, and the web). ADD&P lays the foundation for SQL, VBA, and interface design. After digesting ADD&P, the Access 'bibles' and user forums (which didn't exist in 99!) became much more useful for me.

    I recommend that every db/Access beginner read the first 7 chapters, twice. I highly recommend this book for anyone who develops Access applications whether using the GUI, coding VBA, or hand-scripting SQL.

     
    5.0

    great book

    By motolep

    from Undisclosed

    Comments about oreilly Access Database Design and Programming, 2nd Edition:

    let me begin thanking Dr.Roman and o'reilly team for this great book.

    realy great explain, great material, all other access database books focus on access interface and doesn't focus on database design.

     
    5.0

    Access Database Design & Programming, 2nd Edition Review

    By Frank

    from Undisclosed

    Comments about oreilly Access Database Design and Programming, 2nd Edition:

    I recommend reading a more "soup to nuts" book on Access before you read this one, unless you understand Access and how it works (forms, reports, queries, navigating the interface). If you have an understanding of Access, but aren't sure how to get started, this is the book for you. The examples are well described, often in more than one way.

    The better aspects of the book include; description of keys; relationships; normalization; and superb code examples for VBA. As a person who is trying to become a VB programmer, I was amazed by how clear and sensible the examples were.

     
    5.0

    Access Database Design & Programming, 2nd Edition Review

    By Ernest Pergrem

    from Undisclosed

    Comments about oreilly Access Database Design and Programming, 2nd Edition:

    10 minutes scanning the book and I'm already a fan of Steven Roman. My company doesn't use SQL Server so I was especially pleased to see "... the SQL Server provider is used most often in examples, so we will not do it here" when I came upon Page 326. Great. Examples I can really use.

     
    5.0

    Access Database Design & Programming, 2nd Edition Review

    By Joseph Fluckiger

    from Undisclosed

    Comments about oreilly Access Database Design and Programming, 2nd Edition:

    O'reilly does it again. I've set aside my other Access books for something much more concise, relevant and deep than everything else out there. Unlike other Access books, at the end of each chapter I am armed with not just a "how to" but also a "why". This is not Access Database for Idiots, this is Access Database for professionals. Thank you Mr. Roman and O'reilly. This is the third O'reilly book I have purchased and it will not be the last.

     
    5.0

    Access Database Design & Programming, 2nd Edition Review

    By The great programmer

    from Undisclosed

    Comments about oreilly Access Database Design and Programming, 2nd Edition:

    This is one of the best books on access database programming that I have seen. It provides clean informative explanations on everything that you need to know to get started programming access or to refresh your skill. I highly recommend this book.

     
    5.0

    Access Database Design & Programming, 2nd Edition Review

    By Kevin Wells

    from Undisclosed

    Comments about oreilly Access Database Design and Programming, 2nd Edition:

    I recently had to refresh my Access skills for work. I looked at an Access book from Microsoft Press. Five boring chapter's later I didn't learn anything I didn't already know. Access Database Design and Programming 2nd Edition got right to the nitty gritty. I even created the Library Sample Database and used it while reading the book. Wonderful!

     
    5.0

    Access Database Design & Programming, 2nd Edition Review

    By R.H. Sekaly

    from Undisclosed

    Comments about oreilly Access Database Design and Programming, 2nd Edition:

    I started reading and using the First Edition of this book several years ago, and was impressed with the style and content. The Second Edition has upheld my faith in both the author and O'Reilly with respect to the quality of their technical books. Excellent work and right on topic!

     
    5.0

    Access Database Design & Programming, 2nd Edition Review

    By Neil Tevepaugh

    from Undisclosed

    Comments about oreilly Access Database Design and Programming, 2nd Edition:

    To save that this book has proven to be invaluable to me is to under estimate it's importance. The explanation of "CurrentDb" has revitalized an application.

    My thanks to Steve Roman.

     
    4.0

    Access Database Design & Programming, 2nd Edition Review

    By Rob Barulich

    from Undisclosed

    Comments about oreilly Access Database Design and Programming, 2nd Edition:

    This excellent book is exactly what I was looking for to learn relational database theory and design. I doubt there is a better introduction to the subject than this concise, well-written guide.

    Displaying reviews 1-10

    Back to top

    Previous | Next »

     
    Buy 2 Get 1 Free Free Shipping Guarantee
    Buying Options
    Immediate Access - Go Digital what's this?