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.

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,200Acquired_ Purchase_ Current_V Device_ID Category Manufacturer Model Date Price alue Condition Location Retired_Date Description Employee_ID _001 Laptop Dell E4300 12/10/08 $1,029.00 $200.00 Fair Chicago, IL Lattitude E4300 E002 PH001 Smartphone Apple iPhone 12/10/08 $399.00 $130.00 Chicago 2/28/10 iPhone3 E001 PR001 Printer HP L7590 12/10/08 $288.00 $100.00 Chicago, IL Officejet Pro All-in-One E001 2001 CAD Dell T1200 Tower 01/15/09 $1,074.00 $300.00 Good Chicago, IL 2/28/10 Precision T1200 Tower Workstation E001 PC001 PC Dell Optiplex 745 01/15/09 $749.00 $320.00 Fair Chicago, IL 2/23/1 1 Optiplex 745 Desktop E005 PC002 PC Dell Optiplex 745 01/15/09 $749.00 $320.00 Fair Chicago, IL 2/23/1 1 Optiplex 745 Desktop E006 PR002 Printer HP P4015 01/18/09 $699.00 $200.00 Chicago, IL LaserJet Black & White WOO1 PLO01 Plotter HP T770 01/24/09 $2,995.00 $1,200.00 Chicago, IL Designjet plotter WOO1 SC001 Scanner Vidar TruScan 01/24/09 $3,295.00 $1,800.00 Chicago, IL Wide format scanner WOO1 PR003 Printer HP CP3535x 02/19/09 $1,299.00 $300.00 Chicago, IL Color Laserjet Professional WOD1 CO02 CAD Dell T1500 Tower 03/24/09 $1,223.00 $300.00 Good Chicago, IL Precision T1500 Tower Workstation E002 .002 Laptop Dell E6400 03/24/09 $989.00 $200.00 Excellent Chicago, IL Latitude E6400 E003 C003 CAD Dell XPS M1330 07/15/09 $1,879.00 $249.00 Fair Chicago, IL Precision Mobile Workstation WOO1 C004 CAD Dell T3500 Tower 10/12/09 $2,544.00 $300.00 Good Chicago, IL Precision T3500 Tower Workstation E003 C005 CAD Dell T7500 Tower 02/28/10 $2,785.00 $800.00 Excellent Oakbrook, IL Precision T7500 Tower Workstation E001 0006 CAD Dell T7500 Tower 02/28/10 $2,785.00 $800.00 Excellent Chicago, IL Precision T7500 Tower Workstation E010 C007 CAD Dell M90 02/28/10 $2,175.00 $600.00 Excellent Oakbrook, IL Precision Mobile Workstation WOO2 C008 CAD Dell M90 02/28/10 $2,175.00 $600.00 Excellent Chicago, IL Precision Mobile Workstation E001 PC006 PC Dell XPS X8300 02/28/10 $1,099.00 $300.00 Excellent Oakbrook, IL XPS 8300 Desktop E011 PH002 Smartphone Apple iPhone 02/28/10 $459.00 $150.00 Oakbrook, IL iPhone3 E010 L002 Plotter HP T610 02/28/10 $3,995.00 $1,600.00 Oakbrook, IL Designjet plotter WOO2 PR004 Printer HP P4014 02/28/10 $799.00 $300.00 Oakbrook, IL LaserJet Black & White WOO2 PR005 Printer HP CP5225 02/28/10 $1,699.00 $500.00 Oakbrook, IL Color Laserjet Professional WOO2 SC002 Scanner Vidar TruScan 03/05/10 $4,295.00 $2,200.00 Oakbrook, IL Wide format scanner WOO2 PC003 PC Dell Vostro 230 03/23/10 $434.00 $200.00 Good Chicago, IL Vostro 230 Mini Tower Desktop E006 PC004 PC Dell Vostro 230 04/28/10 $434.00 $200.00 Good Chicago, IL Vostro 230 Mini Tower Desktop E005 PH003 Smartphone Apple iPhone 06/29/10 $599.00 $200.00 Chicago iPhone4 E001 PC005 PC Dell XPS X8300 12/05/10 $1,099.00 $300.00 Excellent Chicago, IL XPS 8300 Desktop E007 _003 Laptop Dell E6520 02/19/11 $759.00 $300.00 Excellent Oakbrook, IL Latitude E6520 E011 PC007 PC Dell Vostro 320 02/23/11 $771.00 $320.00 Excellent Chicago, IL Vostro 320 Desktop E012 PC008 PC Dell Vostro 320 02/23/11 $771.00 $320.00 Excellent Chicago, IL Vostro 320 Desktop E007 PC009 PC Dell Vostro 320 02/23/1 1 $771.00 $320.00 Excellent Oakbrook, IL Vostro 320 Desktop E008 C009 CAD Dell T5500 Tower 03/12/11 $2,415.00 $700.00 Excellent Oakbrook, IL Precision T5500 Tower Workstation E011