Expert One-on-One: Microsoft Access Application Development
- 7h 10m
- Helen Feddema
- John Wiley & Sons (US)
- 2004
If you are developing databases for your own use, the process need not be complicated. But when you build databases for clients, many of whom may not be familiar with Access or comfortable with databases in general, you have a lot more work to do.
In this book, the author will teach you how to set up tables and relationships to ensure that the database is properly normalized. Then she’ll help you write VBA code to create the connective tissue that turns a bunch of tables, queries, forms, and reports into a complete and coherent application. We’ll pay special attention to the important but often inadequately documented area of Automation code, which is used to communicate with other Office applications.
What you will learn from this book
- How to build integrated Access-based applications that support multiple clients and databases
- Tips for streamlining application creation
- Maintenance required throughout an application’s life cycle, including migrating data from legacy systems and upgrading Office
- How to use Automation code to exchange data among Office components and even some non-Office programs
- Ways to avoid glitches when building Access applications that work with Excel, Word, and Outlook
About the Author
Helen Feddema is an internationally known expert on Microsoft Access, and a regular contributor to Pinnacle’s Smart Access and Office Developer journals. She edits the Woody’s Access Watch e-zine and writes its “Access Archon” column. Helen’s writings and seminars have been helping Access developers since the beta of Access 1.0, one of many she has tested.
In this Book
-
Expert One-on-One—Microsoft Access Application Development
-
Introduction
-
Chapter 1: Creating a Database for an Application
-
Chapter 2: Using Forms to Work with Data
-
Selecting the Right Controls for Forms
-
Sorting and Filtering Data with Queries
-
Chapter 5: Using PivotTables and PivotCharts to Interact with Data
-
Printing Data with Reports
-
Writing VBA Code in Modules
-
Chapter 8: Managing the Application Life Cycle
-
Chapter 9: Reworking an Existing Application
-
Moving Old Data into a New Database
-
Working with Word
-
Working with Outlook
-
Working with Excel
-
Working Outside of Office
