Books for Prep | |
by: Steven Roman  List Price: $34.95 Amazon.com's Price: $23.07 You Save: $11.88 (34%)Prices subject to change. Availability: Usually ships in 24 hours
This item ships for FREE with Super Saver Shipping.
Binding: PaperbackDewey Decimal Number: 005.7565 EAN: 9780596002732 Edition: 3rd Format: Illustrated ISBN: 0596002734 Label: O'Reilly Media, Inc. Manufacturer: O'Reilly Media, Inc. Number Of Items: 1 Number Of Pages: 448 Publication Date: January 07, 2002 Publisher: O'Reilly Media, Inc. Studio: O'Reilly Media, Inc. Related Items:
Browse for similar items by category: Click to Display Editorial Review: 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. Product Description: 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:
Average Rating:
 Rating:  - Excellent intermediate Access bookI have been using Access and VBA for a few years, without any formal training in relational database or programming. In this concise book, Steven Roman managed to give a strong foundation in the theory of relational databases, VBA and DAO. Armed with this knowledge, I now have the confidence to dig deeper in these three topics and study more advanced material. One downside though: I found the last part of the book on ADO quite confusing. Steven Roman prefers DAO to ADO and ... Read More Rating: - Just What I NeededIn seeking out materials to train myself on Access 2003, I have found several books that have done adequate or good jobs of teaching the program. Most of them, however, did not do so well on teaching database theory or on instructing in how to use the native programming environment. This book helped to fill in the gaps. It is not perfect but it certainly was a good place to start. The treatment of database theory is just that. It is a treatment of theory. It explains the concepts in a semi ... Read More Rating: - this book got me started on databases...Years ago, I've picked this book up to learn Access... I haven't used Access for quite a while now (mostly an Oracle person now), but I still have fond memories of this book. Not only does this book teach you Access, and it does that very well, it also go through the database fundamentals. An overall great book, imho. Rating: - If you own 2 Access books, this should be one of themI first read Steven Roman's book on Access a few years ago when it was written for Access 97. I recently bought a copy of the current version as a reference. What I liked about Steven's books was that he took seriously his coverage of normalization, which is rare amongst books on Access. If you're new to database programming, you need to learn the basics of normalization. In my experiences, I've come across a lot of databases designed by beginners that exhibit a "spreadsheet" type of understanding ... Read More Rating: - Note to Shannon - DAO is not a problem.I haven't read this book, yet. But, reviewer, Shannon, complained about not being able to get it to work with DAO. The problem is in References. Her database is probably set with a reference only to ADODB. In Module View, just select Tools | Reference and select DAO (Data Access Objects) as the reference. Then, you should be fine. 
In association with Amazon.com | |