Expert One-on-One Microsoft Access Application Development

Posted By: Alexun
Expert One-on-One Microsoft Access Application Development

Helen Feddema, Expert One-on-One Microsoft Access Application Development

Author: Feddema Helen | John Wiley & Sons | ISBN: 0-7645-5904-4 | 2004 Year | language: english | chm | 624 pages | 28,5 MB


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. Expert One-on-One Microsoft Access Application Development makes that process easier.

In these pages, you discover how to set up tables and relationships to ensure that the database is properly normalized. Then 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. You also find out about the important but often inadequately documented area of Automation code, which is used to communicate with other Office applications.

Over years of working with Access, the author has created some add-ins to save time when developing applications. She shows you how to use them to create a main menu for an application, automatically apply a naming convention to database objects, and ensure a consistent and professional appearance of the application’s forms.

From the contents:


About the Author.


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.