Laserfiche WebLink
<br />CHAPTE~: IV <br /> <br />USING THE NEEDS ASSESSMENT DATABASE <br /> <br />INTRODUCTION <br /> <br />The main goal for the Needs Assessment database is to be <l source of information that can be used by any <br />interested person. There is one database tool , the qm:ry, th<lt can be used for almost any type of <br />information that needs to be gathered, Queries are used to compile all the information for one specific <br />reason, The query to be illustrated below is a very straight forward query, however, there an: a multitude <br />of variations that can be mad,:, In Acce;;s 97, if one wanted all the information from the instiUltional issues <br />section for a particular county, he/she would make a the query, then I:reate a report, A query of this type <br />would be easier for some om: with ACC($S knowledge or with help from the Report Wizard in Access 97, <br />Another way to use queries, is to import the inforD1<ltion into an Excel spreadsheet. Once in the <br />spreadsheet, the data is manipulated to ~reate a of graph o! to get statistical results. MWE must note that <br />any query made should be properly and explicitly labeled so that readers do not misinterpret the results, <br />As an example, a query of those communities that have indicated ,1 flood problem related to existing <br />irrigation O! other water delivery facilities will be illustrated in this chapter. Note that another way to make <br />a query instead of using the "Design View," is to use the Query Wizard in Access 97 whic:h leads one <br />through the process of making queries :,tep-by-step, <br /> <br />BASIC DEFINITIONS <br /> <br />Before actually making the query, there are a few definitions and explanations on how to perform simpler <br />commands, Most people who know how to maneuver in Windows-based environments will be familiar <br />with items discussed in this section, <br /> <br />The first definition is a tabbed page. Access 97 and earlier vl:rsions used a type of form or screen that <br />looks like file folders, Each :file folder ,;ontains basic tools that can be used in Access 97 and lists all the <br />files that have been made for each partic:ular database. For in~tance, if one wanted to make a macro that <br />would save records, that person would use the "Macros" tabbed page. In addition, the main scree,ns used <br />to enter data for this database: is in the form of tabbed pages. <br /> <br />Two quick definitions are for "entering" and "clicking," To "enter" or "hit enter" means to push the enter <br />key which is standard for most computl:r users. Clicking is in reference to mouse buttons. More often <br />than not, the left mouse button is used for the majority of clicking in Access 97. Also, where ever a click <br />is used, one could use a "double click" instead, A double click is a click and enter combined into a single <br /> <br />IV-I <br /> <br />97-060,001 <br />