Laserfiche WebLink
<br />command. However, there are cases were double clicks do not work, Clicking on the right mouse button <br />or "right-clicking" gives one a pull down menu, This makes it faste:r to work because one does not have <br />to move the mouse around the screen as much. <br /> <br />Clicking is used in many aspects. For instance, some icons on the toolbar have different options that will <br />appear if the left mouse button is held down while on top of the icon, Holding down the left button and <br />moving the mouse at the sarne time will move or "drag" the highlighted object around, This command is <br />a faster way to move or "cut and paste" objects when creating forms, queries or reports, Now one is ready <br />to make a query using the Design View, <br /> <br />EXAMPLE <br /> <br />Necessary Decisions <br />Before a query is made, information "bout the relationship between data in the database and the query <br />should be determined, The first piece of information needed to makl~ any query in this database is which <br />table the information is in, Since this query is related to a floodplain management issue, use the table <br />entitled "Community Flood Managemmt Table," All the tables for the database are found on the tabbed <br />page "Tables," <br /> <br />The second decision is to decide which group the query will f()cus on, In this example, the focus will be <br />on all communities who returned questi,}nnaires, One could narrow the field down even more by querying <br />all communities in Weld County that returned questiOtulaires, The table chosen already consists of <br />information only from returned questicnnaires, <br /> <br />The final decision is how much information is required to make the query understandable, With the way <br />the Needs Assessment database is designed, the communit)' name and county are almost always required <br />(for organizations, the organization name is required in every query), The other information needed is the <br />heading for the column containing the r'~sponses for the particular query. In this case, the column heading <br />is "Flood Prob w/ Existing Irrig," In the table, one should also note three adjacent columns with the first <br />word of each heading "Irrig" indicating these are probably related to the main question, <br /> <br />Making the Query <br />Once those decisions have bel~n made, go to the "Queries" tabbed page. Click on the button labeled "New" <br />on the right hand side of the page. Then higWight the title "Design View" and press enter. On the screen <br />will be a list of all the tables and queries in the NeedS Asst:ssment database, Chose the .Comnlunity Flood <br />Management Table" and close the list since it is no longer needed, In the labeled table that appears, there <br />should be a list of all the column headings for the Community Flood Management Table. Chose the six <br /> <br />IV-2 <br /> <br />97-O6{),001 <br />