The Query window has two main views: Design view and Datasheet view. The difference between them is self-explanatory: The Design view is where you create the query, and the Datasheet view displays the records returned by the query.

With tblProducts displayed in the top half of the Query Design window.

The Query Design window consists of two sections:

• The table/query entry pane (top)
• The Query by Example (QBE) design grid (bottom)

The upper pane is where tables or queries and their fields are displayed. Tables and queries are displayed as small windows inside the top pane (the proper name of this window is Field List). The Field List window can be resized by clicking on the edges and dragging it to a different size.

The Query by Example (QBE) grid holds the field names involved in the query and any criteria used to select records. Each column in the QBE grid contains information about a single field from a table or query contained within the upper pane.

• Washing Windows 101 Washing windows is one of those household chores that no really looks forward to. But cleaned windows can really give...
• Search Engine Marketing As part of your overall Internet marketing strategy, it is important to devote resources to search engine marketing. This component...
• Telephony and Call Manager Design - The Basics of Telephony Design OverviewPriority business requirement with today's enterprise companies is to reduce their capital and support costs while improving the effectiveness of...
• Beautifying Your Home Let The Karen Brown Team do the hard work for you: Nothing beats a window seat for an instant infusion...
• Weatherproofing Single Pane Windows It is very important that you weatherproof single pane windows. Depending on the climate you live in, certain things should...