Microsoft Access Database Tutorial – Selecting Unique And Distinct Values In A Query

Microsoft Access Database Tutorial – Selecting Unique And Distinct Values In A Query

There are many different types and ways to run queries that your Microsoft Access database application provides and one useful ms access query is where you can create a distinct or unique value list from duplicate or repeating values from other records.

Check out this 4 minute video tutorial which clearly explains two ways to create a unique value query report.

httpvh://www.youtube.com/watch?v=CymoHytiIWM

As the video shows, you can use either the property sheet to select unique value or the SQL statement approach using the keyword Distinct. In fact, an extension to Continue reading “Microsoft Access Database Tutorial – Selecting Unique And Distinct Values In A Query”

Access Database Tutorial is 4 Years Old

Access Database Tutorial is 4 Years Old – This Week!

I can’t believe it, Microsoft Access Database Tutorial is 4 years old this week!

Spending the time to create a website offering various tools, resources and free tips and tricks was really down to my students which I’m very grateful to them for inspiring me to create a successful online service and it’s been an amazing journey so far but where has the time flown? 4 Years on!

microsoft access database tutorial 4 years old

With all the newer applications and online web processes of today, Microsoft Access has kept up at a reasonable level too with SharePoint and better collaboration but ultimately it’s the power of the desktop version with the power of Access VBA that really can’t be Continue reading “Access Database Tutorial is 4 Years Old”