Archives

Power Query is a powerful business intelligence tool inbuilt in Excel, that allows you to import data from any number of sources, clean it, transform it, then reshape it accordingly. This once off created query can then be re-used over and over again by simply refreshing it.

If you are a MS Office user you may well have seen the following security message, also known as ‘The Mark of the Web’, appearing on your Excel, Access, Word, Viso and PowerPoint files. If you haven’t already you will likely start seeing them in the near future!

Wouldn’t it be great if we had robots to do everything for us? Okay, maybe not everything but certainly the mundane and the tedious! Robotic Process Automation (RPA)  

Outlined here are some of the typical process steps in a full LIMS step-up:

In the pharmaceutical industry, Quality Assurance (QA) is essential for ensuring that products are manufactured and delivered to a safe and consistent standard, adhering to all guidelines, standards and stringent regulatory requirements set upon them. A challenge for all Pharmaceuticals is then how to effectively manage the whole Quality Assurance process as smoothly as possible […]

BUILDING A BESPOKE MAIL MERGE SYSTEM? One of the most common requests to our software development department is to deliver a system with bespoke advanced mail merge functionality. This might be to develop a brand new solution or to develop an extension to an existing tool!

Looking to migrate an MS Access application to MS SharePoint or to develop a new project utlising the MS Access and MS SharePoint platform model? Well look no further  

I’m just back from my summer holidays. Had a nice family trip to France. I arranged it many months ago – booked the ferry, campsite, insurance and so on. Leaving nothing to chance, I made sure that everything was ready in advance and all I had to do was relax.

I went to a café last week for lunch and bumped into an old acquaintance.

Yes, we know: if you are in the database Server end of the business, the lion’s share is claimed by Oracle, MS SQL Server, and MySQL, the workhorse of most web servers running on BSD/Linux systems. SQLite reigns in small Android powered devices (why do they insist in call them “phones”, anyway?) and tablets, a […]