Our staff has extensive experience in automating Microsoft Office programs. Automation is not about taking jobs from people - it's about promoting efficiency and consistency. Automation frees your staff from repetitive tasks so they can concentrate on the more important aspects of their jobs. We have developed fully integrated applications making use of Excel, Access and Word as well as stand-alone templates, spreadsheets and databases Our clients range from pharmaceutical companies, manufacturing companies, insurance, telecommunications, consulting, and non-profit service providers as well as many other clients across a broad range of industries.

We can plan, design and build custom elements including simple to complex forms, templates, macros, databases and spreadsheets to perform the tasks you need it to do. By customizing a given Microsoft Office application or a number of applications together we can help you to:

Excel

Excel is a powerful and useful tool. Spreadsheets can be quite simple, but as the size of a project increases, so does the manageability of any spreadsheet. Our staff has the experience and knowledge to make your spreadsheets automated and more efficient. We can design automated functions within Excel that will allow you to convert Excel spreadsheets to an Access database with a push of a button.

Access

Access Databases are used not only for customer records and inventory, but for printing invoices, month-end reports, and much more. From a simple data entry form to a comprehensive database application, our programming staff can help. We can either guide you through the development of the solution or we can develop the solution for you and train you or your staff on how to use it. We offer support and maintenance programs for all our customized databases. If you have a database that is not meeting your requirements, we can fix, enhance, convert or upgrade your existing database.

Combined Office Applications

Billing systems: Example - store records in Access, produce invoices in Word and analyze in Excel.

Data manipulation: Example - store data in an Access database and use an Excel front-end for calculations and graphs.

Mail merge systems: Example - store customer information in Access and export data to Word for mailing labels or mass mailings.

Automated reports: Example - store records in an Access database and request snapshots of data from a formatted Excel spreadsheet or Word document. Reports can then be automatically emailed to a list of recipients.

Document management system: Example - faxes and memos created in Word can automatically be saved to an Access database.

Performance Support Tools:

On-line Help: Custom help files for particular tasks and standards can be built using the Windows Help system. You can turn this Help system on and off at any time on your desktop.

Cue Cards: Cue cards are little note cards appearing whenever a dialog box is activated. They provide information about the dialog box, information required, and what fields are required. The individual user can turn cue cards on and off.

Show-me Demonstrations: Show-me demonstrations are screen captures of a particular task. You can activate them at any time at your desktop.

Job Aids: These are custom reference cards to assist you to work through the more complicated tasks on a step-by-step basis.

Printed manuals: We can provided printed manuals for all our solutions we design.