1. Open a blank Excel spreadsheet.

2. Switch to

   the 

   the Data

    tab

    tab and click

   the 

   the Existing Connections

    button

    button.

   Image RemovedImage Added

    

3. In the window that opens, choose the query you’d like to run (e.g., Immunizations

    or 

    or Birth Control) from under

   the 

   the Connection files on this computer

    section

    section and click

   the Open button

   the Open button.

   Image Modified
    

4. When you see this window, click

   the OK button

   the OK button.

   Image Modified

    

5. Give it time to load and then it will show you the data in a blue table on the spreadsheet.  The default is shows you all of the data from January 1, 2014 to the present day.

Filter the Data

1. Click the down arrow in

   the 

   the Day

    column

    column to open the following menu.

   Image Modified

    

2. Uncheck 

   Uncheck (Select All)

    and

    and then check only the years that you want to see.  You can also click the + icons to open and filter even further by months or days.

3. Once you have the date range you want to see, click

   the 

   the OK

    button

    button and the table will show only your chosen days/months/years.

4. Next, click the down arrow in

   the Comments columnUncheck 

   the Comments column.

5. Uncheck (Select All)

    and

    and then check only the items that you want to see and then click

   the OK button

   the OK button.

6. Check

   the 

   the Total Row

    option

    option in

   the 

   the Table Tools Design

    tab

    tab to get the total number of rows auto-calculated at the bottom of the table.
   Image Modified

   Note
   You must click on a cell in the blue table in order to see the Table Tools Design tab

7. When you are done with the query, close the Excel spreadsheet

   and 

   and do not save it; you need to start from the beginning each time so that it pulls the most recent data.

8. Repeat the above process to see the other query (e.g. Immunizations

    or 

    or Birth Control).

Related articles

...