Home

 

Joy E. Daniels     ♦ Programming Training Support

Services

 

Services
Products
Training
VBA Code
Shortcut Keys
Documentation
Clients
Contact

Increasing the speed and accuracy of document production

VBA
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 databasesSwitchboards, data entry forms, subforms, dropdown boxes, command buttons, action queries

  • NormalizationObject naming, field and table splitting, relationships

  • Data conversionData from previous Access versions, word processing documents, spreadsheets, and delimited text data converted to Access databases

Crystal Reports design

  • TemplatesStandardized report formatting and page design with core tables and relationships

  • Report writingRecord 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

  • FormulasCalculation variables, repeat formulas, models, and combination dialog boxes to organize data entry

  • UpgradesExisting templates modified for newer HotDocs versions

Documentation

  • Custom training materialAnalysis, testing, and writing for custom applications and Sarbanes-Oxley procedures

  • Web-based applicationsTraining modules, online virtual tours, storyboards for web-based training, online pre- and post-tests

  • Function analysisStaff interviews to determine roles and tasks; organization of content for training programs

Technical
support

  • Help DeskOn-site and email assistance for formatting solutions, fixing problem documents, automating document production

  • Software researchUse of Microsoft Knowledge Base, TechNet, MSDN Developer, Internet resources

  • Features analysisDetermine applications appropriate for tasks, new features in software upgrades