| OverviewWhen using GUI-based software, we often focus so much on the
interface that we forget about the general concepts required
to use the software effectively. Access Database
Design & Programming takes you behind the
details of the interface, focusing on the general knowledge
necessary for Access power users or developers to create
effective database applications. The main sections of this
book include: database design,queries, and programming. Editorial Reviews| Amazon.com | | 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. |
| | Book 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: - Database design. The book provides an enjoyable, informative overview of database design that carefully shows you how to normalize tables to eliminate redundancy without losing data.
- Queries. The book examines multi-table queries (i.e.,various types of joins) and shows how to implement them indirectly by using the Access interface or directly by using Access SQL.
- Programming. The book examines the VBA integrated development environment (IDE). It then goes on to provide an excellent introduction to Data Access Objects (DAO), ActiveX Data Objects (ADO), and ADO Extensions for Data Definition and Security (ADOX). These sections serve as a handy introduction and primer for basic database operations,such as modifying a table under program control, dynamically adding and deleting a record, and repositioning a record pointer. The concluding chapter focuses on common programming problems, such as computing running sums and comparing two sets.
Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, Access Database Design &Programming; instead focuses on the core concepts, enabling programmers to develop solid, effective database applications. This book also serves as a 'second course' in Access that provides a relatively experienced Access user who is new to programming with the frequently overlooked techniques necessary to develop successfully in the Microsoft Access environment. Anyone interested in learning Access in depth, rather than just scraping the surface, will enjoy and benefit immensely from reading this book. |
|
Other Readers Also Read | Top Sellers in This Category | Browse Similar Topics | | | Top Level Categories:Sub-Categories: | | | | |
Reader Reviews From Amazon (Ranked by 'Helpfulness') | Average Customer Rating: |  | based on 43 reviews. |
| Just What I Needed, 2006-02-02 | | Reviewer rating: |  |
| In 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-rigorous manner which is dry but still informative. The notation is sometimes a trial to follow but that is the nature of the beast. When things are put in terms of equations, they just do not read as interestingly as a prose novel. Although this information is presented with Access in mind, it would be applicable to anyone who wants to learn about databases.
The treatment of the programming elements is no less dry but it too is informative. Again, reading lines of code does not strike me as an exciting way to pass the afternoon but it got the job done. The examples are as clear as the syntax allows and make the points well.
I should point out that I did not actually try the code presented in this book. I read the examples to learn the concepts. I cannot testify as to how well the code worked in a "real" environment.
While I will certainly be looking for other references and learning materials, this was a good choice for my first foray past just learning the basics of the application itself.
|
| | this book got me started on databases..., 2005-11-17 | | Reviewer rating: | |
| | 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. |
| | If you own 2 Access books, this should be one of them, 2005-06-07 | | Reviewer rating: | |
| I 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 towards Access tables. The beauty of the relational model is that once you have your database set up, ongoing maintenance is minimal. If you learn how to program Access, but don't learn the basics of normalization and the relational model, you may as well just keep your data in Excel spreadsheets.
My complaint with this book is his coverage of ADO. The author clearly prefers DAO for MS Access, and he states as much, and his coverage suffers. He covers the material, but he makes using ADO appear to be very difficult. In an entire chapter on ADO, he fails to show the user the most basic thing: how to generate a recordset for a table in your Access database. Instead, he shows you how to use ADO to query other databases, such as SQL Server and even Excel, but not the Access Database that you're currently using.
In DAO one of the fundamental details that you need to know about is the CurrentDB object. Steven gets a gold star, because he not only covers the CurrentDB object, but he spends 6 pages on it. In ADO, an object that is used for a somewhat similar purpose is the CurrentProject object. You won't find coverage on it anywhere in this book - just check the index. Perhaps the author's surreptitious goal of the chapter is to frustrate you so much with ADO that you will return to DAO, his preferred choice. Tsk, tsk Steven.
After reading the books section on ADO over and over again, I cannot recommend this book if you plan on owning only one Access book. Instead, I would recommend Alison Balter's Mastering Access Databases. It is the best Access book on the market(as most Amazon reviewers will attest to) and covers nearly ever topic that you'd want to know about Access.
Even so, Steven's book covers normalization so much better than the other Access books out there that I would advise serious Access programmers to buy two books: Alison's and Steven's.
|
| | Note to Shannon - DAO is not a problem., 2005-05-18 | | Reviewer rating: |  |
| 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. |
| | I'M A COLDFUSION GUY...KEEP THAT IN MIND:, 2004-11-12 | | Reviewer rating: | |
| For a ColdFusion developer, to graph where your interests would probably be, it would look like an inverted bell curve: the beginning is splendid, the middle just wouldn't apply, and the end is worth coming back for.
The beginning of the book talks about stuff that we need to make sure we get down well, regardless of our database platform: Access, SQL Server, Oracle, Sybase - doesn't matter. The first couple of chapters
talk about stuff that is universally applicable, and under-appreciated:
* Normalization of tables, including first, second, and third normal form. As most experienced database designers know, you may not be able to glance at a database and know second from third, but you
should take the time to learn the principles of normalization.
* Referential integrity between parent and child tables
* Relationship types: one-to-one, one-to-many, and many-to-many
* Join types: inner and outer
Up to about page 120, ColdFusion developers are all clear. About there, Chapter 7 gets into Access VBA specific problems about accessing and manipulating data, creating DAO connections, and how to
programmatically manipulate data using VBA. This is interesting stuff in and of itself, but probably not to a ColdFusion developer.
Picking up in Chapter 19, "Some Common Data Manipulation Problems," the party starts again, talking about complex select queries and joins.
From an Access standpoint, this book is chock full of goodies. From the point of view of a ColdFusion developer, I would say this much: if forced to choose between this book and the previous, the Cookbook, I would probably go Cookbook. But, as I mentioned in the previous review, if you work with both Access on the desktop and on the web, using ColdFusion, both of these are good, useful, handy references. Having a greater appreciation of what goes on behind the scenes in Access may help gain a greater appreciation for the larger picture. |
|
Some information above was provided using data from Amazon.com. View at Amazon > |
| |
|
|
