Microsoft Office Tutorials and References
In Depth Information
Using Expression Builder
Whatever you insert into your expression is inserted at the position of the
blinking cursor or (if no blinking cursor is visible) at the end of whatever
text is currently in the expression. If you need to move the cursor before
inserting something into an expression, just click the spot where you want
to position the cursor. You can also press the ←, →, Home, and End keys
to position the cursor. Press the Backspace and Delete (Del) keys to delete
text in the expression. To undo your most recent change in an expression,
Getting help with functions
Just seeing the name of a built-in function in the third column of Expression
Builder doesn’t tell you much. You don’t know what the function does or
how you use it, but you can get instant information by clicking the Help
button. Follow these steps to access a help window:
1. In the left column of Expression Builder (refer to Figure 2-4), if the
Functions folder has a plus sign (+) next to it, click that sign to expand
2. Click the Built-In Functions folder in the first column.
The category names appear in the center column.
3. Click a category name in the middle column to see functions within
that category listed in the third column, or click <All> in the middle
column to see all functions in the third column.
The functions for that category appear in the third column.
4. In the third column, click the name of the function that you want to
find out more about.
5. Click the Help button in the top-right corner of Expression Builder.
The help window for that function opens.
6. If you don’t see specific help for the function, type the function name
in the Access Help search box.
Functions are listed by type in the help system, so if you need to find a
function in the help system, you’ll be able to find it quicker if you know
that it’s a Financial function, for example.
To see how this works, select the Financial category of functions in the
center column, click the PV function in the third column, and then click the
Help button. The help page that opens not only describes what the PV
function does, but also describes the syntax required for using the function. The
syntax of a function describes what information you need to pass (provide)
to the function for the function to do its calculation and return a result.