Flylib.com
Expert One-on-One 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
Expert One-on-One Microsoft Access Application Development
ISBN: 0764559044
EAN: 2147483647
Year: 2006
Pages: 124
Authors:
Helen Feddema
BUY ON AMAZON
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Conduct Data Collection
Developing a Kanban Design
Conclusion
Appendix H Case Study 1: Motor Plant Casting Kanban
Appendix I Case Study 2: Rubber Extrusion Plant
Java How to Program (6th Edition) (How to Program (Deitel))
Self-Review Exercises
Terminology
Recursive Backtracking
Security and the Network
Appendix J. (On CD) ATM Case Study Code
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 5. Driven to a Better User Interface
Hack 13. Create a Route with a Click (or Two)
Hack 19. Map Local Weather Conditions
Hack 37. View Your GPS Tracklogs in Google Maps
Hack 48. Tell Your Communitys Story
Web Systems Design and Online Consumer Behavior
Chapter I e-Search: A Conceptual Framework of Online Consumer Behavior
Chapter VI Web Site Quality and Usability in E-Commerce
Chapter XI User Satisfaction with Web Portals: An Empirical Study
Chapter XIII Shopping Agent Web Sites: A Comparative Shopping Environment
Chapter XVIII Web Systems Design, Litigation, and Online Consumer Behavior
Quartz Job Scheduling Framework: Building Open Source Enterprise Applications
Scheduling a Quartz Job Declaratively
Cron Triggers and More
Quick Lesson in Cron
What Is a Plug-In?
Creating a Quartz Plug-In
Programming .Net Windows Applications
The .NET Framework
Projects and Solutions
PictureBox
Date and Time Values
Creating Custom Controls from Scratch
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies