Creating a super Q-pointer

Follow these steps to create a Super Q-pointer called usacustomer to retrieve data from the Customers table.

Procedure

  1. Type u md usacustomer
  2. Type q in attribute 1.
    Note: Attribute 2 is left blank, press ENTER to continue.
  3. Type msaccess.nw:odbc:usacustomer in attribute 3.
  4. Type a table name in attribute 4, and then press CTRL+V. For example, type:
    customers
  5. (Optional) Type a where clause, and then press CTRL+V. See Creating a super Q-pointer. For example:
    country - 'USA'
  6. (Optional) Type a candidate key, and then press CTRL+V. See Creating a super Q-pointer. For example:
    customerid
  7. Type a column name(s) from the Customer table (Northwind) database, and then press CTRL+XF to save to file. For example:
    companyname
    city
    region
    country

    The Super Q-pointer usacustomer displays.