CONTACT US: 778-373-4422 | info@mackenziemackenzie.com


Photo by Andrea Picquadio from Pexels

How to Use Functions in MS Access Queries

18-December-2020
In this video, we are going to learn how to use functions of different kinds in our MS Access queries. Using functions is a nice way to process very complex calculations by creating a calculated column in your query. We will cover the usage of both Access “built-in” functions that are available to everyone, and custom functions that you can program yourself using VBA. You’ll find that there is a tight integration between Access and VBA, and this gives an incredible amount of power to query builders on this platform.



MS Access Project? Contact me today!

3 Reasons Why You Should Learn Data Techniques

Find 3 big reasons why you should learn data techniques if you are a professional or business person.

Read article

About our workshop

The Professional Problem, 3 Things They Need, and 1 They Don't Have

Why do people constantly run into problems with their data, even when they are highly trained in their area?

Read article

About our workshop

Why Finding Uniqueness is the Key: 6 Methods to Help

Find out why keys and uniqueness are so important for data transformation and data analysis.

Read article

About our workshop

When to Excel and When Not To: Why Specialists Don't Use Excel for Data Transformations

Start your journey in data transformation, and learn why specialists don't use Excel to transform raw data for analysis.

Read article

About our workshop