Steps to complete: 1. Steve Adams Design is an architectural firm specializing in corporate design projects such as commercial building architecture, interior design, master planning, and sustainable design and consulting. 2. As part of its ICT asset management program, the IT director has asked you to use an Access database to manage the devices used by employees. 3. The database will contain information about each device, such as manufacturer, model, date acquired, condition, purchase price, and current value. 4. Open Microsoft Access. 5. From within Access, open the database file named: Ch03Ex02.accdb which is in the Canvas files folder. 5. Create a Totals query to summarize the current value of equipment for each category. 6. Create a report displaying the names and locations of employees who use laptop computers. 7. Create a report displaying the names and locations of employees who use CAD systems. Des Device ID C001 - Manufactur. Dell C002 X Category CAD CAD CAD CAD CAD C003 Dell Dell C004 Dell COOS COOG COO7 Dell Dell CAD CAD Dell COO CAD CAD Dell Dell Dell C009 L001 LOOP 1003 PC001 Laptop Laptop Laptop Dell Dell Dell Dell pc Dell Dell PC Model - Acquired Da - Purchase Pri. Current Vall. Condition - Location - Retired Date. Description - Employee I-a T1200 Tower 01/15/09 $1,074.00 $300.00 Good Chicago, IL 22/2010 Precision T120 001 T1500 Tower 03/24/09 $1.223.00 $300.00 Good Chicago, IL Precision T150 EOOZ XPS M1330 07/15/09 $1,879.00 $49.00 Fair Chicago, IL Precision MobiW001 T3500 Tower 10/12/09 $2.544.00 $300.00 Good Chicago, IL Precision Tax 1003 17500 Tower 02/28/10 $2,785.00 $800.00 Excellent Oakbrook, IL Precision T2502001 T7500 Tower 02/28/10 275.00 S800.00 Excellent Chicago, Precision T250 010 M90 02/28/10 $2.175.00 S600.00 Excellent Oakbrook, IL Precision Mob WOOZ M90 02/21/10 $2.175.00 S600.00 Excellent Chicago, IL Precision Mobi 1001 T5500 Tower 03/12/11 $2.415.00 $200.00 Excellent Oakbrook, Precision TSSO 011 E4300 12/10/08 $1,029.00 $200.00 Fair Chicago, IL Latitude E430002 E6400 03/24/09 $989.00 $200.00 Excellent Chicago, IL Latitude E6400 003 E6520 02/19/11 $800.00 Excellen Oakbrook, IL Latitude E6520 0011 OptiPlex 745 01/15/09 $320.00 Fair Chicago, IL 2/23/2011 Optiplex 745 D E005 OptiPlex 745 01/15/09 $10Fair Chicago, IL 2/23/2011 Optiplex 745D EOS Vostro 230 03/23/10 14.00 $200.00 Goed Chicago, IL Vostro 210 M ODS Vostro 230 04/28/10 S434.00 $200.00 Good Chicago, IL Vostro 230 Min 00s XPS X8300 12/05/10 $1.099.00 S100.00 Excellent Chicago, IL XPS 8300 Deskt 6007 XPS X8300 02/28/10 $1,099.00 S D Excellent Oakbrook, IL XPS 8300 Des 011 Vostro 320 02/23/11 S77100 $120.00 kcell Chicago, IL Vostro 320 Des 2012 Vostro 320 02/23/11 $771.00 $120.00 Excellent Chicago, IL Vostro 320 Des Vostro 320 02/21/11 $771.00 $320.00 Excellent O brook, Vostro 320 Des iPhone 12/10/08 $395.00 $120.00 Chicago, IL 2/28/2010 iPhoney 0 01 iPhone 02/28/10 $450.00 SI50.00 Oakbrook, IL iPhone 3 010 iPhone 06/29/10 $599.00 $200.00 Chicago, IL iPhone E001 TITO 01/24/09 $2995.00 $120000 Chicago, IL Designjet plott W001 02/28/10 $1,995.00 $1.500.00 O , Desje plot wou L7590 12/10/08 $28.00 $100.00 Chicago, IL Officejet Pro A 100 P4015 01/18/09 $699.00 $200.00 Chicago, IL Lase let BlackW001 CP3515 02/19/09 $1,298.00 $100.00 Chicago, Color Laserjet i WOOL P4014 02/28/10 S00 Oakbrook, it Laseet Black WOO 02/21/10 $1.699.00 S500.00 Dabro Color Laserjet I WO Tuscan 01/24/09 $1.295,00 51.800.00 Chica Wide formats Wo01 01/05/10 94,295.00 $2,200.00 Oakbrook, Wide formats W002 Dell PC003 PC004 PCOS PCOS PC007 PCOS PC009 PH001 PHOO2 PHoo3 PEDO PC Dell Dell Dell Dell Smartphone Smartphone Smartphone Apple Apple Apple plotter plotter Printer Printer PR001 PROO PRDO PROO4 PROOS SC001 SCOOP CP5225 Printer Scanner Scanner Vidar Vidar Truscan All Access Obie Search Tables 31 Devices 1 Users Devices x Employee IC. E001 E002 E003 E004 E005 E006 E007 E008 E009 E010 E011 Users x Location Name Click to Add- Chicago, IL Steven Adams Chicago, IL Aaron Love Chicago, IL Gary Buxton Chicago, IL Michael Staffoi Chicago, IL Patricia Spain Chicago, IL Dharma Milner Chicago, IL Thanh Nguyen Chicago, IL Myron Duarte Chicago, IL Cheryl Perez Oakbrook, IL Calvin Russell Oakbrook, IL Virginia Thiess Oakbrook, IL Wenquaoui Oakbrook, IL Jo Ann Cortelle Chicago, IL Chicago Workg Oakbrook, IL Oakbrook Worl E012 E013 W001 W002
