Microsoft Access Update Queries: An Action Query

Microsoft Access Queries: An Action Query

I witnessed a cardinal sin of one person manually editing the same value across multiple records instead of using one of Microsoft Access queries well known action query; the update query.

Take a quick look at this preview video which is seven minutes long and covers the essentials (and ignore the title with reference to programming in 2013 – not applicable here).

httpvh://youtu.be/NT1xvodbUQE

In this video, the author mentions the exact match (in double quotations marks) when setting the criteria as well as Continue reading “Microsoft Access Update Queries: An Action Query”

Microsoft Access Database: Working With A Database You Didn't Create

Microsoft Access Database: Working With A Database You Didn’t Create

Working with Microsoft Access database is a skill to have and makes you stand out from the crowd of advanced Excel spreadsheet users and those wishing to step up and move into the world of MS Access will probably start by inheriting other people’s databases.

So what’s the first thing you need to do if you are given someone else’s Access database?

microsoft access database working with a database you didnt create

I wrote another post about a couple of years ago which addressed the challenges of inheriting other people’s Microsoft Access databases and Continue reading “Microsoft Access Database: Working With A Database You Didn't Create”