+44 [0]1438 832724 david@databasics.uk

Access Database: Get Started

Uncategorised

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

Uncategorised

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

Uncategorised

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

Uncategorised

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,...

Programming Excel: Principles

Microsoft Excel, Programming

This is post 1 of 2 in the series “Programming Excel” Programming Excel: Principles Programming Excel: Record a simple macro So, just to clarify, when we talk about programming Excel, we are not talking about using the standard functions and formulas. In...
Getting started with Data Management

Getting started with Data Management

Data Management

We’ve all heard of “garbage in, garbage out”, so even though the primary focus of any statistical analysis will be the outcome, that will be next to useless without the proper raw materials. Indeed, many analysts might claim that the process is in...
Socrates – a lovely little thinker!

Socrates – a lovely little thinker!

Critical Thinking

Yes, it’s my age – I was brought up on Monty Python, and every time I hear names like Socrates, their “Philosopher’s Song” pops into my head! However, when it comes to critical thinking, which is an essential skill, both in business and...

Business and Management Models

Business Models

You will come across countless models and methodologies circulating online and, as with anything, some are useful and others are useless, and many are simply variants on the same themes – it can be difficult to sort the wheat from the chaff! Databasics UK...

Data Literacy – What and Why?

Uncategorised

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...