Access XP

Creating a Single Table Query

• The Available Fields text box displays all the fields contained in the table selected in the Tables/Queries field. You are to select the fields to be used in the new query. You can pick one or more, or even all fields in the query.
  
  
  
  Click to highlight the first field to be included in the query—Last Name, for example—and then click the right arrow button. Repeat until you have selected all fields to be used (First Name, Address, City, State/Province, and Postal Code).
  
  
• If the fields you selected include a number field, you are asked to select a summary or detail query. To see each record, choose Detail. To see sums, averages, etc., choose Summary and set the summary options. Click the Next button.
• Type a name for the query (e.g., Contacts Mailing Address) in the What title do you want for your query? field.
  
  (Leave the Open the query to view information radio button turned on).
  
  
• Click the Finish button to run the query.