Ships from: fallbrook, CA
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
Bob Villareal is a contributor and a resident expert for the "Inside Microsoft Access" Web journal and an Access instructor at a Tulsa Community College. He also does freelance programming and instruction. Bob has been developing databases in a large insurance firm for more than 15 years. He has more than seven years' experience of VBA programming in both Access and Excel and has written many tracking and management applications.
| Introduction | 1 | |
| Pt. I | Tables and Queries | 5 |
| 1 | Planning and Designing Your Access Database | 7 |
| 2 | Joins and Cascades | 25 |
| 3 | The Table - The Heart of Any Database | 41 |
| 4 | Unleashing the Power of Queries | 57 |
| Pt. II | Forms for Input and Reports for Output | 89 |
| 5 | Exploring Forms and Controls | 91 |
| 6 | Exploring Reports | 123 |
| Pt. III | Automate Your Access Database Using Code | 157 |
| 7 | Exploring Objects | 159 |
| 8 | Writing Your Own Visual Basic for Applications Code | 191 |
| 9 | Macros, Modules, and Messages | 207 |
| 10 | Using Procedures to Customize Your Database | 223 |
| 11 | Handling Access Error Codes | 247 |
| 12 | Access Visual Basic Tools, Tips, and Techniques | 261 |
| Pt. IV | Taking Advantage of the Latest Access Features | 287 |
| 13 | Publishing Your Access Database | 289 |
| 14 | SQL Server Integration | 315 |
| 15 | User-Friendly Enhancements | 335 |
| Pt. V | Overcoming Access Development Obstacles | 347 |
| 16 | Overcoming the Limitations of Queries | 349 |
| 17 | Getting the Most from Your Queries | 361 |
| 18 | Working with Data from External Sources | 375 |
| 19 | Bringing Together and Separating Data | 401 |
| 20 | Conquering Big Problems that Come In Small Packages | 419 |
| 21 | Taking Charge of Forms | 443 |
| 22 | Taking Charge of Reports | 487 |
| 23 | Using Replication | 515 |
| Index | 532 |
Anonymous
Posted Thu Jul 25 00:00:00 EDT 2002
Reader, if you want to learn VBA and unlock the power of Access, this book is for you. Bob Villareal has done an excellent job throughout this book. Using his databases, downloaded to your PC, you follow along, chapter by chapter, learning his techniques for solving problems. There are many practical examples in the book. Here¿s a couple: There¿s a list of string functions in the book with explanations for their use as well as demonstrations of their many uses in his databases. String functions are powerful tools that allow you to instantly manipulate data from thousands of records, separating data from one field into two is just one of them. In another chapter, there¿s a pop-up form with controls that can filter records for your report. So you won¿t need to create 15 different queries for 15 different reports, the user can select what he or she wants from the pop-up form, just point and click. You¿ll have a clearly written book with examples, and you¿ll have databases to study and use. All of the chapters are educational and useful and will enhance all of your own databases. This is an excellent book for your Access library. It is in mine.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Fri Feb 15 00:00:00 EST 2002
I have purchased many computer related books in the past, but none have been this easy to follow. I really thought the format of the book was very well done. I liked the fact that a concept was stated, a visual example given, then a detailed explanation of what you needed to know was given. Being able to download the sample files from the web was also a great idea. I would encourage anyone who is already working with Access or even thinking about it to purchase this book. I am glad that I did. I have already put what I learned to good use at home and at work.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview