BASIC TUTORIAL

    Query:

    In this exercise we will search for all Parcels owned by Myton City Corp in Myton City.
    First, click on the Parcels Layer in the Layers List.
    The message below the map should read:
    Parcels is now the Active Layer.

    Click on the Query Tool.
    The Query Tool opens below the map.
    Click on the Field down arrow to open the list of Field Names.
    You can set up a simple or complex Query based on one or more of these Fields.
    Select the NAME1 Field.

    Select the LIKE operator .
    Enter MYTON CITY CORP* in the Value Box.

     Note: The * is the wildcard character.
    Search is case-sensitive.
    Now press the [Add to Query String] button.

    Notice the double quotes enclosing the character string. It is required.
    You may also type in this expression directly once you get familiar with the syntax.

     Now we will narrow the search by adding a second string.

    Click "And" box.

    Select the SERIAL Field.

    Select the LIKE operator.

    Enter M-*. (Serial numbers for Myton City start with letter M followed by "-"n and "number".  Example: M-1, M-2, M-999.

    Press the [Add to Query String] button.

    The query string should look like this: NAME1 LIKE "MYTON CITY CORP*" AND SERIAL LIKE "M-*"

    Press the [Execute] button to run the search.

 

    Scroll down to the bottom of the list.
    Notice that 10 records are returned in your list.
    Each record has MYTON CITY CORP as owner and M-number as serial number.
    Click on [Zoom to these records]
    The map zooms to these 10 records. They are highlighted in Yellow.

    Click on the hotlink for Record number 10.
    The map zooms to display Record number 10 and is shown with Orange highlight.
    The remaining records in the search list are highlighted in Yellow.

    Export Data Table to Excel

    Right Click anywhere on the Attribute Table.
   Click on 'Select All'.

    Right Click again on the Attribute Table.
    Select "Copy".
    This copies the contents of the Attribute Table to the clipboard.
 

    Launch Microsoft Excel.

   Right Click on top left cell A1
   Click "Paste".

    The Attribute Table is copied to Excel at cell location A1.

   Clear Selection

    Click the [Clear Selection] button to remove the highlights.