Access Database: Get Started

This is post 2 of 2 in the series “Access Database Basics” Access Database: Principles Access Database: Get Started First things first – we need a file to work with! Access doesn’t let you just build something and then save it, in the same way...

Access Database: Principles

This is post 1 of 2 in the series “Access Database Basics” Access Database: Principles Access Database: Get Started The Access database application in Microsoft Office is a divisive issue. Lots of “techies” claim that it has no place in serious...

Programming Excel: Relative References in macros

On the View ribbon in Excel, the third option under the Macro section says Use Relative References. This may seem a bit of bewildering technical jargon at first but it makes quite a bit of sense once you get used to it. First, make sure that the option is switched off...

Programming Excel: Record a simple macro

This is post 2 of 2 in the series “Programming Excel” Programming Excel: Principles Programming Excel: Record a simple macro Visual Basic for Applications (VBA) is a relatively straightforward and inuititive programming language that is, nonetheless,...

Data Literacy – What and Why?

So, there’s a lot of talk about data literacy these days, but what is it, and what does it mean? Well, of course, it depends who you ask! The research and advisory firm Gartner define it as: the ability to read, write and communicate data in context, including...