J.2. Access Builders
Access 2007 offers nine builders that will guide developers through a process. You're familiar with the Query Builder. There are also some builders, such as the Color Builder, that are available in other Office programs. In Access 2007, the Field Builder is replaced by table templates and the Color Builder is enhanced to provide the color picker used by other programs.
| Builder | Description |
|---|---|
| Color | Enhanced to use the color picker used by other programs. In addition to a larger selection of color swatches, it also displays a palette for selecting customized colors. |
| Edit List Items | Builds and edits value lists that are the row source for combo box and list box controls or for lookup fields in tables. |
| Expression | Creates expressions for macros, queries, and property sheets. |
| Field | Creates fields in tables in previous versions. Replaced by table templates in Access 2007. |
| Macro | Creates and edits macros, such as those created when a command button is added to a form or report. Builds both embedded and standalone macros. |
| ODBC Connection String | Creates the correct syntax for a connection to an ODBC database. Walks users through the process to establish a connection to an external data source. |
| Picture | Creates bitmap images for forms and reports. |
| Query | Creates the correct syntax for a query. |
| Smart Tags | Displays a list of available smart tags and their actions. Smart tags enable you to perform tasks within Access that you otherwise would have needed to open other programs to handle. Smart tags ... |
Get Access™ 2007 VBA Programmer's Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
