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...

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Use the Expression Builder

Query Design Tools ->Design->Query Setup->Builder