|
MS Office is well known as the application suite you use to write letters,
analyze data, and send e-mail. Behind these familiar applications are tools to customize and automate your MS Office chores. Chief among these is
Visual Basic of Applications and since recently Microsoft 's .net . powerful programming
language environment.
MS Access:
Access is a popular solution for small to medium sized IT systems, and with good reason. Unique among development tools, Access allows you to create an entire IT system- database, code, forms and reports- within a single environment. While it's included in some MS Office installations, developing Access apps is a job for software developers, not business users.
For many organizations, Access is the middle path between Excel or paper based information management, and larger, multi-component IT systems. While it does have limitations, an Access solution can cost a fraction of one developed with most other technologies, and be just as effective. more about
MS Access
MS Excel:
If your company is performing the same tasks on a regular basis using Excel, you should consider automating these systems.
Automation saves time, reduces human error, and allows more than one person to control the process. Virtually any action that can be performed in Excel can be automated. Excel can also be customized to connect with databases, display automated reports and even pull data from the web.
MS Word: Similarly, Microsoft Word can be programmed to automate any task associated with document creation and publication. The most common such application is the generation of letters or reports from data located elsewhere. For example, an investment bank may create security prospectuses to clients based on records in its contact management system.
MS Outlook: Finally, MS Outlook can be used for much more than e-mail and contacts. With a little programming, you can create forms for surveys and feedback, develop customized calendars, or share contact and other information between employees.
|
|
