An excellent video tutorial on how to use the Access database Expression Builder tool. It clearly explains the features of this powerful and useful tool making good use of the terminology with ‘jargon’ free explanations.
This tool can be used in a query, form, report, macro and to a lesser extent tables too and applies to all versions of Microsoft Access (as far back as you really need to go!).
Here’s a tip to bear in mind (especially when using this tool for a query). Before utilising the expression builder tool in a query, first save the query as it will not show all the fields for an unnamed query object limiting the flexibility of this tool.
In Access 2010, this tool has been updated and has a different look and feel to it but essentially can be used in the same way.