Extending Your Use of Queries 4. Click OK in the Join Properties dialog box. 333 Chapter Summary Queries are a database's workhorse. You can use them to select records, summarize and group records, update records, and delete records and to perform other operations. The criteria you add to a query let you perform these operations on specific sets of records, which makes managing and maintaining data much easier. Running action queries lets you manage large groups of records in a single operation--updating the value of a specific field or archiving records that you no longer need to maintain. By learning about SQL, the query language used by Access, you'll understand the precise operations of a query while creating advanced queries to your database. For more information: · See Microsoft Office Access 2003 Inside Out (Microsoft Press, 2003). Q&A Q1: When I'm creating a crosstab query, what rules should I follow to select the field whose val-ues I want to use as column headings and the fields I use as rows? You don't need to follow any hard and fast rules in this case. In part, the decision depends on how you want to organize your data. How- ever, Access won't run a crosstab query if the column heading field has too many distinct values. In general, the column heading field should be a field with relatively few values so that the data in the query is easier to view. If I'm going to create a query using an SQL statement, do I need to add tables to the query design grid first? No, the SQL statement is all you need. When you open the Query Design window, close the Show Table dialog box, click SQL View on the View menu, and start entering the SQL statement you need to define the query. When I run a make-table query, does the new table inherit the prop- erties and settings from the fields I used to create it? The new table inherits only the fields' field sizes and data types. It won't include a primary key designation, formatting, validation rules, and so on. You might not need to add these properties if you're using the new table only as the basis of a report. If you're using the table for other purposes, you'll need to modify its design. In the New Query dialog box, I noticed a wizard named Find Dupli- cates Query Wizard. What does this query wizard do? This wizard retrieves records that contain the same value in a field you specify. You could use this wizard to locate all tasks that start on the same date, for example. A1: Q2: A2: Q3: A3: Q4: A4: