1. Steve Adams Design is an architectural firm specializing in corporate projects such as commercial building architecture, interior decoration, master planning, and sustainable design and consulting. As part of its ICT asset management program, the IT director has asked you to build an Access database to manage the devices used by employees. The database will contain information about each device, such as manufacturer, model, date acquired, condition, purchase price, and current value.

Create an empty database named Adams. Download the Excel file Ch03Ex02 and import the two worksheets to tables in your database. Create a totals query to summarize the current value of equipment for each category. Create a report displaying the names and locations of employees who use laptop computers. Create a report displaying the names and locations of employees who use CAD systems.

2. Jay's Bikes is a family-owned and -operated business that stocks a wide range of bikes designed to fit the needs of professional riders, your child's first bike, and everything in between. The business has 12 full-time employees. Download the Excel file Ch02Ex01 (Figure 2.21) to calculate average IT spending so that it can be compared with the retail industry average. Recall that average IT spending in the retail industry is about 2 percent of revenue. How do Jay's IT expenditures compare with the industry average? How much would Jay need to change spending in order to match the retail industry average?

Figure 2.21

Jay's Bikes revenue and IT expenditures.

A B C H Revenue Apparel & shoes Figure 2.21 250,000 2 Bike accessories S 550,000 3 New bikes $ 2,650,000 Used bikes S 18,500 OUI A Bike repairs 33,000 7 IT Expenditures Hardware S 15,000 8 Software updates S 18,000 Software licenses S 4,500 10 Software support S 4,500 11 Employee training S 5,000 12 Web site development S 5,000 13 Internet access S 1,200