Expert one-on-one Microsoft Access application development / Helen Feddema.

Format:

Book

Author/Creator:

Feddema, Helen Bell.

Language:

English

Subjects (All):

Database management.

Computer software--Development.

Computer software.

Microsoft Access.

Physical Description:

1 online resource (620 p.)

Edition:

1st ed.

Place of Publication:

Indianapolis, IN : Wiley Pub., c2004.

Language Note:

English

Summary:

What is this book about? 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, a

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 FormsSummary; 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 ReportsSpecial 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 MenuNormalizing 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 CodeThe 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

Notes:

Includes index.

ISBN:

1-280-35012-1

9786610350124

0-7645-7200-8

OCLC:

70720268