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.

• 4 Reasons Not To Use Internet Explorer [/caption] Internet Explorer is the default browser included on every Windows machine, but does that mean it’s the best browser?...
• Top Best 100 Incredibly Useful & Free Mac Apps [/caption] Everyone loves free applications. One of the greatest things about Macs is the wealth of extremely talented developers that...
• Install Interior Window Shutters to Cool Your House If you’re dealing with a lot of windows in your home and you are worried about keeping it cool inside,...
• Washing Windows 101 Washing windows is one of those household chores that no really looks forward to. But cleaned windows can really give...
• Weatherproofing Single Pane Windows It is very important that you weatherproof single pane windows. Depending on the climate you live in, certain things should...