PREVENTION ACTIVITIES 2000

1. PREVENTION ACTIVITIES 2000 Microsoft Access 2000 Presentation by R.R. Killian

2. LOGGING IN • Log onto IntraForestry however it is currently done. • Double click the Microsoft Access icon and open “PA2000.MDB”. • Enter the information requested on the screenshots below. RRKILLIAN MONTECARLO

3. MAIN MENU After successfully logging in, this main menu will appear. To log out and close the menu, simply hit the X in the upper right corner.

4. SETUP ISSUES Before the database can be used effectively, it must be setup properly. Some of the responsibility belongs to the individual districts and some of the responsibility belongs to the Harrisburg office. Listed below are the Four categories of information required. • Account setup (individual districts) • Other properties (Harrisburg office) • District information (Harrisburg office) • Warden information (individual districts)

5. ACCOUNTS The database starts out with only 22 accounts. • Harrisburg office • 20 district accounts • Emergency backup To work with accounts, go to the main menu and chick the button below.

6. ACCOUNTS District managers, using the 20 default district accounts, can setup accounts for the people in their district. Only those 20 accounts, and the other 2 special accounts, have these privileges. • Username • Passcode • District • Additonal information ACCOUNT SECRET 16 R.R. KILLIAN

7. ACCOUNTS District managers can also delete accounts or change accounts. Regular users can change their passwords at will on the lower half. ******

8. ACCOUNTS Don’t delete your own account unless you like waiting for the IT people!

9. PROPERTIES Things such as what kind of prevention activities are approved and what kind of age groups targeted can be entered and printed from here. Something

10. DISTRICTS AND WARDENS The other two main areas that need filled in have to do with districts and wardens involved in the WHIP program. That information can be updated and even printed from the section on main menu pictured to the side.

11. DISTRICT INFORMATION District and division information then Needs to be setup so that teams doing fire prevention activities can get credit. These forms pictured to the side are only open to district managers and the Harrisburg office. • Create • District • Division • Edit • District • Division • Remove

12. WARDEN INFORMATION Wardens then need to be registered by the district managers or the Harrisburg office in order to get credit for their fire prevention activities. • Submit • Full Name • Social Security Number • District • Change • Full Name • Social Security Number • District • Delete

13. PREVENTION EVENTS The main purpose of this database is to catalog fire prevention events and provide both those in the office and in the field with the information they need to make important decisions. Displayed here is a screenshot from the main menu where the those tools are located. • Enter New Records • Update Old Records • View/Print Records • Print out a hard copy of a record. • Print Blank Forms • For use in the field or by people not yet ready to use to computers. • Search/Query Records • Helpful in looking up events sharing some similarity.

14. NEW EVENTS This is the place where all events are originally entered into the database. All the fields on this form, except for “Comments”, are REQUIRED. • Enter event data inthe upper portion. • Hit “Enter Record” button on the right. • Fill in an entry below for each warden that was participating. • Hit the “Continue” button on the right. • Repeat for each event. TV commercialarsonpolice officersadults1002 8forest9-9-1999fire stationcountytownship Joe Somebody 123456789 Fire Warden 8

15. OLD EVENTS Occasionally an error might occur, so this form was included for corrections. It functions very much like the previous form except that the bottom half is enabled from the start.

16. PRINTING RECORDS This form allows the user to go through the database of fire prevention events and print out specific records if they should be needed for some reason.

17. SEARCHING RECORDS This form allows the user to find records within the database that share a particular property. Though not as powerful as SQL, it has a much easier interface to make it more accessible to the average user. 1984 ………………………………………………………………………………………………………………………………………………………….………………………………………

18. REPORTS (1) Reports are available to display many types of data in a readable form. Typically, these will only be used in Harrisburg and/or district offices. Statewide or Per District? • History (all events) • Annual (one year) • Period (specific range)

19. REPORTS (2) There are 5 separate types of reports available, 26 counting the different time and location parameters mentioned earlier. • Event Log Statistics • Shows the number of each type of event and Smokey Bear appearances by district. • Township/County • Like above, filtered by county/township. • Activity Overview (Everyone) • Shows events people participated in. • Activity Overview (Wardens) • Shows events for only wardens only. • Complete Reports • Shows complete details recorded on specified fire prevention activities.

20. ADVANCED SQL Included, for extensibility, is an SQL interpreter. This is to be used when none of the preprogrammed queries fit your requirements and the IT department is unable to accommodate it for some reason. However, to use this feature effectively, you must learn the powerful Structured Query Language. A short overview is included with the User Guide. SELECT [field] FROM [table];