Microsoft Access developers/users
Expert One-on-One Microsoft Access Application Development (Wrox Press) teaches Access developers best practices for building effective Access-based applications. Written by Helen Feddema--a well-known expert on Microsoft Access and author of one of the leading books on Access from Microsoft Press--this book will provide a wealth of hidden tips and tricks for mastering Access development.
The book is divided into three parts, each centered around a separate case application. The first shows best methods for building a relatively simple Access application using the developer's own data. The next section shows how to build a distributed application serving multiple clients and types of data. The chapters in this section cover each step in the applicaiton lifecycle--from gathering application requirements from clients to migrating data from legacy systems to the new Access database system.
The last section of the book shows how to build Access applications that work with other Office applications, inlcuding Word, Excel, and Outlook, as well as non-Office applications. These integration issues cover some of the thorniest problems an Access developer will face. Feddema's years of experience as an author, consultant, and trainer ensure that she will provide highly original solutions and workarounds.
Contents
Acknowledgments.
About the Author.
Introduction.
Part One: Creating an Access Application.
Chapter 1: Creating a Database for an Application.
Chapter 2: Using Forms to Work with Data.
Chapter 3: Selecting the Right Controls for Forms.
Chapter 4: Sorting and Filtering Data with Queries.
Chapter 5: Using PivotTables and PivotCharts to Interact with Data.
Chapter 6: Printing Data with Reports.
Chapter 7: Writing VBA Code in Modules.
Part Two: Modifying, Updating, and Maintaining Access Applications.
Chapter 8: Managing the Application Life Cycle.
Chapter 9: Reworking an Existing Application.
Chapter 10: Moving Old Data into a New Database.
Part Three: Working with Other Office Components (and More).
Chapter 11: Working with Word.
Chapter 12: Working with Outlook.
Chapter 13: Working with Excel.
Chapter 14: Working Outside of Office.
Index.