To create an advanced database query (indexes, filters, conditions, and command properties)

  1. Define the basic database query.
  2. Add an index to the query. Adding an Index to a Query
  3. Add a filter to the query. Adding a Filter to a Query
  4. Add a condition to the query. Adding a Condition to a Database Query
  5. Modify the command properties for the query. Modifying Database Query Command Properties
  6. Click Execute to test the query.
  7. Save the query.
  8. To make the query available to your VB or other application, select the text of the query and then select Copy from the Edit menu to place your query on the Windows clipboard.