Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Alison Balter's Mastering Microsoft Office Access 2007 Development 1st Edition

4.6 out of 5 stars 22 customer reviews
ISBN-13: 075-2063329320
ISBN-10: 0672329328
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$11.30 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$51.98 On clicking this link, a new layer will be open
More Buying Choices
17 New from $27.64 21 Used from $4.07
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Save Up to 90% on Textbooks Textbooks
$51.98 FREE Shipping. Only 2 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

  • Alison Balter's Mastering Microsoft Office Access 2007 Development
  • +
  • Access 2007 VBA Programmer's Reference
  • +
  • Access 2007 VBA Programming For Dummies
Total price: $103.25
Buy the selected items together

Editorial Reviews

From the Back Cover

Microsoft Office 2007 is a major upgrade from the last version of Office; Access will also be greatly revised. Alison Balter is the name that Access developers will trust to guide them through Access 2007's new features. She has the rare ability to take complex topics and explain them clearly, as shown by the success of her ten previous books on Access. Balter is known for providing real-world solutions to specific Access development problems. She also is known for her ability to back up her practical examples with just enough underlying theory to give the reader a good overall understanding of Access. In short, this book will provide beginning and intermediate Access developers with everything that they need to know to design and build Access 2007 applications. It should also appeal to DBAs and power users who want or need to get started building custom Access apps. This latest book in her Mastering Access series will not disappoint her many fans who anxiously await each new version, and should win her new fans as well. Introduction Part I The Basics of Access Development 1 Access as a Development Tool. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 2 What Every Developer Needs to Know About Databases and Tables . . . . . . . 75 3 Relationships: Your Key to Data Integrity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115 4 What Every Developer Needs to Know About Query Basics. . . . . . . . . . . . . . . . . 137 5 What Every Developer Needs to Know About Forms. . . . . . . . . . . . . . . . . . . . . . . . . . 189 6 What Every Developer Needs to Know About Reports. . . . . . . . . . . . . . . . . . . . . . . . 269 7 What Are Macros, and When Do You Need Them? . . . . . . . . . . . . . . . . . . . . . . . . . . . 315 8 VBA: An Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 345 9 Objects, Properties, Methods, and Events Explained . . . . . . . . . . . . . . . . . . . . . . . . . . 401 10 Advanced Form Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 431 11 Advanced Report Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 493 12 Advanced Query Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 539 13 Advanced VBA Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 599 14 Exploiting the Power of Class Modules. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 637 15 What Are ActiveX Data Objects, and Why Are They Important?. . . . . . . . . . 671 Part II What to Do When Things Don't Go as Planned 16 Debugging: Your Key to Successful Development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 727 17 Error Handling: Preparing for the Inevitable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 755 18 Optimizing Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 801 Part III Developing Multiuser and Enterprise Applications 19 A Strategy to Developing Access Applications. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 835 20 Using External Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 847 21 Access 2007 and SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 883 22 Developing Multiuser and Enterprise Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . 909 00_0672329328_FM.qxd 5/4/07 9:23 AM Page iii Part IV Black Belt Programming 23 Working with and Customizing Ribbons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 935 24 Automation: Communicating with Other Applications. . . . . . . . . . . . . . . . . . . . . . 949 25 Exploiting the Power of the Windows API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 985 26 Creating Your Own Libraries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1011 27 Using Builders and Wizards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1027 28 An Introduction to Access and the Internet/Intranet. . . . . . . . . . . . . . . . . . . . . . . . 1055 Part V Adding Polish to Your Application 29 Documenting Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1073 30 Maintaining Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1091 31 Database Security Made Easy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1103" The following appendixes are available for download at www.samspublishing.com/title/0672329328." Part VI Appendixes A Naming Conventions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1131 B Table Structures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1137 Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1193

About the Author

Alison Balter has been programming, teaching, and writing about Access for more than 12 years, since the release of Access 95. She is the author or co-author of ten books on Access. Alison is a regular speaker at conferences worldwide. She is the founder of InfoTechnology Partners, Inc. Her clients include Shell Oil, the Archdiocese of Los Angeles, Southern California Edison, Accenture, Prudential Insurance, and the International Cinematographer's Guild.
NO_CONTENT_IN_FEATURE



Product Details

  • Paperback: 1248 pages
  • Publisher: Sams Publishing; 1 edition (June 10, 2007)
  • Language: English
  • ISBN-10: 0672329328
  • ISBN-13: 978-0672329326
  • Product Dimensions: 7 x 1.5 x 9 inches
  • Shipping Weight: 3.9 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (22 customer reviews)
  • Amazon Best Sellers Rank: #1,070,318 in Books (See Top 100 in Books)

More About the Author

