Alison Balter's mastering Microsoft Office Access 2007 development

Format:

Book

Author/Creator:

Balter, Alison, Author.

Language:

English

Subjects (All):

Microsoft Access.

Database management.

Physical Description:

1 online resource (1248 pages)

Edition:

1st edition

Other Title:

Access 2007 development

Mastering Microsoft Office Access 2007 development

Place of Publication:

[Place of publication not identified] Sams 2007

Language Note:

English

System Details:

text file

Summary:

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 . . . . . . . . . . . . . . . . . . . . . ...

Contents:

Intro

Title Page

Copyright Page

Contents at a Glance

Table of Contents

About the Author

Dedication

Acknowledgments

We Want to Hear from You!

Introduction

Part I: The Basics of Access Development

Chapter 1. Access as a Development Tool

Chapter 2. What Every Developer Needs to Know About Databases and Tables

Chapter 3. Relationships: Your Key to Data Integrity

Chapter 4. What Every Developer Needs to Know About Query Basics

Chapter 5. What Every Developer Needs to Know About Forms

Chapter 6. What Every Developer Needs to Know About Reports

Chapter 7. What Are Macros, and When Do You Need Them?

Chapter 8. VBA: An Introduction

Chapter 9. Objects, Properties, Methods, and Events Explained

Chapter 10. Advanced Form Techniques

Chapter 11. Advanced Report Techniques

Chapter 12. Advanced Query Techniques

Chapter 13. Advanced VBA Techniques

Chapter 14. Exploiting the Power of Class Modules

Chapter 15. What Are ActiveX Data Objects, and Why Are They Important?

Part II: What to Do When Things Don't Go as Planned

Chapter 16. Debugging: Your Key to Successful Development

Chapter 17. Error Handling: Preparing for the Inevitable

Chapter 18. Optimizing Your Application

Part III: Developing Multiuser and Enterprise Applications

Chapter 19. A Strategy to Developing Access Applications

Chapter 20. Using External Data

Chapter 21. Access 2007 and SharePoint

Chapter 22. Developing Multiuser and Enterprise Applications

Part IV: Black Belt Programming

Chapter 23. Working with and Customizing Ribbons

Chapter 24. Automation: Communicating with Other Applications

Chapter 25. Exploiting the Power of the Windows API

Chapter 26. Creating Your Own Libraries

Chapter 27. Using Builders and Wizards.

Chapter 28. An Introduction to Access and the Internet/Intranet

Part V: Adding Polish to Your Application

Chapter 29. Documenting Your Application

Chapter 30. Maintaining Your Application

Chapter 31. Database Security Made Easy

Part VI: Appendixes

Appendix A. Naming Conventions

Appendix B. Table Structures

Index.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Description based on publisher supplied metadata and other sources.

ISBN:

9780132715164

0132715163

OCLC:

154684620