Alison Balter's Mastering Microsoft Office Access 2007 Development (Paperback)

~ Alison Balter (Author)
Key Phrases: accdb file, accdb database, invoke error handling, End Sub, Database Tools, Date Modified (more...)

Editorial Reviews

Product Description

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.

Product Details

• Paperback: 1248 pages
• Publisher: Sams; 1 edition (June 10, 2007)
• Language: English
• ISBN-10: 0672329328
• ISBN-13: 978-0672329326
• Product Dimensions: 8.9 x 7 x 2.2 inches
• Shipping Weight: 3.9 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars  See all reviews (10 customer reviews)
• Amazon.com Sales Rank: #33,083 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #34 in

  Books > Computers & Internet > Software > Databases

Customer Reviews

Most Helpful Customer Reviews

16 of 17 people found the following review helpful:

5.0 out of 5 stars Excellent book, July 24, 2007

By	C. Torrico (Tillson, NY) - See all my reviews (REAL NAME)

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.

6 of 6 people found the following review helpful:

5.0 out of 5 stars Dont blam Sams Publishing, May 27, 2008

By	Jason Smith (Qld, Australia) - See all my reviews (REAL NAME)

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.

12 of 15 people found the following review helpful:

3.0 out of 5 stars Some left out the appendices and CD, July 4, 2007

By	Robert W. Mcgaffic "pittsburghbob" (pittsburgh PA) - See all my reviews (REAL NAME)

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 www.samspublishing.com/title/0672329328". 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.