Access Application: Citywide Community College Louis Hermann, IT manager at Citywide Community College, is working with two spreadsheets to manage computer security incident reporting. One spreadsheet...

Access Application:

Citywide Community College

Louis Hermann, IT manager at Citywide Community College, is working with two spreadsheets to manage computer security incident reporting. One spreadsheet tracks the major components of the college’s computer systems, and the other spreadsheet tracks security incident facts. To provide for better reporting capabilities, Louis wants you to set up an Access database that tracks college departments, computer systems, and security incidents. Download the spreadsheet Ch10Ex02 and import the worksheets to create the database shown in Figure 10-24. Create a report that lists the number of security incidents reported by each department. Create a second report that lists the number of attacks in which the system was compromised for the department having the greatest number of security incidents. What other reports would Louis find useful?

Figure 10-24