Using the SQL Wizard

The SQL Wizard is used with the Recordset, Insert, Delete and Update objects.

Use the Fields tab in the SQL Wizard to select specific datafields to query. If you added your tables and datafields in the Schema Editor, the datafields will appear after choosing a table. For instance, if you have a table named "Students" and you want to query the records by last name, major, and classification, you would highlight the "LastName", "Major", and "Classification" datafields listed.

You can also use the Where Clause tab to narrow your search results. You use this when you want to return records that match a particular set of criteria. So, rather than pull records for all students in your class, you can narrow your results by searching for "Biology" in the Major datafield, which in turn, will return only those records meeting that criteria.

The where clause is not required; however, using a where clause is recommended. If you have, for example, 10,000 rows of data, it is likely you won't want to return them all. You can use the Where clause to filter your results to a manageable number. In addition, you can use the where clause to view the impact of updating or deleting records before actually carrying out the action. For example, if you are going to delete records, first use the Where clause to display the records you will be deleting. If you see that the data you will be deleting is wrong, you can make adjustments before taking any actions that cannot be undone.

Next