Now that you have been introduced to the Query Design view, it is time to try creating a query using Design view.
Generally you will use Query Design view to create a query that combines fields from different tables. You may also add criteria to the query
so that you see a subset of all records. However, as I mentioned earlier, if you want to calculate summary data, you will find that the Simple
Query Wizard is the best way to go--at least until you learn about grouping in Design view. After you create a query in the Design view, you
will view it in the query datasheet
Creating a query in Design view is similar to using the Advanced Filter/Sort feature. To create a simple query there are only two steps:
Try your hand at creating a query in Design view.
Creating Query in Design View - Exercise