Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.3 Utilize Calculated Fields and Grouping Within a Query: Add Calculated Fields (Expression Builder)

Use the Expression Builder 9. Try it: Select an Expression Category Go to the Expression Elements. Double Click the database: FrontRowVideo Int4.accb. Double Click: Forms. Double Click: All Forms. Select a Form: MovieSearch.   What Do You See? The Expression Categories list all of the Fields that are available on the MovieSearch Form including the Popcorn Logo.   Try This, Too: Select an Expression Category Double Click: RatingCombo.   Now, What Do You See? The Expression Builder will write the qualified name: Forms![MovieSearch]![RatingCombo]   Where Forms is the Access Object, [MovieSearch] is the name of the Form, [RatingCombo] is the name of the Control.   Click OK to close the Expression Builder and return to the RatingSearchSQ Query. Keep going... Query Design Tools ->Design->Query Setup->Builder