Microsoft Office and Access Development Services

Application

"Maximize the capability and ease of use of your MS Excel and Access business assets."

Aging Microsoft Office and Microsoft Access projects don’t have to be a bur in your saddle any longer.  We can help you keep them running, improve their usability or convert them into something new and exciting.

For MS Access, we provide assistance with these areas and more:

  • convert/rewrite an Access database as a modern .NET Windows or Web application
  • performance troubleshooting for large and sluggish databases
  • troubleshooting database corruption and repair issues
  • complex queries and reports
  • data cleanup including removal of duplicate and fixing of inconsistent values
  • extract and publish information to the web for access by others including mobile devices
  • streamline clumsy data entry forms
  • integration of departmental based Access silos into a central company-wide repository
  • macro and Visual Basic for Applications (VBA) coding
  • enable existing VBA code to run correctly on a 64-bit edition of Microsoft Access
  • connecting to other databases such as DB2, MySQL and Oracle with linked tables and pass-through queries
  • maintaining a SQL Server based Access Data Project (.ADP)
  • specialized printing (bar codes, dynamic printer selection, custom paper size, Zebra and Data max label printing, receipt printers, enabling advanced Xerox copier/printer functions such as stapling and hole punching, etc.)
  • integration with other applications such as QuickBooks using COM automation and ODBC
  • specialized Excel exports
  • upgrade older Access databases to the latest version
  • setup a project for use with the run-time edition of Access
  • configure or remove the old Access workgroup security paradigm (MDW)

For MS Excel, Word and Powerpoint, we provide assistance with these areas and more:

  • custom macro and Visual Basic for Applications (VBA) coding
  • COM automation
  • create custom Excel plug-ins
  • Pivot tables from a SQL Server Analysis Services (SSAS) data source

Additionally, Excel and Word documents can be created dynamically (without an Office install) from data sources such as databases or web feeds using tools such as Powershell, Java and C#.

For additional info, read about our application development services.