Alison Balter is the founder of InfoTechnology Partners, Inc., a computer consulting firm in California. She is a highly experienced trainer and consultant, specializing in Windows applications. During her 17 years in the computer industry, she has helped many Fortune 500 corporations as well as government agencies. The author of over 300 internationally-marketed computer training videos for KeyStone Learning Systems Corporation, Alison has also written several bestselling books for Sams Publishing.

Customer Reviews

Top Customer Reviews

Format: Paperback
As is already known, Access 2007 has a new interface, with ribbons and many new features targeted mainly to the end-user. The DEVELOPMENT process however, has not changed much.
This book presents a brief introduction of what is new in Access 2007, and then goes on to present the "development" part. Alison Balter, as in her previous books on Access Development, presents the right combination of theory and code (VBA, ADO, etc). The chapters on objects/properties/methods/events, advanced form techniques, advanced report techniques, advanced query techniques, advanced VBA techniques, and ActiveX Data Objects, to name a few, are excellent. Some chapters have been appropriately revised, some others have been completely rewritten or are new -database security, and customizing ribbons, for example. However, there is no longer coverage of DAO, and because of the new interface, the coverage of startup options is gone.
I have downloaded the book examples and source code, naming conventions (appendix A) and table structures (appendix B) without any problem. Of course, having these, you no longer need the CD.
This book is outstanding; as in the past, the technical editing is excellent and the content is superb. I expect nothing less from the terrific author Alison Balter.
4 Comments 22 of 23 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Once again Sams Publishing takes the award for sloppy technical editing.

On page 2, "Included in the text and on the sample code CD-ROM is a generic error handler that you cab easily build into any of your won applications". You guessed it, there is no CD included with this book.

On page xxxxiii, "The following appendixes are available for download at [...]". If you guess that there are no such files or opportunity to download them on this web page, you would be right.

Where can we obtain the book's naming conventions appendix and the table structures to all the tables she develops in the book, for those of us who do not relish repetitive typing.

Shortcomings that mar what otherwise would be an excellent book.
3 Comments 19 of 22 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I have found this book extremley helpful and like the others i was missing the cd from the book This however was easily rectified by emailing alison directly to resolve this issue of which she was extremely helpful with. On that note i believe that is more an Amazon issue as I have bough an earlier version of this same book from another source and did get the cd with it.
1 Comment 7 of 7 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I've read many Access how-to books over the past 15 years. Most have been very rudimentary, but better than the original Microsoft documentation, which doesn't take much.
I bought this book to help me with a project and I was very pleasantly surprised? Following the Wizard data, background on how Wizards work, etc., I'm now using ADO to code record set manipulation with Access 2007. If you have only have money for one book, this is it. Everything you want/need to know is in the table of contents or index. The logical progressions of knowledge from fundamentals through VBA make the plot pretty good for reading straight through. This lady knows her stuff.
I love Alison Balter's work. If you want to learn Access and VBA, then you can't go wrong with this book.
Comment 3 of 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I've read Alison Balters entire series of Access book more than twice each. She writes in a clear style which gets right to the point. When Access 2007 came out,I immediately ordered Alison Balters book. It helped me to get up to speed on Access 2007 and was money well spent. I would also recommend reading Access 2007 VBA published by Wrox after reading Alison's book.
Comment 3 of 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Kindle Edition
Contrary to popular claims, no one book could cover every aspect of this subject, but if there was one single book I could own, This would be it. Extremely well written, a tiny bit of humor, a fun read (quite actually). I spent hours in this and had something to show for my money.

This book can take you from marginal knowledge to building a company wide sabotage-proof application that will command respect.

Disclaimer: this is not to say that you might not have to spend hours and hours exploring this ocean-deep hobby. Work is still essential on your part, but Balter takes as much pain out of the task as humanly possible.

A nice complimentary companion to this work is Hernandez's Database Design for Mere Mortals, but take this one first.

A terrific Value.

Steve, Akron, OH
Hobbiest and enthusiast.

Expert's Exchange fee-based newsgroup is another terrific help to get you on your way.
Comment 2 of 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This book is very well written, and aimed at neither the total computer novice, nor the highly advanced expert - in other words, it is just right for most of us.

Each chapter begins with an explanation of why the area to be covered is important, and a general overview of the concepts. The remaining portion of the chapter then gets into the nuts and bolts of employing the practical techniques to build your database. When there is to be more advanced coverage of the concept in a later chapter, Ms. Balter notes where it will be found.

I recommend this book to anyone who may have a working knowledge of basic computer/database programming, but who is not the professional already steeped in advanced techniques.
Comment 2 of 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Alison Balter's Mastering Microsoft Office Access 2007 Development
This item: Alison Balter's Mastering Microsoft Office Access 2007 Development
Price: $51.98
Ships from and sold by Amazon.com