Run the Query

3. Try it: Run the Query

Go to Query Tools ->Design->Results.

Click on Run.

 

What Do You See? The MovieSearchSQ Query returned 401 movies.

There are four Fields:

MovieID

Movie

Rating

Genre

 

OK, the query works.

Now, let's build a form with it.

 

Do This, Now: Close the Query.

Query Tools ->Design->Results->Run

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Create a Select Query