DATABASES

We focus on managing the integrity of your data so that you can get the information you need when you need it.

Avoid typing the same data over and over. Ensure that your data is clean and correct. Quickly filter and sort your data. Generate meaningful reports.

​

We work primarily on the Microsoft database platform, developing solutions in SQL Server and Microsoft Access.

EXCEL AUTOMATION

Excel is a great tool for analyzing your data, but how much time are you spending on tasks like importing data, formatting and charting? Probably too much. We develop Excel solutions that tap into your databases and automatically refresh your reports, apply filters, generate PivotTables, and more.

​

Our solutions often start with the simple Microsoft Excel Macro Recorder. It's a great tool for getting a jumpstart on your process, but usually needs some tweaking and enhancement to be fully functional. We delve into the VBA code behind the macro, adding functionality and making sure you end up with a simple, effective solution. We specialize in creating macros that will grow with you, giving you opportunities to alter the macro's functions without ever looking at the code!.

INTEGRATION

Your software systems can talk to each other.

​

You've got software for lots of different functions: Finance, ERP, CRM, Order Entry, Scheduling... the list goes on.

​

That data can come together in several ways. An Excel report can connect to multiple data sources, allowing you to sort, filter and pivot your data. Order data can be exported from your Order Entry system and imported into your Invoicing system. CSV data received from your vendors can be loaded into your database.

​

The possibilities are endless.