Hello, Expression Builder

8. Try it: Review the Expression Builder

At the top of the Expression Builder is the box where the code will be written.

 

The Expression Builder also has three columns:

Expression Elements

Expression Categories

Expression Values.

 

What Do You See? Look in the Expression Elements. RatingSearchSQ is selected.

 

There are two Expression Categories: Rating and Genre. These are the two Fields in 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