FLOOD09060 - Laserfiche WebLink

Home Browse Search

I I I I I I I I I I I I I I I ! I I I I CHAPl'ER IV USING THE NEEDS ASSESSMENT DATABASE INTRODUCTION The main goal for the Needs Assessment database is to be a source of infonnation that can be used by any interested person. There is one database tool , the query, that can be used for almost any type of infonnation that needs to be gathered. Queries are used to compile all the infonnation for one specific reason. The query to be illustrated below is a very straight forward query, however, there are a multitude of variations that can be made. In Access 97, if one wanted all the infonnation from the institutional issues section for a particular county, he/she would make a the query, then create a report. A query of this type would be easier for some one with Access knowledge or with help from the Report Wizard in Access 97. Another way to use queries, is to import the infonnation into an Excel spreadsheet. Once in the spreadsheet, the data is manipulated to create a of graph or to get statistical results. MWE must note that any query made should be properly and explicitly labeled so that readers do not misinterpret the results. As an example, a query of those conununities that have indicated a flood problem related to existing irrigation or other water delivery facilities will be illustrated in this chapter. Note that another way to make a query instead of using the "Design View," is to use the Query Wizard in Access 97 which leads one through the process of making queries step-by-step, BASIC DEFINITIONS Before actually making the query, there are a few definitions and explanations on how to perfonn simpler conunands. Most people who know how to maneuver in Windows-based environments will be familiar with items discussed in this section. The first definition is a tabbed page. Access 97 and earlier versions used a type of fonn or screen that looks like file folders. Each file folder contains basic tools that can be used in Access 97 and lists all the files that have been made for each particular database. For instance, if one wanted to make a macro that would save records, that person would use the "Macros" tabbed page. In addition, the main screens used to enter data for this database is in the fonn of tabbed pages. Two quick definitions are for "entering" and "clicking." To "enter" or "hit enter" means to push the enter key which is standard for most computer users. Clicking is in reference to mouse buttons. More often than not, the left mouse button is used for the majority of clicking in Access 97. Also, where ever a click is used, one could use a "double click" instead. A double click is a click and enter combined into a single IV-I 97.(l6().OCH