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

Review the Query

In this example, the query filters the movies by Year(>"2000") and Rating ("G").

 

These Criteria are "hard coded," or programmed into the query. This query, as it is pictured on this page, will always return G-rated movies.

 

Try It: Create a Parameter Query

A Parameter Query prompts the user to answer the question: which Rating?

Select the Rating Field.

Edit the criteria: [Enter the Rating].

Run this query a test the parameter.

Query Tools-> Design-> Run
 
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 4.  Creating and modifying queries

  4.1.5. Create subqueries