Expert One-on-One(c) Microsoft Access Application Development

Expert One-on-One Microsoft Access Application Development

ISBN: 0764559044
EAN: 2147483647

Year: 2006
Pages: 124

Authors: Helen Feddema

BUY ON AMAZON

Table of Contents
BackCover
Expert One-on-One - Microsoft Access Application Development
Introduction
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
Creating the Forms
Summary
Chapter 3: Selecting the Right Controls for Forms
Special Controls
ActiveX Controls
Summary
Chapter 4: Sorting and Filtering Data with 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
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
Upgrading to a New Office Version
Working with Clients
Client Relations
Making Client-Requested Changes
Summary
Chapter 9: Reworking an Existing Application
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
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
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
Writing Data to a Text File
Summary
Index
Index_A
Index_B
Index_C
Index_D
Index_E
Index_F
Index_G
Index_H
Index_I
Index_J
Index_K
Index_L
Index_M
Index_N
Index_O
Index_P
Index_Q
Index_R
Index_S
Index_T
Index_U
Index_V
Index_W
Index_Y
Index_Z
List of Figures