The PC has provided individual users with extraordinary access to information.
Many if not most use modern offices packages like Microsoft Office® with its combined spreadsheet, word processing and database capabilities.
Unfortunately most people resort to cut and paste to move data between office packages.
But, there is a hidden power within office to automate functionality between these packages.
WATCH DATA FROM ACCESS AUTOMATICALLY FILLING AN EXCEL TABLE
Elements in Database Rows
|ID|
|First_Name|
|Last_Name|
|Address|
|City|
|State|
|Zip|
6
Mike
Jones
PO Box 6
Annapolis
MD
21401
7
Joe
Smith
1179 Williams Avenue
NewYork
NY
10001
WORD Document Source Template
Office Automation used to place Access database fields in the word document
This is a lot easier than typing the values or even using cut and paste.
As long as the program generated "report" is consistent over time the "cost of programming" will outweigh the costs of "manual updating."
Office has a built-in language called Visual Basic for Applications®.
It also has an Application Program Interface routines (API) that enble programs to automated actions between and within the various applications in the suite.
