Query By Example Grid
After you add the tables to your query design, a field list for each table appears in Design window. The lower half of the window is known as the Query By Example (QBE) Grid . This grid is where the actual fields of your query appear.
The QBE grid shows the fields and properties that make up this query’s dynaset. The Field cell indicates the field that is being queried. The Table cell shows from which table the field is taken. The Sort cell tells you how the information in that field will be ordered in the query. The Show cell indicates whether the field will be shown in the query’s datasheet.
You can place criteria on each field being queried. You should remember that the selection process will follow the criteria from left to right on the QBE grid and that this may change the results of your query.