Have trouble remembering function names or arguments in Microsoft Access? We all do! Access' Expression Builder is a great tool that walks you through the process of creating expressions for your forms, tables, reports and queries while keeping a handy reference at your fingertips. You can find additional assistance with Access functions by visiting our Microsoft Access Function Library.
You can use Expression Builder anyplace that Access expects you to enter an expression. Access indicates these locations by displaying the "..." icon, as shown in the figure above. To begin our step-by-step walk-through of Expresion Builder, activate it by clicking one of those icons. If you're having trouble finding one, try accessing the Default Value property of a table field.
NOTE: This tutorial is for Access 2010. You also may be interested in the tutorial Using Expression Builder in Microsoft Access 2007.