|
The Query
Design is fascinating. Once you see how it works, one can only
marvel at the simplicity.
9.
Try it: Review the Query in Design View The
Find duplicates for tblMoviesSQ Query is
open. Go to
Home->Views->View->Design View. What Do
You See? This Query has one Table: tblMovies. There are only
three Fields in the QBE Grid. The Totals Row is available. Queries
read from left to right. So this Query is asking three questions.
Movie
Field: Movie asks "Which movie? Is this the first time we've
seen this movie in the list?" This Field looks in tblMovies for the
First time a movie appears.
NumberofDups: Movie asks "Is there more than one copy of this
movie?" This Field looks in tblMovies and Counts the Records.
The Criteria is (Greater than) >1. Movie
asks "Are we the same? Ok, let's Group!" This Field Groups
the movies that match. Way cool.
Please Close this Query.
Home->Views->View->Design View
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.1.1. Create tables in Design View
|
|
| |
