Expert One-on-One : Microsoft Access Application Development.
Title:
Expert One-on-One : Microsoft Access Application Development.
Author:
Feddema, Helen.
ISBN:
9780764572005
Personal Author:
Edition:
1st ed.
Physical Description:
1 online resource (619 pages)
Contents:
Expert One-on-One Microsoft Access Application Development -- Credits -- Dedication -- Contents -- Acknowledgments -- About the Author -- Introduction -- Audience -- How This Book is Organized -- Access Versions -- Conventions -- Source Code -- Sample Files -- Errata -- p2p. wrox. com -- Part 1: Creating an Access Application -- Chapter 1: Creating a Database for an Application -- Gathering Data -- Figuring Out Business Tasks and Objects -- Determining Your Entities -- Creating Tables for an Application -- Table Field Data Types -- Normalization -- Setting Up Relationships -- Summary -- Chapter 2: Using Forms to Work with Data -- Form Types -- Creating the Forms -- Summary -- Chapter 3: Selecting the Right Controls for Forms -- Standard Controls -- Special Controls -- ActiveX Controls -- Summary -- Chapter 4: Sorting and Filtering Data with Queries -- Select Queries -- Crosstab Queries -- Action Queries -- SQL-specific Queries -- Summary -- Chapter 5: Using PivotTables and PivotCharts to Interact with Data -- Creating a Data Source Query -- PivotTables -- PivotCharts -- Summary -- Chapter 6: Printing Data with Reports -- Report Design Principles -- Tabular Reports -- Grouped Reports -- Labels Reports -- Columnar Reports -- Reports with Subreports -- Filtered by Form Reports -- Summary Reports -- Special Formatting for Reports -- Creating a Main Menu with the Menu Manager Add-In -- Summary -- Chapter 7: Writing VBA Code in Modules -- Module Types -- Statements for Use in Modules -- Standard Module Code Samples -- Code Behind Forms Code Samples -- Summary -- Part II: Modifying, Updating, and Maintaining Access Applications -- Chapter 8: Managing the Application Life Cycle -- Modifying an Application -- Upgrading to a New Office Version -- Working with Clients -- Client Relations -- Making Client-Requested Changes -- Summary.
Chapter 9: Reworking an Existing Application -- Applying a Naming Convention -- Creating a Main Menu -- Normalizing Tables and Relationships -- Reworking Forms to Enter and Display Many-to-Many Linked Data -- Reworking Reports to Enter and Display Many-to-Many Linked Data -- Summary -- Chapter 10: Moving Old Data into a New Database -- Getting at the Old Data -- Using Queries with Calculated Fields to Append Data from a Non-Normalized Table to a Normalized Table -- Using VBA Code to Move Data from a Non-Normalized Table to Linked Normalized Tables -- Denormalizing Data -- Summary -- Part III: Working with Other Office Components ( and More) -- Chapter 11: Working with Word -- Writing Automation Code -- The Word Object Model -- Exporting Access Data to Word Documents -- Importing Data from Word Tables into Access -- Automation Problems and How to Avoid Them -- Summary -- Chapter 12: Working with Outlook -- Writing Automation Code -- The Outlook Object Model -- Exporting Data from Access to Outlook Items -- Importing Data from Outlook Items to Access -- Using the Redemption Library to Avoid the Object Model Guardian -- Summary -- Chapter 13: Working with Excel -- Writing Automation Code -- The Excel Object Model -- Exporting Data from Access to Excel -- Importing Data from Excel -- Summary -- Chapter 14: Working Outside of Office -- Sending Faxes with WinFax -- Writing Data to a Text File -- Summary -- Index.
Abstract:
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. I hope this book will make that process easier. In these pages, I will teach you how to set up tables and relationships to ensure that the database is properly normalized. Then I'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. Over years of working with Access, I've created some add-ins to save time when developing applications. I'll show 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. This book helps you write VBA code that unites database components into an application that works. 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 Who this book is for This book is for experienced Access users who are familiar with creating Access objects and writing VBA code, but who need help transitioning from competent users/programmers to
full-fledged Access developers. Wrox Expert One-On-One books present the wisdom accumulated by an experienced author who is recognized as an expert by the programming community. These experts challenge professional developers to examine their current practices in pursuit of better results.
Local Note:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2017. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Genre:
Electronic Access:
Click to View