Standard ACE DBnb` Ugr@?~1y0̝cßFN`7Cߜ( -`J{6߱ioC43*y[.|*|q ]f_Љ$g'DeFx -bT4.0 dv YUS UU Y   Y 'Y  Y Y  Y  Y  Y   Y  Y a Y  Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeXYYIdParentIdName        OYb^! S  UY Y Y  Y 2 ACMFInheritableObjectIdSID -  > @YObjectId Y>S  >Y  Y Y Y  Y 6 Y NY  Y  ,AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order, N,  ,NׁY"ObjectIdAttribute   -YS  Y Y Y  Y   Y  Y  Y  Y occolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship Ieee uY YYYYszObject$szReferencedObjectszRelationship v1b N  : k & HI"c@@  @@@   @ @@@ @@ @@  Si`+^dMJmYdbkSkoL+bQJiQkm+^dMJmYdbSkoL+dLkQiqJmYdbkSkoL+qYkYmkksYmMWLdJiO`JM+Si`+^dMJmYdbk`JM+ksYmMWLdJiO JO`Yb!OJmJJMMQkkfJUQkOJmJLJkQkSdi`k`dOo^QkiQ^JmYdbkWYfkiQfdimkkMiYfmkkvkiQ^mJL^Qk+kh+MSi`+^dMJmYdbk+kh+MSkoL+bQJiQkm+^dMJmYdb"+kh+MSi`+^dMJmYdbk+kh+MSkoL+qYkYmk#+kh+MSkoL+dLkQiqJmYdbk+kh+MkfQMYQk+YOS$+kh+MSkoL+qYkYmk+kh+MdLkQiqJmYdbk%+kh+SSi`+^dMJmYdbk&+kh+SSkoL+bQJiQkm+^dMJmYdb'+kh+SSkoL+dLkQiqJmYdbk(+kh+SksYmMWLdJiO+`kvkJMMQkkkmdiJUQ+`kvkJMMQkku`^+`kvkJMQk`kvkMd`f^QuMd^o`bk`kvkMd`f^QumvfQ+JmmJMW`Qbm`kvkMd`f^QumvfQ+OQMY`J^`kvkMd`f^QumvfQ+UoYO`kvkMd`f^QumvfQ+YQQQOdoL^Q `kvkMd`f^QumvfQ+YQQQkYbU^Q `kvkMd`f^QumvfQ+^dbU `kvkMd`f^QumvfQ+kWdim `kvkMd`f^QumvfQ+mQum`kvkMd`f^QumvfQ+obkYUbQOLvmQ `kvkY`QuMd^o`bk+`kvkY`QukfQMk+`kvkbJqfJbQUidofMJmQUdiYQk+`kvkbJqfJbQUidofk+`kvkbJqfJbQUidofmddL[QMmk+`kvkbJqfJbQdL[QMmYOk+`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkhiv+Md`LYbQO+OJmJ+ hiv+Md`fJiQ+OJmJ+Y`fdimQO+ hiv+Md`fJiQ+OJmJ+iJs+ hiv+Md`f^Qu+MiYmQiYJ+QuJ`f^Q+ hiv+SdiQkm+kmJmk+ hiv+SdiQkm+kmJmk+JqQiJUQ+OYSSQiQbMQ+hiv+SdiQkm+kmJmk+QJkm+hiv+Y`fdim+^dMJmYdbk+OJmJ+hiv+Y`fdim+dLkQiqJmYdbk+OJmJ+hiv+Y`fdim+kfQMYQk+OJmJ+hiv+Y`fdim+qYkYmk+OJmJ+hiv+Y`fdim+qYkYmk+OJmJ+:+hiv+YbOYqYOoJ^k+fQi+kYmQ+`Ju+hiv+YbOYqYOoJ^k+fQi+qYkYm+hiv+^dMJmYdbk+JbO+qYkYmk+hiv+bQJiQkm+^dMJmYdb+hiv+bo`LQi+dS+OQmQMmYdbk+Lv+kfQMYQk+hiv+bo`LQi+dS+kfQMYQk+Lv+kYmQ+hiv+difWJbQO+dLkQiqJmYdbk+hiv+fJiJ`QmQi+hoQiv+QuJ`f^Q+hiv+kfQMYQk+Lv+^dMJmYdb+JbO+SdiQkm+hiv+kfQMYQk+Lv+kYmQ+hiv+ofOJmQ+Mdobm+ksYmMWLdJiOYmQ`k+ mL^+^dMJmYdbk+!mL^+dLkQiqJmYdbk+"mL^+iJs+OJmJ+#mL^+iJs+OJmJ+:+$mL^+qYkYmk+%m^o+LYiO+MdOQk+qmm^o+kfQMYQkumJL+kfQMYQk+Lv+^dMJmYdb+JbO+SdiQkm`kvkOLko``JivYbSdokQiOQSYbQOmL^+^dMJmYdbkmL^+qYkYmk mL^+kfQMYQkmL^+dLkQiqJmYdbkmL^+qYkYmkmL^+dLkQiqJmYdbk#  @ @ @ @ @ @ @ @ @ @       !"#$%&'(++ + + + + +++ +!+"+#+$+%+&+'+(+)+*+++,+-+.+/0 12     !#%',+J+O+S+V+Z+_+e+p+ t+!y+"+#+$+%v1  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @    $%&'( ) * + , - . / 0 1 2 3 4 5 6 789:;<=>?@ABCDEFGHIJKLMNOPFGHI        !!!"""###$ $!$"%#%$%%&&&'&(')'*'+(,(-(.)/)0)1*2*3*4+5+6+7,8,9,:-;-<-=.>.?.@///000111222=>?  @ABCDE ()*"#$ !!!!###%%%&%'''',,,JJ J O+O,O-S.S/S0V1V2V3Z4Z5Z6_7_8_9e:e;e<pApBpCtDtEtFyGyHyIJ       !"#v1`nim)))))))) ) )) ) )) ))))))))))))))))) )!))")$)%)& )')#)()*)+),)-))).)0)1)2)3)4)5)6)7)8)9):);)<)= )>)?)@)A)/)B)D)E)F)G)H)I)J)K)L)M)N ii)Ciiiiiii i i i ii iiiiiiiiiiiiiiiiii i!i"i#i$i%i& i' i(ii)i+i,i-i.i/i0i1i2i3 i4 i5 i6 i7 i8 i9i* i: i< i= i> i? i@ iA j j j j i;!j!j!j!j!j !j ! j ! j !j"j "j"j"j"j"j"j"j"j"j" j" j" j" j" j" j"j#j#j #j!#j"#j##j$#j%#j&#j'#j(# j)# j*# j+# j,# j-# j.#j$j/$j1$j2$j3$j4$j5$ j6$j0%j7%j9%j:%j;%j<%j=%j>%j?%j@%jA%l%j8jv1@ mL^+^dMJmYdbkmL^+qYkYmk mL^+kfQMYQkmL^+dLkQiqJmYdbk mL^+qYkYmkmL^+dLkQiqJmYdbk  mL^+dLkQiqJmYdbk mL^+dLkQiqJmYdbk mL^+qYkYmk   mL^+^dMJmYdbk mL^+qYkYmk m^o+kfQMYQk )d _ Z  G q  0 =X1-F_4CMIB@cc@cccc@cc@~sq_ffsub_ObservationsLLLLLLLLLLL 3Bc@iBc@~sq_ffsub_Nearest_LocationF4MR2KeepLocal TVVVVVVVT @Bc@Bc@~sq_ffrm_LocationsF4MR2KeepLocal TFFFFFFFD @@woc@oc@~sq_cfsub_Observations~sq_cSpecies_IDFF4MR2KeepLocal Tnnnnnnnl @Ec@"Ec@~sq_cfrm_Locations~sq_cfsub_VisitsF4MR2KeepLocal Tfffffffd @ mb@ŀac@AdminF@8,,,,,,,,,* v,Nc@v,Nc@mac_SwitchboardF@@@@@@@@@@>  A6ʟc@c@mac_frm_LocationsF@PPPDDDDDDDB @ h03c@h03c@SwitchboardFF@DDD88888886 @ >}gzc@>}gzc@fsub_VisitsFT@DDD88888886 @ >8|c@>8|c@fsub_ObservationsFJ@PPPDDDDDDDB @7(]c@7(]c@frm_LocationsFh@HHH<<<<<<<: @ rkeb@rkeb@UserDefinedF@DDD88888886 @ rkeb@rkeb@SummaryInfoFl@DDD88888886 @rkeb@rkeb@SysRelF.........., rkeb@rkeb@ScriptsF0000000000. rkeb@rkeb@ReportsF0000000000. rkeb@rkeb@ModulesF0000000000. rkeb@rkeb@FormsF,,,,,,,,,,* rkeb@rkeb@DataAccessPagesF@@@@@@@@@@> 'keb@keb@MSysComplexType_AttachmentTTTTTTTTTTT %keb@keb@MSysComplexType_TextHHHHHHHHHHH #keb@keb@MSysComplexType_DecimalNNNNNNNNNNN !keb@keb@MSysComplexType_GUIDHHHHHHHHHHH keb@keb@MSysComplexType_IEEEDoubleTTTTTTTTTTT keb@keb@MSysComplexType_IEEESingleTTTTTTTTTTT keb@keb@MSysComplexType_LongHHHHHHHHHHH keb@keb@MSysComplexType_ShortJJJJJJJJJJJ keb@keb@MSysComplexType_UnsignedByteXXXXXXXXXXX keb@keb@MSysComplexColumnsDDDDDDDDDDD keb@keb@MSysRelationshipsGDDDDDDDDDDB keb@keb@MSysQueriesG88888888886 keb@keb@MSysACEsG22222222220 keb@keb@MSysObjectsG88888888886 keb@yc@MSysDbF@:::......., @keb@keb@RelationshipsG<<<<<<<<<<: keb@keb@DatabasesG44444444442 keb@keb@TablesG.........., D YN Y Y  Y Y Y ColumnNameComplexID&ComplexTypeObjectID"ConceptualTableIDFlatTableIDYYY(IdxConceptualTableIDIdxFlatTableID IdxIDv1@    fYNY  ValuedvfYNY  ValuedvfYNY  ValuedvfYNY  ValuedvfYN  Y  ValuedvfYN""Y  ValuedvfYN$$Y ValuedvfYN&& Y  ValuedvaYN(( Y Y  Y Y  Y  Y FileDataFileFlagsFileNameFileTimeStampFileTypeFileURL((((Hv1b;O~T* T z \ > T 6  @  T 6  X :  dF( NIC`fH*q1k$tbl_Raw_Data.Date0 gtbl_Raw_Data.[Time Started]: gtbl_Raw_Data.Y_coord3 gtbl_Raw_Data.X_coord3 gtbl_Raw_Data.[Time Detect]9 gtbl_Raw_Data.Species3 gtbl_Raw_Data.Count1 gtbl_Raw_Data.Site_Station8 gtbl_Raw_Data)))  G G  Goctbl_Visitstbl_Observations`@ *QE% octlu_Speciestbl_Observationsj@ *SG' octbl_Locationstbl_Visitsf@*K?+ oc tbl_Observations.Detect_Time; goctlu_Species.Common_Name6 goctbl_Observations.Species_IDF; goctbl_Visits.Count/ goctbl_Visits.Visit_Date4 goctbl_Visits.Visit_Time4 goctbl_Locations.Y_Coord4 goctbl_Locations.X_Coord4 goctbl_Locations.Location_ID8 gLoctbl_Observations111 Loctlu_Species''' Loctbl_Visits%%% Loctbl_Locations+++ oc Goc GLoc oc Gbl_X7YZ_____2@*1% 7bl_X7YZ_____1@*1% 7l_ G l_ Gbl_ l_ G [ItemNumber]+ 'r@* 'Switchboard Items333  G  Gtbl_Observations111   G  GpH@* gpB@* gpqry_Nearest_Location999 p p Gptbl_Locations+++  p Gp p Gp([__Visit_ID] = Visit_IDF)9 'ptbl_Observationsfsub_VisitsGG1  p Gp__Visit_ID%%% Op p G9tlu_Species'''  9 G9 9 G"([__Location_ID] = Location_IDF)? 'frm_Locations@*7+ 7  G__Location_ID+++ O  GH@* gB@* gqry_Nearest_Location999   GLVALvl$ * RFXBVtbl_Raw_Data.Count=tbl_Visits.Counttbl_Raw_Data.Site_Station=tbl_Visits.Location_IDFIIf([How Detect]="C" Or [How Detect]="S" Or [How Detect]="D","A","V")(((IIf([X_Coord]>475000,Yes,No))=Yes))StDev(tbl_Locations.Forest_Percent)Max(tbl_Locations.Forest_Percent)Min(tbl_Locations.Forest_Percent)Avg(tbl_Locations.Forest_Percent)[qry_forest_stats].[avgofforest_Percent]-[qry_forest_stats_east].[avgofforest_percent]StDev(tbl_Locations.Forest_Percent)Max(tbl_Locations.Forest_Percent)Min(tbl_Locations.Forest_Percent)Avg(tbl_Locations.Forest_Percent)(((tbl_Observations.Species_IDF)="CORA")) OR (((tbl_Observations.Species_IDF)="AMCR") AND ((tbl_Visits.Count)=2)) OR (((tbl_Observations.Species_IDF)="RWBL") AND ((tbl_Visits.Count)=1))tbl_Visits.Visit_ID=tbl_Observations.Visit_IDFtbl_Locations.Location_ID=tbl_Visits.Location_IDF(((tbl_Raw_Data.[How Detect])<>"F"))tbl_Visits.Visit_ID = tbl_Observations.Visit_IDFtlu_Species.Species_ID = tbl_Observations.Species_IDFtbl_Locations.Location_ID = tbl_Visits.Location_IDFSELECT tbl_Raw_Data_2.Site_Station AS Location_ID, tbl_Raw_Data_2.Date AS Visit_Date, tbl_Raw_Data_2.[Time Started] AS Visit_Time, tbl_Raw_Data_2.Wind, tbl_Raw_Data_2.Sky, tbl_Raw_Data_2.Species AS [Species IDF], tbl_Raw_Data_2.Observer FROM tbl_Raw_Data_2SELECT tbl_Locations.Location_ID, tbl_Visits.Visit_Date, tbl_Visits.Visit_Time, tbl_Visits.Wind, tbl_Visits.Sky, tbl_Observations.Species_IDF, "Wilson" AS Observer FROM (tbl_Locations INNER JOIN tbl_Visits ON tbl_Locations.Location_ID = tbl_Visits.Location_IDF) INNER JOIN tbl_Observations ON tbl_Visits.Visit_ID = tbl_Observations.Visit_IDF; [ItemNumber]>0 And [SwitchboardID]=TempVars!SwitchboardID[qry_Nearest_Location].[Location_ID][qry_Nearest_Location].[Distance]SELECT tbl_Visits.* FROM tbl_Visits WHERE (((tbl_Visits.Count)=[forms]![frm_Locations]![grp_Visit]))[qry_Nearest_Location].[Location_ID][qry_Nearest_Location].[Distance]&aNF r  ! K p lIXNJG:EiuqB >xCÝc@{9!.b@mĝc@tbl_VisitsFjBBB66666664 @,2c@4c@tbl_Raw_Data_2FR @JJJ>>>>>>>< @1b@K_b@tbl_Raw_DataFjFFF:::::::8 @yxb@mĝc@tbl_ObservationsF @NNNBBBBBBB@ @t%b@faĝc@tbl_LocationsF]jHHH<<<<<<<: @ .uc b@7)[c@0qry_Update_CountF@|@ZNNBBBBBBB@ @- fc@U(hc@qry_Species_by_SiteF@@`TTHHHHHHHF @,XPc@ic@qry_Species_by_Location_and_ForestFc@@~rrfffffffd @+K̖c@*<c@qry_Parameter_Query_ExampleF@@pddXXXXXXXV @*[~c@%c@qry_Orphaned_ObservationsF@@l``TTTTTTTR @ (C(c@$܌ c@qry_Number_of_Detections_by_SpeciesF@@tthhhhhhhf @'8cc@Wc@qry_Nearest_LocationF@|@bVVJJJJJJJH @& M}c@Wхc@qry_Locations_and_VisitsF@@j^^RRRRRRRP @%7".~c@G0~c@qry_Individuals_Per_VisitF@@l``TTTTTTTR @ #V[c@8[c@@qry_Import_Visits_Data_2F@|@j^^RRRRRRRP @"gb@=e[c@@qry_Import_Visits_DataF7@|@fZZNNNNNNNL @!Awb@[c@@qry_Import_Species_DataF)@|@h\\PPPPPPPN @ K_b@,[c@@qry_Import_Observations_DataF @@rffZZZZZZZX @ 5›c@Tśc@qry_Forest_Stats_EastF@|@dXXLLLLLLLJ @S tߛc@0c@qry_Forest_Stats_Average_DifferenceF@@tthhhhhhhf @Uc@Sc@qry_Forest_StatsF@|@ZNNBBBBBBB@ @=c@{ c@qry_Complex_Criteria_ExampleFu@@rffZZZZZZZX @~b@:zN~c@qry_Compare_Data_ImportedFj@l``TTTTTTTR @HEb5c@_8c@qry_Combined_DataF@@\PPDDDDDDDB @eBeb@Beb@ MSysNavPaneObjectIDsFJJJJJJJJJJH _Lkeb@Lkeb@ MSysNavPaneGroupToObjectsFTTTTTTTTTTR ZLkeb@Lkeb@ MSysNavPaneGroupsFDDDDDDDDDDB Vrkeb@rkeb@ MSysNavPaneGroupCategoriesFVVVVVVVVVVT S1b@1b@MSysIMEXSpecsF<<<<<<<<<<: O1b@1b@MSysIMEXColumnsF@@@@@@@@@@> ,keb@keb@ MSysAccessStorageFDDDDDDDDDDB  03c@@03c@~sq_fSwitchboardF4MR2KeepLocal TBBBBBBB@ @V Y<N--<<<<<<Y Y Y   Y  , Y ,Y Y  DateCreateDateUpdateIdLvNameParentIdType, , -G ,, , -H ,, , -I ,YYYIdParentIdIdParentIdName--v1b @_ @ ,4@c$ o q ( =  A W `Si6aOp=hah03c@h03c@wBlobDeltat0,( wgb03c@03c@vH@=TypeInfot:62" gb03c@03c@u/0AjBlobt2.*" gb03c@03c@t4  w~xc@xc@W% 0CB1 1CB1 2CB0PropDataCopygc_G 6c@Bc@D PropData@GC?/ F6c@Bc@CBlobDelta@0,( wF6c@Bc@B@5TypeInfo@:62" F6c@Bc@A#>jBlob@2.*" @6c@Bc@@3  wA6ʟc@U2&c@7 @=Blob62.*"  0ʟc@U2&c@62  wVDc@n4ac@ 2CB0 0CB0PropDataTPL< VDc@VcDc@Macro1DirDataCopyXTP8 Wc@P|,Nc@P@5DirData:62" 78|c@qc@ PropDataGC?/ >8|c@qc@BlobDelta0,( w>8|c@qc@@5TypeInfo:62" >8|c@qc@(:jBlob2.*" >8|c@qc@2  w>}gzc@ oc@h PropDatadGC?/ >}gzc@A oc@gBlobDeltad0,( w>}gzc@A oc@fh@5TypeInfod:62" >}gzc@ oc@e46jBlobd2.*" >}gzc@ oc@d1  wGzc@Gzc@c@frm_Locationsfsub_VisitsDirDataCopy~zb Gzc@Gzc@b 0CB0 1CB0PropDataCopy\XT< #]c@˅Bc@T; 3CB0 0CB0 1CB0 2CB0 4CB0PropDatauqm] 7(]c@ޅBc@P PropDataKGC?/ 7(]c@03c@O@5DirData:62" 7(]c@%҅Bc@NBlobDeltaK0,( w7(]c@%҅Bc@M@5TypeInfoK:62" 7(]c@˅Bc@LS/jBlobK2.*" 7(]c@ޅBc@K0  w fb@οIc@VBA$  w fb@οIc@VBAProject2.* wLkeb@Lkeb@MSysDbDirData PLH8 rkeb@rkeb@ImExSpecs0,( wrkeb@rkeb@CustomGroups62. wrkeb@rkeb@ Blob &" wrkeb@rkeb@ 0   wrkeb@Lkeb@ Databases0,( wrkeb@rkeb@ DataAccessPages<84 wrkeb@rkeb@ Cmdbars,($ wrkeb@Ic@VBA$  wrkeb@n4ac@Scripts,($ wrkeb@rkeb@Modules,($ wrkeb@rkeb@Reports,($ wrkeb@˅Bc@Forms($  wrkeb@ fb@ijPropDataPLH8 rkeb@rkeb@MSysAccessStorage_SCRATCHPLH wrkeb@ fb@MSysAccessStorage_ROOTJFB wLVALj0:u07=5B>a)b*c1e g+l7(]c@x [l8BWL+%C쌆Grassland_Percent_(-ˀNTQa+%C쌆Developed_Percentc#tOp=@ +%C쌆X_Coord$miSKO6:wj +%C쌆Y_Coord71.NA~~f[l8B> NY<{3T"bc@fsub_Nearest_Location  tbl_LocationsU <mac_frm_Locations.Last_Updated @Calibri 8hhhh h ,卵 o,Lexmark 3500-4500 Series (NONE)P*3e@`H^/7w`H`HLO"Arial)  2(NONE)P*3e@`H^/7w`H`HLO"Arial)  2珞Lexmark 3500-4500 Series8珞, ` : KPcpSoftware\LexmarkInkjetXX,XXXX,XXXXX珞 U!:3500-4500_Series_1A3005_P1LVAL11D/1<FP d2d# " @Calibri    g23I6Y75    i1g4h5    k1    mfg4i# " @Calibri     p    `,d$ FormHeaderx IPBgd5U7`6:a<bw/c,(d#ghjk! Auto_Title0 &Bird Count Database" @Segoe UIx 4T{2H0퉑&X  J:K<L/Md`,  Detailx B!@^IPț p3`6@ a b c,d  *fsub_Nearest_Location 4Form.fsub_Nearest_Locationx tGַF?GVNzJ@ K L`'M d5]`6@ a0 bc,; 6fsub_Nearest_Location Label *fsub_Nearest_Location 6fsub_Nearest_Location_Labelx {&'fKgOJ@ K0 LMk m7U;F{`6< a<bc,mnpq Location_ID Location_ID Primary Keyx LVAL2!IJ/Z{' +.J< /K<0L, 1Md5U7`6ha<bc,ghjk!  Label1 Site ID:x vpIٚ JhK<L Mm0G7U;F{`6< abc,hkmnpq Forest_Percent Forest_Percent&  Fixed *% forest within 300 mx 71.NA~~f +.J< /K0L, 1Md5U7`6habc,hghjk!  Label3 Percent Forest:x @q2E\K#e JhKL Mm0G7U;F{`6< aDbc,hkmnpq "Grassland_Percent "Grassland_Percent&  Fixed 0% grassland within 300 mx anV6M=) +.J< /KD0L, 1Md5U7`6haDbc,hghjk!  Label5 $Percent Grassland:x ک:H2}0{ JhKDL Mm0G7U;F{`6< abc,hkmnpq "Developed_Percent "Developed_Percent&  Fixed 0% developed within 300 mx ^4O_ +.J< /K0L, 1M_ d5U7`6habc,hghjk!  Label7 $Percent Developed:x 8+S±AIi@4 JhKL M_ m7U;F{`6< aLVAL3+bc,hkmnpq X_Coord X_Coord >East coordinate, VT state plane 8mac_frm_Locations.Dist_Checkx >qO% +.J< /K+0L, 1Md5U7`6ha+bc,hghjk!  Label9 X Coordinate:x A=y{|1N2x JhK+L Mm7U;F{`6< abc,hkmnpq Y_Coord Y_Coord @North coordinate, VT state plane 8mac_frm_Locations.Dist_Checkx |)B  +.J< /K0L, 1MFd5U7`6habc,hghjk! Label11 Y Coordinate:x  ٕf@1!qM JhKL MFm80G7;F{`6< a bc,kmnpq Hab_Total r=[forest_percent]+[grassland_percent]+[developed_percent]&  Fixed Primary Keyx 0p$EO +.J< /K 0L, 1MN d5U7`6ha bc,ghjk! lbl_Hab_Total Total Percent:x t2ɒ@kK9Y JhK L MN p3`6ahbc,d fsub_Visits  Form.fsub_Visits1 Location_IDF2 Location_ID Bmac_frm_Locations.Loc_Orphan_Warnx KJi-SJKhL%Md5]7`6a<bc,wghjkLVAL4! "fsub_Visits Label  Visits "fsub_Visits_Labelx ?pANl1LJK<LXMk5U`6(a\ bc,i grp_Visit 1x %A(CDs33JbUpdate data displayed on fsub_Visitsfsub_Visits!J("K\ #L $MUd25`6a bc,; Label28  Visitx i x FNjRvJK LMi2W`6aJ: Option30x tw"Et/%J&KJ'L(M:d5`6a.bc,; Label31 Visit 1x XHI`@JK.LM Mii2W`6a: Option32x N ILɑ%J&K'L(Md5`6axbc,; Label33 Visit 2x 6otYJuxJKxLM Mi2W`6a: Option34x 2ݭi;G#  %J&K'L(Md5`6abc,; Label35 Visit 3x v2_iK+ !JKLM Mm7F{`6ac,;k  Last_User Last_User BLast person to modify this recordx W:V@)Q+.J/K0LL1Md5]`6ab c,; Label40 0Person Modifying Record:x  ɗ08HigJeMJKL@ Mm7UF{`6a(c,;k  Last_Date Last_Date& Short Date BDate the record was last modifiedx ϙE2c4+.J/K(0LL1Mcd5U`6a(bc,; La LVAL bel41 Date Modified:x [OSEpzzJK(LbMcm7UF{`6ac,;k  Last_Time Last_Time& Short Time BTime the record was last modifiedx fbuG`r~+.J/K0LL1Md5U`6abc,; Label42 Time Modified:x emwjC9LŇJKLM`, FormFooterx _UB%N9;LVAL 6 ͬowK)xOؙ/FormHeader/Detailm/Distanced /Distance_Labelm/Location_IDd /Location_ID_Label/FormFooter&mac_frm_Locations"mac_Switchboardͬ ([٘C]HDB/Detailm/Observation_IDd /Label1m/Visit_IDFd /Label3m/Detect_Timed /Label7o/Species_IDFd /Label5o/ Detect_Typed / Label9ͬa;$EBA:}/FormHeaderd /Label5d /Label7d /Label9d /Label11d /Label13/Detailm/Visit_Timem/Visit_Datem/ Windm/ Skym/ Countp/ Observationsd / Observations_LabelObservations Label/FormFooter/Visit_ID/Location_IDF.fsub_Nearest_Locationfrm_Locationsfsub_Visits&fsub_ObservationsSwitchboardͬ$&%D=1!-q"/Detail/FormHeader/FormFooterd /Auto_Title0m/Location_IDd /Label1m/Forest_Percentd /Label3m/ Grassland_Percentd / Label5m/ Developed_Percentd / Label7m/ X_Coordd /Label9m/Y_Coordd /Label11m/Hab_Totald /lbl_Hab_Totalp/fsub_Visitsd /fsub_Visits_Labelfsub_Visits Labeld /Label28i/Option30d /Label31i/Option32d /Label33i/Option34d /Label35k/grp_Visitp/fsub_Nearest_Locationd /fsub_Nearest_Location_Labelfsub_Nearest_Location Labelm/Last_Userd / Label40m/!Last_Dated /"Label41m/#Last_Timed /$Label42LVALj7 ^ _ a/:u027?8B>a)b*cLe g =forms!l)c@x ř۸hK~IWy  Uh&D,JVwX&~c@LJ!tbl_Visits.e<0WE\-h&D,JVwX&Count[l8BCount number (visit 1, 2, or 3) H=[Forms]![frm_Locations]![grp_Visit]x {xbIBǺ.Gv  '+.J4/K%0L1M2p3`6a LVAL bc, d Observations ,Form.fsub_Observations1 Visit_IDF2 Visit_ID Bmac_frm_Locations.Vis_Orphan_Warnx QFg1ZA6JKLMd5]7`6abc,wghjk! $Observations Label Observations $Observations_Labelx W#JF.`  JKL5M`, FormFooterx Շ֠@ N7>LVALj;:u07=5B>a)b*c3.e g l>8|c@x w|D y  USR4B"ND:~c@@ !tbl_ObservationsW.N2}VSR4B"ND:Observation_IDX0;%OlgHSR4B"ND:Visit_IDF!EIS18 SR4B"ND:Detect_Time9DN # SR4B"ND:Species_IDFT;K3!LaG|xc@tlu_Species"hB"MSR4B"ND:Detect_Type   tbl_Observations @Calibri 8hhhh h ,卵 o,Lexmark 3500-4500 Series (NONE)P*3e@`H^/7w`H`HLO"Arial)  2(NONE)P*3e@`H^/7w`H`HLO"Arial)  2珞Lexmark 3500-4500 Series8珞, ` : KPcpSoftware\LexmarkInkjetXX,XXXX,XXXXX珞 U!:3500-4500_Series_1A3005_P11D/1<FPd2d# " @Calibri    mfg4i# " @Calibri     LVAL<oj4l# " @Calibri     *,-8`,   Detailx ,4ծ@9/m87U;F{`6ahb@&c,ge mnpq Observation_ID Observation_ID Primary Keyx M񳫄AϾ`E+.J/Kh0L-1Md5U7`6hahbc,gghjk!  Label1 IDx LCJO*&p~o JhKhLpMm7U;F{`6ab@&c,gkmnpq Visit_IDF Visit_IDF ,Foreign key, tbl_Visitx  =?Gsν噙+.J/K0L-1Md5U7`6habc,gghjk!  Label3 Visit IDx O0w,LL bGJhKLpMm7U;F{`6a~b@&c,ge)kmnpq Detect_Time Detect_Time nTime detected during count; 11 = incidental observationx Ώ떺A"6+.J/K~0L-1Md5U7`6ha~bc,gghjk!  Label7 Timex 2K3HxdXJhK~LpMoC5U9D{`Fbc6de@&f,gh)nZ X"Species Code";">";"Common Name";"";"10";"8"x LVALq?>"OV_* Species_IDF Species_IDF] Table/Query[ tlu_Species 864;2880 ^Foreign key, tbl_Species; bird species detected./0126J7K8L-9M3d5U7`6habc,gghjk!  Label5 Speciesx )bZKѭ"JhKLpM3oC0\5U9D{`Fbc6d0e@&f,gh)nx 96$KcX0 Detect_Type Detect_Type] Value List[ &A;Auditory;V;Visual  0;1008 ,(V)isual or (A)uditory& >./0126J7K08L-9M d5U7`6ha0bc,gghjk!  Label9 Typex E&bHZVvJhK0LpM LVAL  33$RVnrClose_SwitchboardClose switchboard form2Switchboard0&FRVToggle_PaneToggle Navigation Pane{F11}0ͬ`wgKNG/z/Detail/FormHeader/FormFootere/VerticalShadowBoxg/Pictureh /Option1m/OptionLabel1e/HorizontalHeaderBoxd /Label2d / Label1/ SwitchboardID/ ItemNumber/ ItemText/ Command/Argument33 v4:>\Loc_Orphan_WarnPrint error message if Location_ID is null[Location_ID] Is NullYou must enter data about the location before entering visit information-14Orphan Warning ^fGo to a control on frm_Locations to enter data...[Location_ID] p"@Vis_Orphan_WarnPrint error message if Visit_ID is null[Visit_ID] Is NullYou must enter data about the visit before entering observations-14Orphan Warning Zb|Go to a control on fsub_Visits to enter data...[Visit_Time]R~Dist_CheckRequery fsub_Nearest_Locationfsub_Nearest_LocationpvzDisplay warning if location is within 400 meters of an existing location[fsub_Nearest_Location]![Distance]<400="Location " & [fsub_Nearest_Location]![Location_ID] & " is only " & FormatNumber([fsub_nearest_location]![distance],0) & " meters from this location. Locations should be at least 400 meters apart."-13Distance Warning Go to Location_ID because can't go to X_Coord if just leaving that control...Location_ID ,4DGo to X_Coord control...X_Coord( zLast_UpdatedStore most recent user to make change to record[Last_User]CurrentUser()( BZhStore Date of most recent change[Last_Date]Date()(BZhStore Time of most recent change[Last_Time]Time()LVALj?:u07=5B>a)b*ce gl6c@x >> NY<{3y t U?A@^Wc@vA!qry_Nearest_LocationEX4.?A@^Distance.BPdC\jB?A@^Location_IDDistanceLocation_ID  SELECT [qry_Nearest_Location].[Distance], [qry_Nearest_Location].[Location_ID] FROM qry_Nearest_Location;  *fsub_Nearest_Location @Calibri1D/1<FPd26d# '\" @Calibri    e2'    f'    g26Y75'    h4g# h%'" @Calibri    ig4h5'    jg4h5    k2'    l0Y:g4'    mf:LVAL@g4i# '" @Calibri     n6h4j# '" @Calibri     $,'8o8j4l# '" @Calibri     *,-8p'    r45I'    w4I'    z4i# j%'" @Calibri    {2d# " @Calibri    ~278bc,'    .4`,' FormHeaderx Ӛݫg!B/}ESG`,  Detailx TNEִ ;m7U;F{`6@ ahbLc,Je  Distance Distancex S)hA<@+.J@ /Kh0L1Md5U7`6hahb c,J Distance_Label Distancex Cu P[L[woJ LVAL hKhL Mm7U;F{`6@ abLc,Jek Location_ID Location_ID Primary Keyx X FMV+.J@ /K0L1MGd5U7`6hab c,J "Location_ID_Label Site IDx hyaDW M7JhKL MG`, FormFooterx T^]G-LVALjB$:FSu27=5B>a)b*c<e gjw.k ;x  ؒA"&Gy  U~kN, n03c@]HD!Switchboard ItemsCm]D*O}%7~kN, ItemNumber ϮA>_g~kN, SwitchboardID=[Argument]=[Argument]=[Argument]ItemText  SELECT * FROM [Switchboard Items] WHERE [ItemNumber]>0 And [SwitchboardID]=TempVars!SwitchboardID ORDER BY [ItemNumber];  Switchboard @Calibri1N7 33L$>CurrentItemNumber[ItemNumber]Y33LSwitchboardIDDLookUp("SwitchboardID","Switchboard Items","[ItemNumber] = 0 AND [Argument] = 'Default'")FLabel19=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))FLabel29=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))D/1<FPd2d# " @Calibri    e12    g23I6Y75    hg# h%" @Calibri    mfg4i# " @Calibri     `LVALC, FormHeaderx Mȋn QH]{{e125Ubc, &HorizontalHeaderBoxx ,Q:AH'8LMd5`6 ab:c,d#  Label2 <Bird_Counts_5_forms_and_macros" @Segoe UIx mDi8J KLMd5`6 ab:c,d#  Label1 <Bird_Counts_5_forms_and_macros" @Segoe UIx mOymLųtܫJ KLMl`,  Detailx ^);[qK 5e123I5U`63 bzc, "VerticalShadowBoxx mKU)J3 L Mh1U`6 aPbc,g#  Option1" @ Systemx eBțp^x 33I1ErrorHandlerL4J[Command]=1SwitchboardID[Argument]F...Label19=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))F...Label29=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))...-... 048<[Command]=2=[Argument]000- ... 04:>[Command]=3=[Argument]0-10- ....048[Command]=4=[Argument]50-...: [Command]=5521L$...SwitchboardIDDLookUp("SwitchboardID","Switchboard Items","[ItemNumber] = 0 AND [Argument] = 'Default'")F...Label19=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))F...Label29=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))...-...C[Command]=6-LVALD..."0[Command]=7=[Argument]-...!>[Command]=8=[Argument] & "()"- ..." &*Unknown option.-10$RX\ErrorHandler=[MacroError].[Description]-10!%J &KP'L (MSm85I7UCF{`6> aPbi#k OptionLabel1 ItemText" @ Tahomax "0QIV5m(x 33I1ErrorHandlerL4J[Command]=1SwitchboardID[Argument]F...Label19=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))F...Label29=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))...-... 048<[Command]=2=[Argument]000- ... 04:>[Command]=3=[Argument]0-10- ....048[Command]=4=[Argument]50-...: [Command]=5521L$...SwitchboardIDDLookUp("SwitchboardID","Switchboard Items","[ItemNumber] = 0 AND [Argument] = 'Default'")F...Label19=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))F...Label29=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))...-...C[Command]=6-..."0[Command]=7=[Argument]-...!>[Command]=8=[Argument] & "()"- ..." &*Unknown option.-10$RX\ErrorHandler=[MacroError].[Description]-10+.J> /KP0L1M@g26Yb} c, Picturex ~_ jiiOԹo>L} M!uLVAL`,h FormFooterx 8HwHGp+ݾ{ ,s.x5 Ic@οIc@(@FPROJECT840" Ic@οIc@PROJECTwm>:6$ *Ic@οIc@@Fdir0,(" *Ic@οIc@@F_VBA_PROJECTB>:" Ic@Ic@ AcessVBADataNJF. v,Nc@n4ac@8@=Blob2.*" o,Nc@n4ac@0  w03c@03c@x PropDatatGC?/ hLVALK|ID="{CD2F7345-C10B-4A41-BBEC-632CD2FB81D4}" Name="Bird_Counts" HelpContextID="0" VersionCompatible32="393222000" CMG="8E8C891D99252329232923292329" DPB="1C1E1BAB273828382838" GC="AAA8AD213A223A22C5" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 0* pHd Bird_Counts8@ = t  HLJ( J< rstdole>stdole h%^*\G{00020430-;C 0046}#2.0#0#C:\Windows\sys@tem32\e2.tlb#OLE Automation0!DAO>JDAOA A4AC9E1DA-5BAD-7-86E3-24F4CDCEC@A28}#cAPROGRA~1\@COMMONM ICROSOFFICE12\ACE9.DLL#Microsoft Office 1f Access database engine Object LibraryO am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office12\MSACC.OLB#Microsoft Access 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\system32\stdole2.tlb#OLE Automation:*\G{4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28}#c.0#0#C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEDAO.DLL#Microsoft Office 12.0 Access database engine Object Library HLJx $AccessVBAWin16~Win32MacVBA6# Bird_CountsAstdole`DAO<    , @ @ @ @ @ @ @........ . .  .  .  . . ....K.L.M.N.O.P.T.b.c.d.e.f.g.h.. .!.".#.$.%.&.'6.(7.)@.*A.+B.,C.-D..W./t.0u.1v.2w.3xEEEEEEEE ,@@@@@@@@@@@@@@@....... . .  . . ..K.O.T.b.c.d.. @.*t.0.%.&.'6.(W./E.E  .  .  . .EEEEKL.KM.KN.KP.de.df.dg.dh..!.".#.$67.)@A.+@B.,@C.-@D..tu.1tv.2tw.3txEEq ,@@@  @@@ @@  @M`OLJik.Mokmd`Uidofk. OJmJJMMQkkfJUQk. OJmJLJkQk. Sdi`k.Y`QukfQMk.`dOo^Qk.`kvkJMMQkkkmdiJUQ+iddm.fidfOJmJ.iQfdimk.kMiYfmk.qLJ.`kvkJMMQkkkmdiJUQ+kMiJmMW.6.8.:. <.*>.0OYiOJmJ.OYiOJmJMdfv.fidfOJmJ.fidfOJmJMdfv.6E:.(OYiOJmJ.%OYiOJmJMdfv.&fidfOJmJ.'fidfOJmJMdfv./JMQkkqLJOJmJEqLJfid[QMm. 6.  OYiOJmJ. L^dL. fid[QMmEfid[QMms`EqLJ.+qLJ+fid[QMmEOYiEKL^dL.KL^dLOQ^mJ.KfidfOJmJ.KmvfQYbSd.dL^dL.dL^dLOQ^mJ.dfidfOJmJ.dmvfQYbSd.L^dL.!L^dLOQ^mJ.#fidfOJmJ.$mvfQYbSd."6L^dL.)@L^dL.+@L^dLOQ^mJ.-@fidfOJmJ..@mvfQYbSd.,tL^dL.1tL^dLOQ^mJ.3tfidfOJmJEtmvfQYbSd.2L^dLES YNKKY  Y Y   Y  , Y ,6 Y 6Id LValueObjectGuidObjectNameProperty Value, 6, 6,KL6 , 6, 6,KM6 , 6, 6,KN6 ,YYYId$ObjectGuidProperty$ObjectNamePropertyKHv1b@  J J J qYNPPY  Y  Y Y Y Y .Y Y AttributesDataTypeFieldNameIndexTypeSkipColumn SpecID Start Width ., .,PQ. , ., .,PR. ,YY Index1PrimaryKeyv1 O O YN  TT Y Y Y Y  Y  Y Y Y  Y Y  Y   Y   Y  eDateDelim"DateFourDigitYear DateLeadingZerosDateOrderDecimalPointFieldSeparatorFileType SpecIDSpecNameSpecTypeStartRowTextDelimTimeDelimTUjeYPrimaryKeyv1  S>YNWW Y Y rY  Y  Y ,Y Y   Filter FlagsIdNamePosition SelectedObjectIDType , , WY, YIdv1iV}Custom ^ v- vVXXX RYN[[Y Y Y  Y Y ,Y Y   FlagsGroupCategoryIDIdName"Object Type GroupObjectIDPosition , , [],  , , [^, YYGroupCategoryIDIdv1@  ZyLO" n A  p  w  w w wy w wt w  w  w Custom Group 162.*  w w w w w w w w~ Z @ @\\ \ \ \ \\\\\\\\\\\\\ ~ Z @ @\\\\\\\\ \ \  \ \ \ \ \\\\ YYaN``Y YYY Y Y Y  Y ,Y Y   FlagsGroupIDIconIdNameObjectIDPosition, , `c ,, , `d ,YYGroupIDIdv1(_VyLk> ] 0  | O " n A  ` 3   R % qDc6 U(tGf9 X+wJi<^  o]  o\  o[' oZ' oY  oV oU oT/ oS/ oR, oQ, oP, oO, oN+ oM+ oL+ oK+ oG oF oE oD oC( oB( oA( o@ o? o> o= o< o;) o:) o9- o8- o7- o6- o5 o4  o3  o2*  o1 o0& o/% o.$ o-$ o,% o+% o*% o)* o(* o'& o&& o% o$  o"  o! o #  o# o.  o  o"  o! o o  o o o o  o o o  o  o. o" o o ! o  o  o y o  ot oy o ot o o  oe_ya o`  o_p o _ @ @ @ @ @ @ @ @ @ @ @aaaaa a1aNbaaaaaaaaa*a+a,a.a5a7a9a;a<a?aCaGaKaMaOaRa-a/a0aTbaPb a aaaaa"a&a)a2a6a8a:a@aDaHaLaQaSaaaaa#a$a'a3aAaEaIaaa a%a(a4a>aBaFaJaa a a a aaaa!a=aU _ @ @ @ @ @ @ @ @ @ @ @aaaaaa a a a a  a a a a aaaaaaaaaaaaaaa a!a"a$a %a!&a"'a#(a$)a%*a&+a',a(-a).a*/a+0a,1a-2a.3a/4a05a16a27a38a49a5:a6;a7<a8=a9>a:?a;@a<Aa=Ba>Ca?Da@EaAFaBGaCKaDLaEMaFNaGOaHPaIQaJRaKSaLTaMUaNVaOYaPZaQ[aR\aS]aT^aU_b`babRYMNffY  Y Y IdNameTypedveDh=}0 k " e  a @  | E  f / Uc]|/fP_Kytbl_Observations*&ttbl_Locations$ pSwitchboard Items,(.qry_Update_Count*&-qry_Species_by_Site0,,qry_Species_by_Location_and_ForestNJ+qry_Parameter_Query_Example@<*qry_Orphaned_Observations<8)qry_Number_of_Species_by_SiteD@(qry_Number_of_Detections_by_SpeciesPL'qry_Nearest_Location2.&qry_Locations_and_Visits:6%qry_Individuals_Per_Visit<8$qry_Individuals_Per_Site_MaxB>#qry_Import_Visits_Data_2:6"qry_Import_Visits_Data62!qry_Import_Species_Data84 qry_Import_Observations_DataB>qry_Import_Locations_Data<8qry_Forest_Stats_East40qry_Forest_Stats_Average_DifferencePLqry_Forest_Stats*&qry_Complex_Criteria_ExampleB>qry_Compare_Data_Raw2.qry_Compare_Data_Imported<8qry_Combined_Data,(eMSysNavPaneObjectIDs2._MSysNavPaneGroupToObjects<8ZMSysNavPaneGroups,(VMSysNavPaneGroupCategories>:SMSysIMEXSpecs$ OMSysIMEXColumns($JMSysAccessXML$ ,MSysAccessStorage,(Admin mac_Switchboard($ mac_frm_Locations,( Switchboard  fsub_Visits  fsub_Observations,( fsub_Nearest_Location40frm_Locations$ UserDefined SummaryInfo SysRelScriptsReportsModulesFormsDataAccessPages($'MSysComplexType_Attachment>:%MSysComplexType_Text2.#MSysComplexType_Decimal84!MSysComplexType_GUID2.MSysComplexType_IEEEDouble>:MSysComplexType_IEEESingle>:MSysComplexType_Long2.MSysComplexType_Short40MSysComplexType_UnsignedByteB>MSysComplexColumns.*MSysRelationships,(MSysQueries MSysACEsMSysObjects MSysDbRelationships$ DatabasesTables e yBq. 6tbl_Visitstbl_Observations>:5tbl_Locationstbl_Visits841tbl_Speciestbl_Observations@</xtab_Species_by_Location_and_ForestPLtlu_Species tlu_Bird_Codes_VT,(tbl_Visitstbl_Raw_Data_2&"tbl_Raw_Data"0BrTg -  S  c  Y  y [ # 3GU^;v7w9{ HowDetectDetect_Type@*E9#  TimeDetectDetect_Time[time detect]/100Z;%  Species_IDFtbl_Raw_Data.SpeciesI' w tbl_Visits%%%  tbl_Raw_Data)))  tbl_Observations111 O    G tbl_Raw_Data.Developed5 g tbl_Raw_Data.Grassland5 g tbl_Raw_Data.Forest2 g tbl_Raw_Data.Y_coord3 g tbl_Raw_Data.X_coord3 g tbl_Raw_Data.Site_Station8 gDeveloped_Percenttbl_Raw_Data.DevelopedW3 wGrassland_Percenttbl_Raw_Data.GrasslandW3 wForest_Percenttbl_Raw_Data.ForestN- wY_coordtbl_Raw_Data.Y_coordA wX_coordtbl_Raw_Data.X_coordA wLocation_IDtbl_Raw_Data.Site_StationN' wtbl_Raw_Data)))  Gtbl_Locations+++ O  G nL@* ' nIIf([X_Coord]>475000,Yes,No); gnStDevOfForest_PercentF@*G;; onMaxOfForest_PercentB@*C77 onMinOfForest_PercentB@*C77 onAvgOfForest_PercentB@*C77 onEastIIf([X_Coord]>475000,Yes,No)C ontbl_Locations+++ n Gn Gn n GDifference@*1%% oqry_Forest_Stats_East;;; qry_Forest_Stats111  G G  GStDevOfForest_PercentF@*G;; oMaxOfForest_PercentB@*C77 oMinOfForest_PercentB@*C77 oAvgOfForest_PercentB@*C77 otbl_Locations+++  G G  Gr@* 'tbl_Visitstbl_Observations\@ *QE% tbl_Locationstbl_Visitsb@ *K?+ tbl_Visits.Count/ gtbl_Observations.Species_IDF; gtbl_Locations.Location_ID8 gtbl_Observations111 tbl_Visits%%% tbl_Locations+++   GH@ * ' tbl_Raw_Data.[Common Name]9 g'BYiK e % q S  [ j ( ]  a/~6ECeG) 3 Y'P%tbl_Locationstbl_Visitsf@kK?+ %tbl_Visits.Visit_ID2 g%CountOfObservation_IDL@kG;; o%tbl_Locations.Location_ID8 g%tbl_Observations111 %tbl_Visits%%% %tbl_Locations+++ % G% G% % G$ J@k g$MaxOfCountOfObservation_IDh@kQEE o$J@k g$qry_Individuals_Per_VisitCCC $ G$ G$ $ G# tbl_Raw_Data.Sky/ g# tbl_Raw_Data.Wind0 g# tbl_Raw_Data.[Time Started]: g# tbl_Raw_Data.Date0 g# tbl_Raw_Data.Count1 g# tbl_Raw_Data.Site_Station8 g#Skytbl_Raw_Data.Sky5 w#Windtbl_Raw_Data.Wind8 w#Visit_Timetbl_Raw_Data.[Time Started]N% w#Visit_Datetbl_Raw_Data.DateD% w#Counttbl_Raw_Data.Count; w#Location_IDFtbl_Raw_Data.Site_StationP) w#tbl_Raw_Data))) # G#tbl_Visits%%% O# # G" tbl_Raw_Data.Sky/ g" tbl_Raw_Data.Wind0 g" tbl_Raw_Data.[Time Started]: g" tbl_Raw_Data.Date0 g" IIf([count]="Tape",3,[count])< g" tbl_Raw_Data.Site_Station8 g"Skytbl_Raw_Data.Sky5 w"Windtbl_Raw_Data.Wind8 w"Visit_Timetbl_Raw_Data.[Time Started]N% w"Visit_Datetbl_Raw_Data.DateD% w"Count_NewCountIIf([count]="Tape",3,[count])X-# "Location_IDFtbl_Raw_Data.Site_StationP) w"tbl_Raw_Data))) " G"tbl_Visits%%% O" " G! tbl_Raw_Data.[Common Name]9 g! tbl_Raw_Data.Species3 g!Common_Nametbl_Raw_Data.[Common Name]O' w!Species_IDtbl_Raw_Data.SpeciesG% w!tbl_Raw_Data))) ! G!tlu_Species''' O! ! G H@k ' tbl_Raw_Datatbl_VisitsF@*I=)  tbl_Raw_Datatbl_Visitsb@*I=)  Visit_IDFtbl_Visits.Visit_IDD# wdLVALnp  D | ( v * & <~Z8pqry_Species_by_Location_and_Forest.[Species_IDF]qry_Species_by_Location_and_Forest.[Location_ID]qry_Species_by_Location_and_Forest.[Forest_Percent]Count(qry_Species_by_Location_and_Forest.[Count])Count(qry_Species_by_Location_and_Forest.[Count])qry_Species_by_Location_and_Forest.[Species_IDF]qry_Species_by_Location_and_Forest.[Location_ID]qry_Species_by_Location_and_Forest.[Forest_Percent]tbl_Visits.Visit_ID=tbl_Observations.Visit_IDFtbl_Locations.Location_ID=tbl_Visits.Location_IDFtbl_Visits.Visit_ID=tbl_Observations.Visit_IDFtbl_Locations.Location_ID=tbl_Visits.Location_IDF(((tbl_Observations.Species_IDF)=[Enter four character species code:]))tbl_Visits.Visit_ID=tbl_Observations.Visit_IDFtbl_Locations.Location_ID=tbl_Visits.Location_IDF(((tbl_Visits.Visit_ID) Is Null))tbl_Visits.Visit_ID = tbl_Observations.Visit_IDFCount(qry_Species_by_Site.Species_IDF)tlu_Bird_Codes_VT.Species=tbl_Observations.Species_IDFCount(tbl_Observations.Species_IDF)Sqr(([X_Coord]-[Forms]![frm_Locations]![X_Coord])^2+([Y_Coord]-[Forms]![frm_Locations]![Y_Coord])^2)(((tbl_Locations.Location_ID)<>[forms]![frm_Locations]![Location_ID]))Sqr(([X_Coord]-[Forms]![frm_Locations]![X_Coord])^2+([Y_Coord]-[Forms]![frm_Locations]![Y_Coord])^2)tbl_Locations.Location_ID = tbl_Visits.Location_IDFtbl_Visits.Visit_ID = tbl_Observations.Visit_IDFtbl_Locations.Location_ID = tbl_Visits.Location_IDFCount(tbl_Observations.Observation_ID)qry_Individuals_Per_Visit.Location_IDMax(qry_Individuals_Per_Visit.CountOfObservation_ID)qry_Individuals_Per_Visit.Location_ID(((tbl_Raw_Data.[How Detect])<>"F"))IF]n< ` !  o 5 ~ ` R  S  LhJ,5nP2EJd2g,tbl_Visits.Count/ g,tbl_Observations.Species_IDF; g,tbl_Locations.Forest_Percent; g,tbl_Locations.Location_ID8 g,tbl_Observations111 ,tbl_Visits%%% ,tbl_Locations+++ , , G+ @k '+ tbl_Observations.Species_IDF; g+ tbl_Locations.Location_ID8 g+tbl_Visitstbl_Observations\@kQE% +tbl_Locationstbl_Visitsb@kK?+ +tbl_Locations.Location_ID8 g+tbl_Observations111 +tbl_Visits%%% +tbl_Locations+++ + + G*B@k '*tbl_Visitstbl_Observations`@kQE% *tbl_Visits.Visit_ID2 g*!tbl_Observations.Observation_ID> g*tbl_Observations111 *tbl_Visits%%% * G* G* * G) !qry_Species_by_Site.Location_ID> g)CountOfSpecies_IDFL@ kA55 o)!qry_Species_by_Site.Location_ID> g)qry_Species_by_Site777 ) G) G) ) G( !tlu_Bird_Codes_VT.[Common Name]> g( tlu_Bird_Codes_VT.Species8 g(tlu_Bird_Codes_VTtbl_Observationsl@ k_S3 (CountOfSpecies_IDFF@ kA55 o(!tlu_Bird_Codes_VT.[Common Name]> g(tlu_Bird_Codes_VT.Species8 g(tbl_Observations111 (tlu_Bird_Codes_VT333 ( ( G' @ k ''@ k ''tbl_Locations.Location_ID8 g'Distance@k-!! o'tbl_Locations+++ '1 O' G' ' G& tbl_Visits.Visit_ID2 '&tbl_Locationstbl_Visitsf@kK?+ &tbl_Visits.Visit_ID2 g&tbl_Locations.Location_ID8 g&tbl_Visits%%% &tbl_Locations+++ & G& G& & G% tbl_Visits.Visit_ID2 g% tbl_Locations.Location_ID8 g%tbl_Visitstbl_Observations`@kQE% n @ @ @ @ @ @ @ @ @ @ @ @ @ @))))))))) ) )) ) )) ))))))))))))))))) )!))")$)%)& )')#)()*)+),)-))).)0)1)2)3)4)5)6)7)8)9):);)<)= )>)?)@)A)/)B)D)E)F)G)H)I)J)K)L)M)N ii)Ciiiiiii i i i ii iiiiiiiiiiiiiiiiii i!i"i#i$i%i& i' i(ii)i+i,i-i.i/i0i1i2i3 i4 i5 i6 i7 i8 i9i* i: i< i= i> i? i@ iA j j j j i;!j!j!j!j!j !j ! j ! j !j"j "j"j"j"j"j"j"j"j"j" j" j" j" j" j" j"j#j#j #j!#j"#j##j$#j%#j&#j'#j(# j)# j*# j+# j,# j-# j.#j$j/$j1$j2$j3$j4$j5$ j6$j0%j7%j9%j:%j;%j<%j=%j>%j?%j@%jA%l%j8jm @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @iiiii i!i"i#i$i%i& i' i(ii)i+i,i-i.i/i0i1i2i3 i4 i5 i6 i7 i8 i9i* i: i< i= i> i? i@ iA j j j j i;!j!j!j!j!j !j ! j ! j !j"j "j"j"j"j"j"j"j"j"j" j" j" j" j" j" j"j#j#j #j!#j"#j##j$#j%#j&#j'#j(# j)# j*# j+# j,# j-# j.#j$j/$j1$j2$j3$j4$j5$ j6$j0%j7%j9%j:%j;%j<%j=%j>%j?%j@%jA%l% l% l%j8&l&l&l&l&l&l &l &l & l &l'l 'l'l'l'l'l'l' l'l(l(l(l(l(l(l(l( l( l(l)l )l")l#)l$)l%)l&) l')l!*l(*l**l+*l,*l-*l.*l/*l0*l1*l)+l2+l4+l5+l6+l7+l8+l9+ l:+ l;+ l<+l3,l=,l?,l@,lA,lB,lC,lD,lE,o,o, o, o, o, o,l>-o-o-o -o -o -o -o -o- o- o-o.o.o.o.o.o.o.o/o/o/o/o/o/o/o/o /o!/ o"/ o#/ o$/o%Ju9 U  p  g I + 9  _ 5 Y// Y`@k g/ Y`@k g/ Yf@k g/YTotal Of Countb@k9-- o/YCountOfCountb@k5)) o/Y`@k g/Y`@k g/Yf@k g/RYqry_Species_by_Location_and_ForestUUU /Y G/Y G/RY /Y G.!(((tbl_Raw_Data.Count)="Tape"))> '.tbl_Raw_Data.Count"3"F5 w.tbl_Raw_Data))) . G. G. . G- tbl_Observations.Species_IDF; g- tbl_Locations.Location_ID8 g-tbl_Visitstbl_Observations\@kQE% -tbl_Locationstbl_Visitsb@kK?+ -tbl_Observations.Species_IDF; g-tbl_Locations.Location_ID8 g-tbl_Observations111 -tbl_Visits%%% -tbl_Locations+++ - - G, tbl_Visits.Count/ g, tbl_Observations.Species_IDF; g, tbl_Locations.Forest_Percent; g, tbl_Locations.Location_ID8 g,tbl_Visitstbl_Observations\@kQE% ,tbl_Locationstbl_Visitsb@kK?+ bYNqqYY Y Y Y ,.SwitchboardIDItemNumberItemTextCommandArgument., ., qs,. YPrimaryKeyv1pj)Close Switchboardmac_Switchboard.Close_Switchboardn, Toggle Navigation Panemac_Switchboard.Toggle_Panel6 View bird count datafrm_LocationsL2 Open data entry formfrm_LocationsL2 Main SwitchboardDefault8*  prrrrr YN  uu Y  Y Y Y Y  Y  Y dY Y Location_IDForest_Percent"Grassland_Percent"Developed_PercentX_CoordY_CoordLast_UserLast_DateLast_Timex1uwuxYYY.rCLocation_IDPrimaryKeyv1@@ t[$H l 5 Y " } F  0KBΈ?_"@eLSwitchbo219.D--&? v RB'A= BxMSwitchbo219.C--&? ŞBΈJ@EG6AMSwitchbo219.B--&? 'B s? ?LSwitchbo219.A--&? MBEG6@Switchbo216.D--&? RB8g@ӹ+Switchbo216.C--&? B"?eSwitchbo216.B--&? _BRGBSwitchbo211.D--&? 0WB_G6B"?bSwitchbo211.C--&? 殮A$BJ > ]Switchbo211.B--&? wEAQBSwitchbo211.A--&? MB @,Switchbo191.D--&? EG6B0WB"?ΣSwitchbo191.C--&? B ASwitchbo191.B--&? 0B=ARSwitchbo191.A--&? B_"@@%ZSwitchbo177.D--&? iφBΈJ@aA\Switchbo177.C--&? RB?)B_[Switchbo177.B--&? rAxEA^BYSwitchbo177.A--&? =B0{2B"@_nSwitchbo119.D--&? FBEOB0*@|`mSwitchbo119.C--&? ^7Bv RBΈ?P-oSwitchbo119.B--&? WBvqA?5pSwitchbo119.A--&? t88HJv88HLv88HMv88HOv8DDJv8DDLv8DDMv8DDOv8H8Jv8H8Lv 8H8Mv 8H8Ov :88Jv :88Lv :88Mv:88Ov:8BLv:8BMv:8BOv:8HJv:8HLv:8HMv:8HOv t88HJv88HLv88HMv88HOv8DDJv8DDLv8DDMv8DDOv8H8Jv8H8Lv 8H8Mv 8H8Ov :88Jv :88Lv :88Mv:88Ov:8BLv:8BMv:8BOv:8HJv:8HLv:8HMv:8HOv( YpNzzpppEpEY Y  Y Y  Y eObservation_IDVisit_IDFSpecies_IDFDetect_TimeDetect_TypetWkz , z zYYYPrimaryKey6tbl_Speciestbl_Observations4tbl_Visitstbl_Observationsv1ytX< x\@$ | ` D ( d H ,  h L 0  l P 4  p T 8  tX< x\@$|`D( dH,hL0lP4pT8tX<  YWARA YWARA YWARA SOSPA SOSPA  RWBLA RWBLA NOCAA  HOFIA EAKIV ~DOWOA }COGRV |AMCRA { YWARA zYWARA y RWBLA xRWBLA wHOFIA vDOWOA uAMROV tSOSPV sRWBLV rRBGRV qHAWOV p DOWOV o BHCOV nBCCHV mBCCHV lAMROV kAMGOV jAMGOV iVEERA hTRESV g SOSPA fSOSPA e COYEA dBHCOV cBHCOV b AMROA aAMGOA `AMGOA _AMCRA ^AMCRA ] SOSPA \NOCAA [MODOV ZDOWOA Y COYEA XBHCOV WBHCOV V AMROA UAMGOV T AMCRA SREVIV RDOWOA Q BAORV PAMROV OAMGOV NAMGOV MWTSPA LSOSPA KSCTAA J REVIA IDOWOA H COYEA GAMROA FAMGOA E WTSPA DWODUV CSOSPA BSOSPA AREVIA @NOCAA ? COYEA >AMGOA = REVIV <REVIV ;REVIV :NOCAV 9HETHV 8 DOWOV 7DOWOV 6BCCHV 5AMGOV 4AMGOV 3 SOSPA 2 SOSPA 1 NOFLA 0 COYEA / AMROA . AMGOA - AMGOA , AMCRA + SOSPA * RWBLA ) RWBLA ( REVIA ' NOFLA & NOCAA % DOWOV $ COYEA # AMROA " AMROA ! SORAA  RWBLV  RWBLV  RWBLV  COYEV  BCCHV  AMGOV  AMGOV  SWSPA  SWSPA  SWSPA  RWBLV  RWBLV  RWBLV  RWBLV  GRCAA  COYEA  COYEV  AMROA  AMGOV  SWSPA  SWSPV  SWSPA  SOSPV  SORAA  RWBLV  RWBLV  RWBLV  RWBLV  GRCAA  GCFLA  COYEA  AMGOA ytX< x\@$ | ` D ( d H ,  h L 0  l P 4  p T 8  tX< x\@$|`D( dH,hL0lP4pT8tX< %AMCRA %ALFLV $YWARA  $ WTSPA  $ WOTHA  $ VEERA  $SOSPV  $SOSPA $ RWBLA $RWBLV $OVENA $ MALLV $ COYEV $COYEA $BCCHA $ALFLV #YRWAV #YBSAV #YBSAV #WOTHA #OVENA # BLJAA # BCCHV " WOTHA "WOTHA "REVIA "REVIA " OVENA !WTSPA ! WOTHA !WOTHA ! REVIA ! OVENA !HETHA  WBNUV  WBNUV  SCTAV  RTHUV  REVIV  RBNUV  RBNUV  PIWAV  PIWAV  EAWPV  DOWOV  BTBWV  BRCRV  BRCRV  BCCHV  BCCHV  AMGOV  AMGOV  WIWRA  VEERA SCTAA REVIA PIWAA  EAWPA  BTNWA BTBWA  AMROA WIWRA  VEERA REVIA  ETTIA EAWPA  BTNWA BLJAV AMROA YRWAV REVIV PIWAV OVENV  NOCAV NOCAV ETTIV  BCCHV BCCHV BCCHV YBSAA PIWAA  OVENA NOFLA  INBUA ETTIA AMROA  AMCRA  OVENA  NOCAA NOCAA INBUV BCCHA  AMROA AMROA AMCRA  PIWAV  NOCAV GRCAV GCFLV ETTIV DOWOV  BLJAV BHCOA  BCCHV BCCHV BCCHV BCCHV AMROV AMCRA RBGUA NOCAA ETTIA  EAWPA COGRA BLJAA BCCHA AMROA  AMCRA AMCRA  NOCAA EAWPA BCCHA AMROA AMCRA RWBLV GRCAV DOWOV COYEV  COGRV BCCHV BCCHV  BAORV AMREV AMREV AMGOV AMGOV ytX< x\@$ | ` D ( d H ,  h L 0  l P 4  p T 8  tX< x\@$|`D( dH,hL0lP4pT8tX< 0SAVSV 0EUSTV 0 BOBOV 0 BOBOA 0BOBOV 0BOBOV 0BARSV 0BARSV 0AMGOV /YWARV /YWARA /SOSPV / RWBLV /RWBLV /RWBLV / NOCAV /GRCAV / CHSPV /CEDWV /BCCHV /BARSV / BAORV /AMROV / AMKEV /AMGOV /AMGOV ~. YWARA }.YWARA |.RWBLA {.NOCAA z.GRCAV y.CEDWV x.CEDWV w.BHCOV v. BARSV u. BAORA t.BAORV s.AMGOV r. AMCRA q- YWARA p-YWARA o-YWARA n-RWBLA m-RWBLV l-RWBLV k- NOCAA j-GRCAA i-CEDWV h- BARSV g-BARSV f-BAORV e- AMCRA d,REVIV c,REVIV b, BLJAA a, BCCHV `,BCCHV _,BCCHV ^,BAWWV ]+SCTAA \+REVIA [+ OVENA Z+OVENA Y+ HETHA X+EAWPA W+ BTBWA V+BLJAV U+AMROA T+ AMCRA S*REVIA R* OVENA Q*OVENA P*NOFLA O* EAWPA N* BTBWA M* BLJAA L*AMROA K)YBSAV J)YBSAA I)SOSPV H) RBGRV G)MODOA F) INBUV E)CSWAV D)BLJAV C)BCCHV B)AMROV A)AMGOV @)AMGOV ?(WOTHA >(SOSPA =(RWBLA <( OVENA ;(NOFLA :( MODOA 9(DOWOV 8(CSWAA 7(BLJAV 6( BHCOA 5(BCCHA 4(AMROV 3( AMCRA 2'WOTHA 1'RWBLA 0' OVENA /' MODOA .'COYEA -'BLJAV ,'BHCOV +'AMROA *' AMCRA )& YRWAV (&WOTHA '& SOSPV &&REVIV %&MAWAV $&GRCAV #&FISPV "&EATOV !&COYEV  &COYEV & BCCHV &BCCHV &BCCHV &BCCHA &BAORV %WTSPA % WOTHA % RWBLA %OVENA %EATOA % COYEA %COYEV %COYEA % BCCHA % BCCHA ytX< x\@$ | ` D ( d H ,  h L 0  l P 4  p T 8  tX< x\@$|`D( dH,hL0lP4pT8tX<  BCEDWA B BCCHA BBCCHA AYBSAV AYBSAV AWBNUV AREVIV A PUFIV APUFIV AOVENV ABTNWV A BHVIV ABHVIV ABCCHV @ WIWRA @ OVENA @ BTBWA ?WIWRA >WBNUV  >REVIV  > CSWAV  >CSWAV  >BLJAA  >BCCHV =PUFIA = CSWAA <REVIA < CSWAA ; YBSAV ;YBSAV ;YBSAV ;REVIV ;PUFIV ;OVENA ;BTNWA ; BTBWA ;BCCHV ;BCCHA ;AMROV ;AMROV : REVIA :OVENA : MODOA :BTNWA : AMROA 9YBSAA 9 REVIA 9 OVENA 9OVENA 9MODOA 9 BTBWA 9AMROA 8COYEV 8BOBOV 8BOBOA 8BOBOV 8BLJAA 8BEKIV 8BCCHV 8 AMGOV 8AMGOV 8AMCRA 7SOSPA 7SOSPA 7SAVSV 7RWBLA 7 COYEA 7COYEA 7COGRV 7 BOBOV 7BOBOV 7BOBOV 7BOBOV 7BOBOV 7AMCRA 6 SOSPA 6 RWBLA 6 GBHEV 6COYEA 6COYEA 6 CORAV 6 BOBOV 6BOBOV 6BOBOV 6AMCRA 6AMCRA 5YWARV 5ETTIV 5COYEV 5BCCHV 5AMGOV 4YWARA 4YRWAA 4 SOSPA 4 RWBLA 4MODOA 4GRCAA 4COYEA 3YWARA 3 YRWAA 3SOSPA 3RWBLA 3RWBLA 3 NOHAV 3 NOCAA 3COYEA 3AMGOA 2YWARV 2TRESV 2REVIV 2 NOHAV 2NOCAV 2GRCAV 2COYEV 2BOBOV 2BLJAV 2BCCHV 2BCCHV 2BARSV 2 AMGOV 1 YWARA 1TRESV 1SOSPV 1 SAVSA 1 NOCAA 1EAKIV 1COYEA 1 BOBOA 1BOBOV 1BLJAA 1 BARSV 1BARSV 1AMGOV 0 YWARA 0SAVSA 0SAVSV yPtX< x\@$ | ` D ( d H ,  h L 0  l P 4  p T 8  tX< x\@pMREVIA oMBCCHV nMBCCHV mMBCCHV lMAMCRV kMAMCRV jL RBGUA iL OVENA hL GCFLA gLBEKIA fLBCCHA eLBCCHA dLAMCRA cKGCFLA bKEAWPA aK AMCRA `J REVIV _JDOWOV ^JCOHAV ]J BCCHA \JBCCHV [JAMCRA ZI REVIA YI OVENA XIDOWOA WIBCCHA VIBCCHA UIAMGOA TI AMCRA SH REVIA RHOVENA QHNOCAA PH BCCHA OGWBNUV NGRTHUV MGRTHUA LGREVIV KG NOCAV JGNOCAV IGBLJAV HGBLJAA GG BCCHV FGBCCHV EG AMROV DGAMROV CGAMROV BGAMGOV AF REVIA @FNOCAA ?FBLJAA >FBLJAA =FAMROA <F AMGOA ;FAMCRA :E REVIA 9EBLJAA 8EBLJAA 7EAMROA 6EAMROV 5E AMCRA 4DYRWAV 3DWBNUV 2DWBNUV 1D REVIV 0DREVIV /D PIWAV .D NOCAV -D ETTIV ,D COHAV +D BCCHV *DBCCHV