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.

All Access Obje... Search... Tables 3 Devices Users Users X Category CAD CAD CAD CAD CAD CAD CAD CAD CAD Laptop Laptop Laptop PC PC PC - Manufacture - Dell Dell Dell Dell Dell Dell Dell Dell Dell Dell Dell Devices X Device ID C001 C002 C003 C004 C005 C006 C007 C008 2009 L001 L002 L003 PC001 PC002 PC003 PC004 PC005 PC006 PC007 PC008 PC009 PH001 PH002 PH003 PL001 PLOO2 PR001 PROO2 PR003 PR004 PR005 SC001 SC002 Dell Dell Dell Dell Dell Dell Model Acquired Da - Purchase Pri - Current Vall - Condition - T1200 Tower 01/15/09 $1,074.00 $300.00 Good T1500 Tower 03/24/09 $1,223.00 $300.00 Good XPS M1330 07/15/09 $1,879.00 $249.00 Fair T3500 Tower 10/12/09 $2,544.00 $300.00 Good T7500 Tower 02/28/10 $2,785.00 $800.00 Excellent T7500 Tower 02/28/10 $2,785.00 $800.00 Excellent M90 02/28/10 $2,175.00 $600.00 Excellent M90 02/28/10 $2,175.00 $600.00 Excellent T5500 Tower 03/12/11 $2,415.00 $700.00 Excellent E4300 12/10/08 $1,029.00 $200.00 Fair E6400 03/24/09 $989.00 $200.00 Excellent E6520 02/19/11 $759.00 $300.00 Excellent OptiPlex 745 01/15/09 $749.00 $320.00 Fair OptiPlex 745 01/15/09 $749.00 $320.00 Fair Vostro 230 03/23/10 $434.00 $200.00 Good Vostro 230 04/28/10 $434.00 $200.00 Good XPS X8300 12/05/10 $1,099.00 $300.00 Excellent XPS X8300 02/28/10 $1,099.00 $300.00 Excellent Vostro 320 02/23/11 $771.00 $320.00 Excellent Vostro 320 02/23/11 $771.00 $320.00 Excellent Vostro 320 02/23/11 $771.00 $320.00 Excellent iPhone 12/10/08 $399.00 $130.00 iPhone 02/28/10 $459.00 $150.00 iPhone 06/29/10 $599.00 $200.00 1770 01/24/09 $2,995.00 $1,200.00 T610 02/28/10 $3,995.00 $1,600.00 L7590 12/10/08 $288.00 $100.00 P4015 01/18/09 $699.00 $200.00 CP3535x 02/19/09 $1,299.00 $300.00 P4014 02/28/10 $799.00 $300.00 CP5225 02/28/10 $1,699.00 $500.00 TruScan 01/24/09 $3,295.00 $1,800.00 TruScan 03/05/10 $4,295.00 $2,200.00 PC Location Chicago, IL Chicago, IL Chicago, IL Chicago, IL Oakbrook, IL Chicago, IL Oakbrook, IL Chicago, IL Oakbrook, IL Chicago, IL Chicago, IL Oakbrook, IL Chicago, IL Chicago, IL Chicago, IL Chicago, IL Chicago, IL Oakbrook, IL Chicago, IL Chicago, IL Oakbrook, IL Chicago, IL Oakbrook, IL Chicago, IL Chicago, IL Oakbrook, IL Chicago, IL Chicago, IL Chicago, IL Oakbrook, IL Oakbrook, IL Chicago, IL Oakbrook, IL Retired Date - Description - Employee IC- Click to Add 2/28/2010 Precision T1201 E001 Precision T1501 E002 Precision Mobi W001 Precision T3501 E003 Precision T7501 E001 Precision T7501 E010 Precision Mob W002 Precision Mobi E001 Precision T5501 E011 Lattitude E4300 E002 Latitude E6400 E003 Latitude E6520 E011 2/23/2011 Optiplex 745 D E005 2/23/2011 Optiplex 745 D E006 Vostro 230 Min E006 Vostro 230 Min E005 XPS 8300 Deskt E007 XPS 8300 Deskt E011 Vostro 320 Des E012 Vostro 320 Des E007 Vostro 320 Des E008 2/28/2010 iPhone3 E001 iPhone3 E010 iPhone4 E001 Designjet plott W001 Designjet plott W002 Officejet Pro A E001 LaserJet BlackW001 Color Laserjet ! W001 LaserJet BlackW002 Color Laserjet ! W002 Wide format sc W001 Wide format sc W002 Dell PC Dell PC Dell Dell Apple Apple Apple HP HP PC Smartphone Smartphone Smartphone Plotter Plotter Printer Printer Printer Printer Printer Scanner Scanner HP HP HP HP HP Vidar Vidar All Access Obje... Search... Tables 2 Devices Users Devices X Employee IC - E001 E002 E003 E004 E005 E006 E007 E008 E009 E010 E011 E012 E013 W001 W002 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 Wenquao Li Oakbrook, IL Jo Ann Cortello Chicago, IL Chicago Workg Oakbrook, IL Oakbrook Worl All Access Obje... Search... Tables 3 Devices Users Users X Category CAD CAD CAD CAD CAD CAD CAD CAD CAD Laptop Laptop Laptop PC PC PC - Manufacture - Dell Dell Dell Dell Dell Dell Dell Dell Dell Dell Dell Devices X Device ID C001 C002 C003 C004 C005 C006 C007 C008 2009 L001 L002 L003 PC001 PC002 PC003 PC004 PC005 PC006 PC007 PC008 PC009 PH001 PH002 PH003 PL001 PLOO2 PR001 PROO2 PR003 PR004 PR005 SC001 SC002 Dell Dell Dell Dell Dell Dell Model Acquired Da - Purchase Pri - Current Vall - Condition - T1200 Tower 01/15/09 $1,074.00 $300.00 Good T1500 Tower 03/24/09 $1,223.00 $300.00 Good XPS M1330 07/15/09 $1,879.00 $249.00 Fair T3500 Tower 10/12/09 $2,544.00 $300.00 Good T7500 Tower 02/28/10 $2,785.00 $800.00 Excellent T7500 Tower 02/28/10 $2,785.00 $800.00 Excellent M90 02/28/10 $2,175.00 $600.00 Excellent M90 02/28/10 $2,175.00 $600.00 Excellent T5500 Tower 03/12/11 $2,415.00 $700.00 Excellent E4300 12/10/08 $1,029.00 $200.00 Fair E6400 03/24/09 $989.00 $200.00 Excellent E6520 02/19/11 $759.00 $300.00 Excellent OptiPlex 745 01/15/09 $749.00 $320.00 Fair OptiPlex 745 01/15/09 $749.00 $320.00 Fair Vostro 230 03/23/10 $434.00 $200.00 Good Vostro 230 04/28/10 $434.00 $200.00 Good XPS X8300 12/05/10 $1,099.00 $300.00 Excellent XPS X8300 02/28/10 $1,099.00 $300.00 Excellent Vostro 320 02/23/11 $771.00 $320.00 Excellent Vostro 320 02/23/11 $771.00 $320.00 Excellent Vostro 320 02/23/11 $771.00 $320.00 Excellent iPhone 12/10/08 $399.00 $130.00 iPhone 02/28/10 $459.00 $150.00 iPhone 06/29/10 $599.00 $200.00 1770 01/24/09 $2,995.00 $1,200.00 T610 02/28/10 $3,995.00 $1,600.00 L7590 12/10/08 $288.00 $100.00 P4015 01/18/09 $699.00 $200.00 CP3535x 02/19/09 $1,299.00 $300.00 P4014 02/28/10 $799.00 $300.00 CP5225 02/28/10 $1,699.00 $500.00 TruScan 01/24/09 $3,295.00 $1,800.00 TruScan 03/05/10 $4,295.00 $2,200.00 PC Location Chicago, IL Chicago, IL Chicago, IL Chicago, IL Oakbrook, IL Chicago, IL Oakbrook, IL Chicago, IL Oakbrook, IL Chicago, IL Chicago, IL Oakbrook, IL Chicago, IL Chicago, IL Chicago, IL Chicago, IL Chicago, IL Oakbrook, IL Chicago, IL Chicago, IL Oakbrook, IL Chicago, IL Oakbrook, IL Chicago, IL Chicago, IL Oakbrook, IL Chicago, IL Chicago, IL Chicago, IL Oakbrook, IL Oakbrook, IL Chicago, IL Oakbrook, IL Retired Date - Description - Employee IC- Click to Add 2/28/2010 Precision T1201 E001 Precision T1501 E002 Precision Mobi W001 Precision T3501 E003 Precision T7501 E001 Precision T7501 E010 Precision Mob W002 Precision Mobi E001 Precision T5501 E011 Lattitude E4300 E002 Latitude E6400 E003 Latitude E6520 E011 2/23/2011 Optiplex 745 D E005 2/23/2011 Optiplex 745 D E006 Vostro 230 Min E006 Vostro 230 Min E005 XPS 8300 Deskt E007 XPS 8300 Deskt E011 Vostro 320 Des E012 Vostro 320 Des E007 Vostro 320 Des E008 2/28/2010 iPhone3 E001 iPhone3 E010 iPhone4 E001 Designjet plott W001 Designjet plott W002 Officejet Pro A E001 LaserJet BlackW001 Color Laserjet ! W001 LaserJet BlackW002 Color Laserjet ! W002 Wide format sc W001 Wide format sc W002 Dell PC Dell PC Dell Dell Apple Apple Apple HP HP PC Smartphone Smartphone Smartphone Plotter Plotter Printer Printer Printer Printer Printer Scanner Scanner HP HP HP HP HP Vidar Vidar All Access Obje... Search... Tables 2 Devices Users Devices X Employee IC - E001 E002 E003 E004 E005 E006 E007 E008 E009 E010 E011 E012 E013 W001 W002 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 Wenquao Li Oakbrook, IL Jo Ann Cortello Chicago, IL Chicago Workg Oakbrook, IL Oakbrook Worl