1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

Using Expression Builder in Microsoft Access 2010

By

1 of 5

Getting Started
Expression Builder Icon

Expression Builder Icon

Mike Chapple
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.
  1. About.com
  2. Technology
  3. Databases
  4. Microsoft Access
  5. Tutorials
  6. Using Expression Builder in Microsoft Access 2010

©2014 About.com. All rights reserved.