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... read more
By "kareninpgh" - February 13, 2000
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!
Good and to the point.....
By Khalil Ahmad - May 26, 2000
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... read more