| | Increasing the speed and accuracy of document productionVBA
programming | Visual Basic for Applications (VBA) — Macros in Word, Excel, Access Document assembly — Templates, menus, toolbars, buttons, custom fields, styles, hyperlinks, merges Transfers between applications — Data from Access database to Word document; Crystal Reports data to Excel for analysis; Access generating Crystal Report; Data from custom applications imported to Excel
| Database
development | Access databases — Switchboards, data entry forms, subforms, dropdown boxes, command buttons, action queries Normalization — Object naming, field and table splitting, relationships Data conversion — Data from previous Access versions, word processing documents, spreadsheets, and delimited text data converted to Access databases
| Crystal Reports design | Templates — Standardized report formatting and page design with core tables and relationships Report writing — Record selection, formulas, grouping, sorting, parameter prompts, summary fields, running totals, subreports, charts SQL databases — Documentation of table relationships, fields, values, and definitions to support development and verify data
| HotDocs
design | Templates — Libraries of related forms, shared component files, standardized document designs Formulas — Calculation variables, repeat formulas, models, and combination dialog boxes to organize data entry Upgrades — Existing templates modified for newer HotDocs versions
| 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 Function analysis — Staff interviews to determine roles and tasks; organization of content for training programs
| Technical
support | Help Desk — On-site and email assistance for formatting solutions, fixing problem documents, automating document production Software research — Use of Microsoft Knowledge Base, TechNet, MSDN Developer, Internet resources Features analysis — Determine applications appropriate for tasks, new features in software upgrades
|
|
