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

Create a Subquery

Basically, a subquery is just a query in a query. The subquery can be used to filter the information or prompt the user to enter a value.

 

Try This: Create a Subquery

Go to Create -> Query Design.

Select Show Table and view Both Tables and Queries. Add the following:

NewFamilyMoviesSQ

tblMovieTitles

tblRental

Query Tools-> Design-> Show Table
 
 

 

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

  4.1.5. Create subqueries