Expert Access 2007 Programming
Published on 1. November 2007
Book
Paperback/Softback
688 pages
978-0-470-17402-9 (ISBN)
Description
Expert Access 2007 Programming
As the most popular database system in the world, Microsoft Access is used by millions of people and supported by hundreds of thousands of Access developers. The 2007 version marks the largest release of Access in five years. Written by design engineers on the Access test team at Microsoft, this book introduces you to the many new features of Access 2007 and shows you innovative ways of looking at old problems such as automation, debugging, and deployment.
The authors break down the book into four parts--programming Access applications, data manipulation, interacting with the application, and finalizing the application--in order to walk you through the important steps of creating a full-featured application. They also provide you with in-depth examples that require only minor modifications and then can be easily implemented in the real world. You'll quickly learn how the 2007 version makes it simpler to write quality Access applications with XML, C#, and other.NET languages that are actually fun to write, feature rich, and easy to use.
What you will learn from this book
*
The basics of working with managed code, particularly C# and VB.NET
*
How to create different types of forms and customize navigation solutions for forms
*
The advantages of developing databases for a global marketplace
*
Various techniques that can simplify the development process and provide consistency across multiple applications
*
How to use Report view to create compelling scenarios for users such as sorting and filtering
*
Ways to find, view, categorize, and interact with data
Who this book is for
This book is for experienced Access application developers who use VBA and SQL. Familiarity with Access 2007 is helpful but not required.
Wrox Expert books present the wisdom accumulated by an experienced author team who is recognized as experts by the programming community. These experts challenge professional developers to examine their current practices in pursuit of better results.
As the most popular database system in the world, Microsoft Access is used by millions of people and supported by hundreds of thousands of Access developers. The 2007 version marks the largest release of Access in five years. Written by design engineers on the Access test team at Microsoft, this book introduces you to the many new features of Access 2007 and shows you innovative ways of looking at old problems such as automation, debugging, and deployment.
The authors break down the book into four parts--programming Access applications, data manipulation, interacting with the application, and finalizing the application--in order to walk you through the important steps of creating a full-featured application. They also provide you with in-depth examples that require only minor modifications and then can be easily implemented in the real world. You'll quickly learn how the 2007 version makes it simpler to write quality Access applications with XML, C#, and other.NET languages that are actually fun to write, feature rich, and easy to use.
What you will learn from this book
*
The basics of working with managed code, particularly C# and VB.NET
*
How to create different types of forms and customize navigation solutions for forms
*
The advantages of developing databases for a global marketplace
*
Various techniques that can simplify the development process and provide consistency across multiple applications
*
How to use Report view to create compelling scenarios for users such as sorting and filtering
*
Ways to find, view, categorize, and interact with data
Who this book is for
This book is for experienced Access application developers who use VBA and SQL. Familiarity with Access 2007 is helpful but not required.
Wrox Expert books present the wisdom accumulated by an experienced author team who is recognized as experts by the programming community. These experts challenge professional developers to examine their current practices in pursuit of better results.
More details
Persons
Rob Cooper is a Test Lead on the Access team at Microsoft. He started at Microsoft as a support engineer in Charlotte, North Carolina in 1998 and joined the Access 2003 test team in Redmond in 2001. During the Access 2007 release, he led the security efforts across the test team and worked on several new features including disabled mode, database encryption, Office Trust Center, and sorting, grouping, and totals. Rob also led efforts around the Access object model and continues to provide direction around programmability and security in Access.
A long-time fan of Access, Rob is a frequent speaker at the Seattle Access Group and PNWADG meetings and has written for the Microsoft Knowledge Base and Access Advisor. Aside from writing code in Access and C#, he also enjoys spending time with his family watching movies, going to the zoo and aquarium, and hanging out in and around Seattle.
Michael Tucker is a Software Design Engineer on the Microsoft Access test team in Redmond. He joined Microsoft in 1993 as a Product Support Engineer supporting the very first release of Microsoft Access, and has been passionate about Access ever since. During the Access 2007 release, he worked on the new ACE database engine, and owned the complex data and SharePoint workflow integration features.
Michael designed and coordinated implementation of the test automation infrastructure used by the test team. He also has previous experience as a Test Lead and Program Manager on a variety of products at Microsoft. His specialties include SQL, data normalization, and object model design, and anything related to his passions for airplanes, airports, and traveling the world.
A long-time fan of Access, Rob is a frequent speaker at the Seattle Access Group and PNWADG meetings and has written for the Microsoft Knowledge Base and Access Advisor. Aside from writing code in Access and C#, he also enjoys spending time with his family watching movies, going to the zoo and aquarium, and hanging out in and around Seattle.
Michael Tucker is a Software Design Engineer on the Microsoft Access test team in Redmond. He joined Microsoft in 1993 as a Product Support Engineer supporting the very first release of Microsoft Access, and has been passionate about Access ever since. During the Access 2007 release, he worked on the new ACE database engine, and owned the complex data and SharePoint workflow integration features.
Michael designed and coordinated implementation of the test automation infrastructure used by the test team. He also has previous experience as a Test Lead and Program Manager on a variety of products at Microsoft. His specialties include SQL, data normalization, and object model design, and anything related to his passions for airplanes, airports, and traveling the world.
Content
Introduction.
Part I: Programming Access Applications.
Chapter 1: Overview of Programming for Access.
Chapter 2: Extending Applications Using the Windows API.
Chapter 3: Programming Class Modules.
Chapter 4: Debugging, Error Handling, and Coding Practices.
Part II: Data Manipulation.
Chapter 5: Parsing Data.
Chapter 6: Using SQL to Retrieve Data and Manipulate Objects.
Chapter 7: Managing Data.
Part III: Interacting with the Application.
Chapter 8: Using Code to Add Advanced Functionality to Forms.
Chapter 9: Using Code to Add Advanced Functionality to Reports.
Chapter 10: Using Automation to Add Functionality.
Chapter 11: Creating Dynamic Ribbon Customizations.
Part IV: Finalizing the Application.
Chapter 12: Configuration and Extensibility.
Chapter 13: Personalization and Security.
Chapter 14: Deployment.
Chapter 15: Help and Documentation.
Appendix A: Programming Tips and Tricks.
Appendix B: Query Performance.
Appendix C: Pattern Reference.
Index.
Part I: Programming Access Applications.
Chapter 1: Overview of Programming for Access.
Chapter 2: Extending Applications Using the Windows API.
Chapter 3: Programming Class Modules.
Chapter 4: Debugging, Error Handling, and Coding Practices.
Part II: Data Manipulation.
Chapter 5: Parsing Data.
Chapter 6: Using SQL to Retrieve Data and Manipulate Objects.
Chapter 7: Managing Data.
Part III: Interacting with the Application.
Chapter 8: Using Code to Add Advanced Functionality to Forms.
Chapter 9: Using Code to Add Advanced Functionality to Reports.
Chapter 10: Using Automation to Add Functionality.
Chapter 11: Creating Dynamic Ribbon Customizations.
Part IV: Finalizing the Application.
Chapter 12: Configuration and Extensibility.
Chapter 13: Personalization and Security.
Chapter 14: Deployment.
Chapter 15: Help and Documentation.
Appendix A: Programming Tips and Tricks.
Appendix B: Query Performance.
Appendix C: Pattern Reference.
Index.