Using PowerPoint to create graphics
PowerPoint‘s ability to export slides as image files makes it an incredibly easy-to-use, versatile image creation application. Whilst it is…
Selecting function criteria in Excel
When using Excel logic functions such as COUNTIF and SUMIF which involve ranges being evaluated based on criteria, you cannot…
Using PowerPoint’s Eyedropper tool
In the following scenario, we have an image in a PowerPoint slide and we want to match the colour of…
VBA for Excel: a little logic
This post follows on from the Hello World Excel VBA post which is an introduction to the world of VBA.…
Cleaning data in Excel
In the example below I have used three Microsoft Excel functions to identify and then correct a common mistake that…
Getting locked up in an Access database
The Microsoft Access interface is a great deal more complex than say that of Microsoft Word or Excel and at…
An Access Form for data entry only
THIS POST IS “UNDER CONSTRUCTION” – PLEASE CHECK BACK SOON OR COMMENT BELOW! Modifying the properties of an Access Form…
The Primary Key in a database table
The Primary Key of a table is the field that contains the value which uniquely identifies each record in that…
Teaching database theory
At this stage, this post is a jumbled collection of thoughts that I am putting down in writing for the…
Adding content to a Word document when it starts with a table
A Microsoft Word document might contain only a table, or it might start with a table as its first piece…