|
Access Database Design & Programming (3rd Edition)
 |
Author: Steven Roman
List Price: $34.95
Our Price: Click to see the latest and low price
ISBN: 0596002734
Publisher: O'Reilly & Associates (01 January, 2002)
Edition: Paperback
Sales Rank: 30,140
Average Customer Rating: 4.18 out of 5
|
Customer ReviewsRating: 2 out of 5
DAO Disasters
Like the other hapless guy, I could not get the DAO to run under Access 2002. The cover says "access 2002" and yet there is no explanation of which references to assign so that the DAO code put forth in the book will run. After setting the references that Microsoft suggests, some of the code ran and some did not. Stevey-baby could've put a few paragraphs in the 3rd edition to save his more idiotic readers (I am their champion!) a few hours of tragic longing for the bygone days of DAO. Oh!
Rating: 4 out of 5
Access from the ground up...
When I first came to read the 2nd edition of this book, I was already at an advantage over the casual reader as I'd attended lectures on database theory while studying for my degree in Computer Science.The reason I went out and bought Access Database Design and Programming was to learn how to apply what I knew in the real world, as I'd little practical experience with using or designing a real relational database. I choose a book on Access programming mainly because I'm an ASP developer and couldn't afford to run the more expensive Microsoft SQL Server just for developing a few site creation helper applications. The first few chapters were very familiar to me, it was simply going through the same topics we learnt at the University, only presented in a more useable format. It goes through the basics of database design, using a consistent example throughout the book, and covers topics such as identifying entities and their relationships, which is useful for anyone wanting to redesign an old database. After reading the first few chapters I was able to build my own database, complete with relations, that could not be optimised further by the use of the optimisation wizard. I'm not sure if this was due in part to my prior knowledge or the helpful step by step illustrations, but it was nice to be able to use the book so quickly. No doubt you've probably read about the problems of using an Access database in the web environment. However, a lot of the knowledge found in the earlier part of the book can be useful to anyone designing a relation database, regardless of their choice of software. Another thing to remember is that Access is more widely available than a lot of other database software programs. Access Database Design and Programming is probably more suited to those wanting to use Access away from a web environment, as the latter sections concentrate on the use of the Visual Basic Editor that is built in to program. Having said that, it makes a nice introduction to anyone new to designing or programming a database.
Rating: 2 out of 5
disappointing
True to its title, this book has an excellent section on database design, particularly as it pertains to Microsoft Access. However, I found it particularly frustrating when none of the code examples in the book worked with my databases. When I read Balter's "Mastering Microsoft Access 2000 Develoment", also available at Amazon, I found out why. DAO has been replaced by ADO. This book covers DAO first, and mentions only later. I spent five days trying to get DAO to work and failed. I am so glad I had my other Access book to steer me straight.The great introduction to relational databases is useful, but you could glean the same information from Hernandez's "Database Design for Mere Mortals" and it would apply to all DBMSes. I hate to give an O'Reilly book a bad review, but this one didn't meet my expectations. It is advertised to apply to Access versions 97-2002, but I don't think it is as up-to-date as some of the other books on the market.
Similar Products
· Writing Excel Macros with VBA, 2nd Edition
· VB and VBA in a Nutshell: The Languages
· Alison Balter's Mastering Microsoft Access 2000 Development
· F. Scott Barker's Microsoft Access 2000 Power Programming
· Access Cookbook (O'Reilly Windows)
|
