Access: Research Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Query Tools-> Design-> Build

 

 

Create the Rating Combo

Try it: Program the Rating Combo

1. Open the MovieTitleSearch form in Design View.

 

2. Use the Combo tool to create a new control with RatingSearchSQ as the record source.

 

3. Select the Rating field for the Combo.

 

4. Store the Rating in the Rating field.

 

As you walk through the wizard, you may not see any ratings in the Combo preview. That’s OK this time.

 

  Microsoft Access 2007 Exam 77-605 Topic: 2. Creating and Formatting Database Elements 

  2.7. Modify the design of reports and forms  2.7.1.   Add controls: Add controls using the Ribbon