 Most of us use MS
Office regularly, i.e. we use each component of the suite as a
stand-alone entity.
Whilst Word, Excel, Access and PowerPoint have
very specific strengths, programming them to work together realises more
complex data manipulation and greater productivity. At a basic level we can store data in Excel or Access and produce personalised, attractive documents in Word to fax or mail our clients. We can extend the power of Access by linking data to Excel for superior charting of data. Most managers produce a monthly report. Part of the data may be on a large enterprise database. Set-up a query in Excel to bring in the data required. Prepare charts as needed. Design a MR template in Word that will accommodate the charts and allow entry of a month's written information, perhaps in bulleted format. For future monthly reports, run the saved query in Excel, this updates the charts in the Word document; only the relevant text for the current month is manually updated. Through code we can perform very po Click here to view the presentation or go to 'Downloads' and select the file "Office for Business.pps". This PowerPoint presentation discusses the topic in detail. |
werful
routines. Link financial or employee data in Access or SQL Server to MS Project;
automatically update inputs to our web site
from clients or suppliers. We can send individual e-mails from Access to
Outlook in HTML format via IE to specific groups of people at the touch
of a button.