Access Database Design and Programming (Nutshell Handbooks) [Paperback]

Steven Roman PhD (Author)

Editorial Reviews

Amazon.com Review

Access Database Design and Programming covers a lot of ground quickly but lucidly. Steven Roman begins with a description of general principles of database design, then describes the "relational algebra" that defines the meaning of such operations as unions and joins, introduces SQL syntax, and finally dives into the details of using VBA (Visual Basic for Applications) to write Access code. The result is a single book that can teach you all the basics of building database applications in Access. Portions of the book are heavy with logical equations whose effects can be hard to visualize, but Roman's judicious use of sample data makes it much easier to follow the operations being described. --This text refers to an out of print or unavailable edition of this title.

Product Description

While targeted at intermediate Microsoft Access users who are novice programmers, this second edition of the bestselling Access Database Design & Programming should appeal to all levels of Access developers. In particular, the new edition includes:

A discussion of Access' new VBA Integrated Development Environment used by Word, Excel, and PowerPointExpanded coverage of the VBA language itself, in response to reader requestsDiscussions of Microsoft's latest data access technology, called Active Data Objects (or ADO), and Open Database Connectivity (ODBC), which is intimately connected with ADO

For novice programmers, this book focuses on typically neglected, but nevertheless essential, knowledge for developing effective database applications. Its treatment of database design and queries gives intermediate and advanced developers a consolidated source of info, while its programming chapters constitute a handy reference to basic operations that can be performed using DAO or the Access object model.

See all Editorial Reviews

Product Details

• Paperback: 432 pages
• Publisher: O'Reilly Media; 2 edition (July 1, 1999)
• Language: English
• ISBN-10: 1565926269
• ISBN-13: 978-1565926264
• Product Dimensions: 9.1 x 7 x 0.9 inches
• Shipping Weight: 1.5 pounds
• Average Customer Review: 4.1 out of 5 stars  See all reviews (44 customer reviews)
• Amazon Bestsellers Rank: #1,584,731 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

55 of 56 people found the following review helpful:

4.0 out of 5 stars Access database for the mathematically minded, January 23, 2001

By	"cmjreview" - See all my reviews

This review is from: Access Database Design and Programming (Nutshell Handbooks) (Paperback)

In Access Database Design & Programming, the author uses very mathematical and academic language. The database design part of the book is focused on the mathematical theory of relational databases. The programming part of the book is a reference work to programming with VBA.

All parts of the relational database in Access will be mathematically defined and proven. It will have a name you most probably will find confusing, and far from what you are used to from the Access interface. Apparently the author follows the naming standards established in the academic world to prove the algebra. After all, he is a professor of Mathematics !

In the programming part of the book you will be introduced to the DDL, DML and DCL components included in Access. Also, these components will probably be completely unknown to you, if you have no previous programming experience. Further, the book makes use of DAO as opposed to ADO.

The book is perfect for someone, who has completed courses in Computer Science, Programming and Algebra, or with the equivalent knowledge and a mathematical/academic way of thinking. They will be able to read through the book in a fast pace, and immediately make use of Access at a high level.

If your background is different, I would recommend another approach to database design and programming. For database design, I recommend "Inside Relational Databases" by Whitehorn and Marklyn (ISBN 354076092X). To learn programming I recommend "Learn to Program with VB 6" by John Smiley (ISBN1902745000).

This book is going to split its readers in two groups: The mathematically and academic minded who will love the book for its concise language. And the "grass roots" among the Access users/developers, who will be looking for database samples or VBA code snippets to learn from, and find none.

You will probably ask yourself if you need to know this much theory and detail. But remember, a relational database operates purely on mathematics. It is difficult and tiresome to learn, but your reward will be well worth the effort.

38 of 39 people found the following review helpful:

5.0 out of 5 stars A Gem, February 13, 2000

By	"kareninpgh" - See all my reviews

This review is from: Access Database Design and Programming (Nutshell Handbooks) (Paperback)

So you're familiar with the Access interface and are comfortable with tables, forms, reports and macros. So what's next?

Simply put, choose this book if you have little to no programming experience and you're ready to go to the next level with Access database development. This book is truly for the advanced Access user, but the novice VBA programmer. Having spent many frustrating hours with other books that claim to be for this audience, I can wholeheartedly recommend this one. I needed a "primer" in VBA before moving on to more advanced treatments, and this one fit the bill.

For me, a bonus was the section on normalization. Well written and clear, it solidified and enhanced my understanding of sound database design .

Steven Roman...thanks so very much!

23 of 23 people found the following review helpful:

4.0 out of 5 stars Good and to the point....., May 26, 2000

By	Khalil Ahmad (NJ, USA) - See all my reviews

This review is from: Access Database Design and Programming (Nutshell Handbooks) (Paperback)

This book provides good overview of the database design in the first four chapters. Good tips to avoid data redundancy without losing data. Chapter 5 and 6 throws light on SQL, DDL and DML components of Access SQL, not too much but some how enough. Chapter 7 gives a little bit idea about the Database Architecture.

Then Chapters 8-13 provide basic introductory and definitive approach of VBA in Access with different data types, functions, sub-routines, control statements, etc.

Chapter 14-16, here goes the real thing about DAO. With couple of examples, author explained in very good manner about different aspects of Data Access Objects and how to open, create and query database/tables from within code.

Chapter 17, explains breifly about ActiveX Data Objects incl. ADO and OLE DB.

So over all, this book is very good and to the point. I would definitely recommend to the beginners who wanna learn MS ACCESS or who has a little bit knowledge and wanna improve it without wasting time and going through huge books. As far as, MS Access professionals are concerned, they may not find it very informative but still if they go direct through chapters 14-17, they may find something useful.