Access 2007 Demo: Use the Expression Builder

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.

This entry was posted in Forms, Macros, MS Access, Queries, Reports, Tables, Utilities and tagged , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>