2. In the Query Designer, click in the Field row in the column in which you want to insert the calculated field . 3. Type the expression that performs the calculation . To provide a custom label for the calculated field, type the label you want to use before the expression followed by a colon . To open the Zoom dialog box to write the expression, press Shift+F2 . To open the Expression Builder for help writing the expression, click Builder in the Query Setup group . Entering an Expression in the Zoom Dialog Box When you need to write an expression to create a calculated field in a query (or to define criteria), you can open the Zoom dialog box to give yourself some extra space in which to write the expression or to edit an expression that is already defined .
4 Creating and Managing Queries 463 To open the Zoom dialog box, click in the design grid where you want to create the expression—in the Criteria row, for example, or in the Field row—and then press Shift+F2 . The Zoom dialog box provides a large text box in which you can compose an expression . Click the Font button in the Zoom dialog box to display the Font dialog box . You can then select a different font, font style, font size, and other attributes . You won’t see this formatting in the Query Designer, but it might improve the readability of the expression while you are working with it in the Zoom dialog box . ➤ To display the Zoom dialog box to write or review an expression 1. In the query design grid, click in the cell where you want to write an expression . 2. Press Shift+F2 . 3. Click the Font button in the Zoom dialog box to format the text you enter there . Getting Help with the Expression Builder When you want help creating an expression, you can use the Expression Builder . To open the Expression Builder when you are working on a query in Design view, right-click in the Field or Criteria row and choose Build . You can also click Builder in the Query Setup group .
464 Exam 77-885 Microsoft Access 2010 Specialist You work in four panes in the Expression Builder . You create the expression in the top pane by typing or by selecting options in the Expression Elements, Expression Categories, and Expression Values panes . The Expression Values pane is blank until you choose an option other than the current object—Orders Query in the preceding screen shot—in the Expression Elements pane . You can hide the three bottom panes by clicking the Less button . Click More to show them again . When you build an expression by selecting items in the three bottom panes, you generally move left to right . When you select an element in the Expression Elements list, the categories for that element appear in the Expression Categories pane . When you select a category, the Expression Builder lists the values related to that category in the Expression Values pane . Double-click an item in the Expression Values pane to add it to the expression .
You've reached the end of your free preview.
Want to read all 200 pages?
- Spring '13
- Romeo and Juliet, Microsoft Corporation, Objective Review