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.

• Save Time, Money and Space in Over 80 Ways If you're looking for handy gadgets, tools and various items that can save you time, money or space (or all...
• Windows XP logs on then logs off immediately Yesterday, someone I used to work with call me and ask for help with his computer. It was doing something...
• 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,...
• Search Engine Marketing As part of your overall Internet marketing strategy, it is important to devote resources to search engine marketing. This component...
• Verizon staff had unauthorized access to Obama's cell Verizon Wireless said on Thursday that some employees had gained unauthorized access and viewed a personal cell phone account held...