| | Increasing the speed and accuracy of document productionVBA programming | Visual Basic for Applications (VBA — Macro development in Excel, Access, Word Document assembly — Templates, menus, toolbars, buttons, fields, styles, hyperlinks, merging Data transfers between applications — Exported database data (Crystal Reports/WebIntelligence data to Excel to Access); Microsoft Office application text transfers (Access to Word; Word to Excel, etc.)
| Report development | Templates — Standardized report design in BusinessObjects WebIntelligence, Crystal Reports, Excel using Remedy data Report construction — Record selection, formulas, grouping, sorting, prompts, summary calculations, running totals, charts Documentation — Description of report objects, relationships, audience, delivery; data dictionary values
| Procedures documentation | Custom training material — Analysis, testing, and writing for custom applications and Sarbanes-Oxley procedures Web-based applications — Training modules, online virtual tours, storyboards for web-based training, online pre- and post-tests Staff analysis — Interviews with employees to determine roles and tasks; organization of content for training program development
| Database development | Access databases — Menus, data entry forms, subforms, dropdown boxes, command buttons, action queries HotDocs templates — Libraries of related forms, shared component files, standardized document designs, loops, models Data conversion — Word-processing, spreadsheet, or delimited text data tables to Access; database application upgrades
| Technical support | Help Desk — Email and on-site assistance with document and data problems; automation of document production Software research — Use of Microsoft Knowledge Base, MSDN Developer, Internet resources Procedure analysis — Determine skill levels appropriate for tasks; writeups of new features for software upgrades
|
|
