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.

• 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,...
• Bracher Emden Breast Bag Some American black female celebrities, such as Rihanna, Beyonce, all like carrying "strange" bags designed by geek designer. I have...
• Beautifying Your Home Let The Karen Brown Team do the hard work for you: Nothing beats a window seat for an instant infusion...
• Microsoft Access Database Knowledge. If you are the one who has too much data in your enterprise that you need to track, you may...