ExecuTrain Houston

Jan

11

Weekly Tip | The Access 2010 Expression Builder

Microsoft® Access 2010 Expression Builder Feature

The Access 2010 Expression Builder includes two new tools: IntelliSense and Quick Tips, to simplify and help improve accuracy when creating and
modifying expressions within Access objects.


Use IntelliSence in the Expression Builder

On the Query Tools Design tab, in the Query Setup group, click the Builder button. The Expression Builder opens.
1. Begin entering an expression function. The IntelliSense drop-down displays.
Expression Builder
2. Double-click or use the scroll and press the Tab+Enter keys to select a value from the list.
 
Note: Quick Tips appear when a value in the IntelliSense drop-down has focus.
Note: The Esc key disables the IntelliSense drop-down and the Ctrl+Spacebar keys enable the IntelliSense drop-down.