FLOOD09060 - Laserfiche WebLink

Home Browse Search

I I I I I I I I I I I I I I I I il I I command. However, there are cases were double clicks do not work. Clicking on the right mouse button or "right-clicking" gives one a puIl down menu, This makes it faster to work because one does not have to move the mouse around the screen as much. Clicking is used in many aspects. For instance, some icons on the toolbar have different options that will appear if the left mouse button is held down while on top of the icon. Holding down the left button and moving the mouse at the same time will move or "drag" the highlighted object around. This command is a faster way to move or "cut and paste" objects when creating fonTIS, queries or reports. Now one is ready to make a query using the Design View. EXAMPLE Necessary Decisions Before a query is made, information about the relationship between data in the database and the query should be determined, The first piece of information needed to make any query in this database is which table the information is in. Since this query is related to a floodplain management issue, use the table entitled "Community Flood Management Table." AIl the tables for the database are found on the tabbed page "Tables." The second decision is to decide which group the query will focus on. In this example, the focus will be on all communities who returned questionnaires. One could narrow the field down even more by querying all communities in Weld County that returned questionnaires. The table chosen already consists of information only from returned questionnaires. The fmal decision is how much information is required to make the query understandable. With the way the Needs Assessment database is designed, the community name and county are almost always required (for organizations, the organization name is required in every query). The other information needed is the heading for the colunm containing the responses for the panicular query. In this case, the colunm heading is "Flood Prob wi Existing IITig." In the table, one should also note three adjacent columns with the first word of each heading "Irrig" indicating these are probably related to the main question. Making the Query Once those decisions have been made, go to the "Queries" tabbed page. Click on the button labeled "New" on the right hand side of the page. Then highlight the title "Design View" and press enter. On the screen will be a list of all the tables and queries in the Needs Assessment database. Chose the "Community Flood Management Table" and close the list since it is no longer needed. In the labeled table that appears, there should be a list of all the column headings for the Community Flood Management Table. Chose the six IV-2 97~,OOI