Activity 2-1 Creating Subqueries in Ms Access 2007

About this tutorial:

Video duration: 00:03:35
A subquery also known as an inner query, is a query that is contained within the outer query. Subqueries are always written within parenthesis and can contain multiple inner queries, with each inner query enclosed within parenthesis. In this activity 2-1 we will:

Create a new query in design view

Create a subquery using the Criteria row of the ProductID field to retrieve records pertaining to a particular category.

Lastly, we will test the query.

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads