Business driven technology / Paige Baltzan, Amy Phillips, Stephen Haag.

By: Baltzan, Paige [author]
Contributor(s): Phillips, Amy (Amy L.) | Haag, Stephen | Haag, Stephen. Business driven technology
Language: English Publisher: Boston : McGraw-Hill Irwin, c2009Edition: Third editionDescription: xxxvi, 604 pages : color illustrations; 29 cmContent type: text Media type: unmediated Carrier type: volume ISBN: 9780071284783; 9780073376745 (hdbk. : alk. paper)Subject(s): Information technology -- Management | Management information systems | Information resources management | Industrial management -- Technological innovationsDDC classification: 658.4/038 LOC classification: HD30.2 | .H32 2009Online resources: Table of contents only | Contributor biographical information | Publisher description
Contents:
TABLE OF CONTENTS Preface xix About the Authors xxxvii UNIT 1 Achieving Business Success Through Information Technology 1 Apple?Merging Technology, Business, and Entertainment 2 Introduction 6 CHAPTER 1: BUSINESS DRIVEN TECHNOLOGY 7 Information Technology?s Role in Business 7 Information Technology?s Impact on Business Operations 7 Information Technology Basics 8 Information 9 IT Resources 9 IT Cultures 10 Chapter 1 Case: The World Is Flat?Thomas Friedman 12 >> Plug-In Pointers: B1, B2, B3, B4, B5, T1 13?14 CHAPTER 2: IDENTIFYING COMPETITIVE ADVANTAGES 15 Identifying Competitive Advantages 15 The Five Forces Model?Evaluating Business Segments 15 Buyer Power 16 Supplier Power 16 Threat of Substitute Products or Services 17 Threat of New Entrants 17 Rivalry among Existing Competitors 18 The Three Generic Strategies?Creating a Business Focus 18 Value Chain Analysis?Targeting Business Processes 18 Value Creation 19 Chapter 2 Case: Say ?Charge It? with Your Cell Phone 21 CHAPTER 3: STRATEGIC INITIATIVES FOR IMPLEMENTING COMPETITIVE ADVANTAGES 23 Strategic Initiatives 23 Supply Chain Management 23 Customer Relationship Management 25 CRM Strategy 26 Business Process Reengineering 27 Finding Opportunity Using BPR 27 Pitfalls of BPR 28 Enterprise Resource Planning 28 ERP Software 29 Finding the Right ERP Solution 29 Chapter 3 Case: Consolidating Touchpoints for Saab 31 >> Plug-In Pointer: T2 31 CHAPTER 4: MEASURING THE SUCCESS OF STRATEGIC INITIATIVES 32 Measuring Information Technology?s Success 32 Efficiency and Effectiveness 32 Benchmarking?Baseline Metrics 33 The Interrelationships of Efficiency and Effectiveness IT Metrics 33 Determining IT Efficiency and Effectiveness 35 Web Traffic Analysis 36 Chapter 4 Case: How Do You Value Friendster? 38 CHAPTER 5: ORGANIZATIONAL STRUCTURES THAT SUPPORT STRATEGIC INITIATIVES 40 Organizational Structures 40 IT Roles and Responsibilities 40 The Gap Between Business Personnel and IT Personnel 42 Improving Communications 42 Organizational Fundamentals?Ethics and Security 42 Ethics 43 Security 44 Chapter 5 Case: Executive Dilemmas in the Information Age 46 >> Plug-In Pointers: B5, B6 47 Unit Summary 48 Key Terms 48 Unit Closing Case One: How Levi?s Jeans Got into Wal-Mart 49 Unit Closing Case Two: Delta Airlines Plays Catch-Up 51 Making Business Decisions 54 UNIT 2 Managing Information for Business Initiatives 56 It Takes a Village to Write an Encyclopedia 57 CHAPTER 6: VALUING ORGANIZATIONAL INFORMATION 60 Organizational Information 60 The Value of Transactional and Analytical Information 61 The Value of Timely Information 62 The Value of Quality Information 63 Understanding the Costs of Poor Information 64 Understanding the Benefits of Good Information 65 Chapter 6 Case: Fishing for Quality 66 CHAPTER 7: STORING ORGANIZATIONAL INFORMATION?DATABASES 67 Storing Organizational Information 67 Relational Database Fundamentals 67 Entities, Entity Classes, and Attributes 68 Keys and Relationships 68 Relational Database Advantages 68 Increased Flexibility 70 Increased Scalability and Performance 70 Reduced Information Redundancy 70 Increased Information Integrity (Quality) 71 Increased Information Security 71 Database Management Systems 71 Data Definition Component 72 Data Manipulation Component 73 Application Generation and Data Administration Components 74 Integrating Information among Multiple Databases 76 Chapter 7 Case: Hotcourses Increases Revenues by 60 Percent 78 >> Technology Plug-In Pointers: T5, T6 79 CHAPTER 8: ACCESSING ORGANIZATIONAL INFORMATION?DATA WAREHOUSE 80 Accessing Organizational Information 80 History of Data Warehousing 80 Data Warehouse Fundamentals 81 Multidimensional Analysis and Data Mining 82 Information Cleansing or Scrubbing 83 Business Intelligence 86 Enabling Business Intelligence 86 Chapter 8 Case: Mining the Data Warehouse 87 >> Technology Plug-In Pointers: T3, T7 88 Unit Summary 89 Key Terms 89 Unit Closing Case One: Harrah?s?Gambling Big on Technology 90 Unit Closing Case Two: Searching for Revenue?Google 92 Making Business Decisions 95 UNIT 3 Enhancing Business Decisions 98 Gearing Up at REI 99 Introduction 102 CHAPTER 9: ENABLING THE ORGANIZATION?DECISION MAKING 103 Decision Making 103 Transaction Processing Systems 104 Decision Support Systems 105 Executive Information Systems 107 Digital Dashboards 108 Artificial Intelligence (AI) 109 Expert Systems 110 Neural Networks 111 Genetic Algorithms 111 Intelligent Agents 112 Data Mining 112 Cluster Analysis 112 Association Detection 113 Statistical Analysis 113 Chapter 9 Case: Defense Advanced Research Projects Agency (DARPA) Grand Challenge 115 >> Technology Plug-In Pointers: T4, T8 116 CHAPTER 10: EXTENDING THE ORGANIZATION?SUPPLY CHAIN MANAGEMENT 117 Supply Chain Management 117 Basics of Supply Chain 117 Information Technology?s Role in the Supply Chain 118 Visibility 120 Consumer Behavior 121 Competition 121 Speed 122 Supply Chain Management Success Factors 122 Make the Sale to Suppliers 123 Wean Employees off Traditional Business Practices 123 Ensure the SCM System Supports the Organizational Goals 123 Deploy in Incremental Phases and Measure and Communicate Success 124 Be Future Oriented 124 SCM Success Stories 124 Chapter 10 Case: BudNet 125 >> Business Plug-In Pointer: B8 126 CHAPTER 11: BUILDING A CUSTOMER-CENTRIC ORGANIZATION?CUSTOMER RELATIONSHIP MANAGEMENT 127 Customer Relationship Management (CRM) 127 Customer Relationship Management?s Explosive Growth 128 Using Analytical CRM to Enhance Decisions 129 Customer Relationship Management Success Factors 130 Chapter 11 Case: The Ritz-Carlton?Specializing in Customers 132 >> Plug-In Pointer: B9 133 CHAPTER 12: INTEGRATING THE ORGANIZATION FROM END TO END?ENTERPRISE RESOURCE PLANNING 134 Enterprise Resource Planning (ERP) 134 Enterprise Resource Planning?s Explosive Growth 136 The Connected Corporation 136 Integrating SCM, CRM, and ERP 138 Chapter 12 Case: Hilton Purchases New Suite 140 >> Plug-In Pointer: B10 141 Unit Summary 142 Key Terms 142 Unit Closing Case One: Dell?s Famous Supply Chain 143 Unit Closing Case Two: Revving Up Sales at Harley-Davidson 145 Making Business Decisions 147 UNIT 4 Creating Collaborative Partnerships in Business 150 EBay?The Ultimate E-Business 151 Introduction 154 CHAPTER 13: CREATING INNOVATIVE ORGANIZATIONS 155 Disruptive Technology 155 Disruptive versus Sustaining Technology 155 The Internet?Business Disruption 157 Evolution of the Internet 157 Evolution of the World Wide Web 158 Chapter 13 Case: Direct Groceries 160 >> Plug-In Pointers: T9, T10 161 CHAPTER 14: E-BUSINESS 162 E-Business 162 E-Business Models 162 Business-to-Business (B2B) 163 Business-to-Consumer (B2C) 164 Consumer-to-Business (C2B) 165 Consumer-to-Consumer (C2C) 165 E-Business Benefits and Challenges 165 Chapter 14 Case: 7-Eleven?s Dream Team 168 >> Plug-In Pointer: B11 168 CHAPTER 15: CREATING COLLABORATIVE PARTNERSHIPS 169 Teams, Partnerships, and Alliances 169 Collaboration Systems 170 Knowledge Management 172 KM in Business 175 Knowledge Management Systems 173 Explicit and Tacit Knowledge 173 KM Technologies 175 KM and Social Networking 175 Content Management Systems 176 Workflow Management Systems 176 Groupware Systems 179 Collaboration Trends 180 Chapter 15 Case: Dreamworks Animation Collaboration 181 CHAPTER 16: INTEGRATING WIRELESS TECHNOLOGY IN BUSINESS 183 Wireless Fidelity (Wi-Fi) 183 Business Drivers for Wireless Technologies 183 Advantages of Enterprise Mobility 184 Bluetooth 185 Radio Frequency Identification (RFID) 186 Satellite 188 Global Positioning System (GPS) 188 The Future of Wireless 189 Chapter 16 Case: UPS versus FedEx: Head-to-Head on Wireless 190 >> Plug-In Pointer: B12 191 Unit Summary 192 Key Terms 192 Unit Closing Case One: Improving Highway Safety Through Collaboration 193 Unit Closing Case Two: Amazon.com?Not Your Average Bookstore 195 Making Business Decisions 196 UNIT 5 Transforming Organizations 198 The Digital Hospital 199 Introduction 201 CHAPTER 17: BUILDING SOFTWARE TO SUPPORT AN AGILE ORGANIZATION 202 Systems Development 202 Developing Software?The Systems Development Life Cycle (SDLC) 203 Software Development Methodologies 204 Waterfall Methodology 205 Rapid Application Development Methodology (RAD) 206 Extreme Programming Methodology 206 Agile Methodology 207 Developing Successful Software 208 Slash the Budget 208 If It Doesn?t Work, Kill It 208 Keep Requirements to a Minimum 208 Test and Deliver Frequently 208 Assign Non-IT Executives to Software Projects 209 Project Managing the Systems Development Effort 209 Chapter 17 Case: Transforming the Entertainment Industry?Netflix 211 >> Plug-In Pointers: B14, B15 213 CHAPTER 18: OUTSOURCING IN THE 21ST CENTURY 214 Outsourcing Development 214 Insourcing 214 Outsourcing 215 Financial Savings 215 Increased Technical Abilities 215 Market Agility 216 Developing Strategic Outsourcing Partnerships Sourcing?s New Surge?Offshoring 217 Chapter 18 Case: UPS in the Computer Repair Business 218 >> Plug-In Pointer: B13 219 CHAPTER 19: DEVELOPING A 21ST CENTURY ORGANIZATION 220 Developing Organizations 220 21st Century Organization Trends 220 Increased Focus on IT Infrastructure 220 Increased Focus on Security 221 Increased Focus on E-Business 223 Increased Focus on Integration 223 Chapter 19 Case: Creating a Clearer Picture for Public Broadcasting Service (PBS) 225 Unit Summary 227 Key Terms 227 Unit Closing Case One: RFID?Future Tracking 228 Unit Closing Case Two: Masters of Innovation, Technology, and Strategic Vision 229 Making Business Decisions 232 >> Plug-In B1 Business Basics 236 Introduction 236 Types of Business 236 Sole Proprietorship 237 Partnership 237 Corporation 237 Internal Operations of a Corporation 239 Accounting 239 Financial Statements 240 Finance 242 Financial Analysis 242 Human Resources 242 Management Techniques 243 Sales 244 The Sales Process 244 Market Share 245 Marketing 246 Marketing Mix 247 Customer Segmentation 248 The Product Life Cycle 248 Operations/Production 248 Business Process Reengineering 248 Transforming Corporations 249 Management Information Systems 250 Plug-In Summary 252 Key Terms 253 Closing Case One: Battle of the Toys?FAO Schwarz Is Back! 253 Closing Case Two: Innovative Business Managers 255 Making Business Decisions 257 >> Plug-In B2 Business Process 258 Introduction 258 Examining Business Processes 258 Understanding the Importance of Business Processes 259 Business Process Improvement 262 Business Process Reengineering 263 Business Process Design 263 Selecting a Process to Reengineer 266 Business Process Management (BPM) 267 Is BPM for Business or IT? 267 BPM Tools 268 BPM Risks and Rewards 268 Critical Success Factors 269 Business Process Modeling Examples 270 Plug-In Summary 273 Key Terms 273 Closing Case One: Streamlining Processes at Adidas 273 Closing Case Two: 3Com Optimizes Product Promotion Processes 274 Making Business Decisions 276 >> Plug-In B3 Hardware and Software 278 Introduction 278 Hardware Basics 278 Central Processing Unit 279 Primary Storage 281 Read Only Memory (ROM) 282 Secondary Storage 282 Input Devices 284 Output Devices 284 Communication Devices 286 Computer Categories 286 Software Basics 289 System Software 289 Application Software 290 Plug-In Summary 292 Key Terms 292 Closing Case One: Changing Circuits at Circuit City 292 Closing Case Two: Electronic Breaking Points 294 Making Business Decisions 296 >> Plug-In B4 Enterprise Architectures 298 Enterprise Architectures 298 Information Architecture 299 Backup and Recover 300 Disaster Recovery 300 Information Security 302 Infrastructure Architecture 303 Flexibility 303 Scalability 304 Reliability 304 Availability 304 Performance 305 Application Architecture 305 Web Services 305 Open Systems 307 Plug-In Summary 308 Key Terms 308 Closing Case One: Chicago Tribune?s Server Consolidation a Success 308 Closing Case Two: Fear the Penguin 309 Making Business Decisions 311 >> Plug-In B5 Networks and Telecommunications 314 Networks and Telecommunications 314 Network Basics 314 Architecture 316 Peer-to-Peer Networks 316 Client/Server Networks 316 Topology 317 Protocols 317 Ethernet 318 Transmission Control Protocol/Internet Protocol 318 Media 322 Wire Media 322 Wireless Media 323 E-Business Networks 323 Plug-In Summary 326 Key Terms 326 Closing Case One: Watching Where You Step?Prada 326 Closing Case Two: Banks Banking on Network Security 328 Making Business Decisions 329 >> Plug-In B6 Information Security 330 Introduction 330 The First Line of Defense?People 330 The Second Line of Defense?Technology 332 Authentication and Authorization 334 Prevention and Resistance 335 Detection and Response 337 Plug-In Summary 340 Key Terms 340 Closing Case One: Thinking Like the Enemy 340 Closing Case Two: Hacker Hunters 341 Making Business Decisions 343 >> Plug-In B7 Ethics 344 Introduction 344 Ethics 345 Information Has No Ethics 346 Developing Information Management Policies 348 Ethical Computer Use Policy 348 Information Privacy Policy 349 Acceptable Use Policy 350 E-mail Privacy Policy 350 Internet Use Policy 351 Anti-spam Policy 351 Ethics in the Workplace 352 Monitoring Technologies 353 Plug-In Summary 355 Key Terms 355 Closing Case One: Sarbanes-Oxley: Where Information Technology, Finance, and Ethics Meet 356 Closing Case Two: Invading Your Privacy 357 Making Business Decisions 358 >> Plug-In B8 Supply Chain Management 360 Introduction 360 Supply Chain Drivers 360 Facilities Driver 361 Inventory Driver 362 Transportation Driver 363 Information Driver 364 Applying a Supply Chain Design 365 Future Trends 367 Plug-In Summary 369 Key Terms 369 Closing Case One: Listerine?s Journey 369 Closing Case Two: Katrina Shakes Supply Chains 371 Making Business Decisions 373 >> Plug-In B9 Customer Relationship Management 376 Introduction 376 The Evolution of CRM 377 Using IT to Drive Operational CRM 378 Marketing and Operational CRM 378 Sales and Operational CRM 379 Customer Service and Operational CRM 382 Analytical CRM 384 Current Trends: SRM, PRM, and ERM 386 Supplier Relationship Management 386 Partner Relationship Management 386 Employee Relationship Management 387 Future Trends 387 Plug-In Summary 388 Key Terms 388 Closing Case One: Fighting Cancer with Information 389 Closing Case Two: Calling All Canadians 390 Making Business Decisions 391 >> Plug-In B10 Enterprise Resource Planning 394 Introduction 394 Core and Extended ERP Components 394 Core ERP Components 396 Extended ERP Components 397 ERP Benefits and Risks (Costs) 398 The Future of ERP 399 Internet 401 Interface 401 Wireless Technology 401 Plug-In Summary 402 Key Terms 402 Closing Case One: PepsiAmericas? Enterprises 402 Closing Case Two: Campus ERP 403 Making Business Decisions 405 >> Plug-In B11 E-Business 408 Introduction 408 Accessing Internet Information 408 Intranet 409 Extranet 409 Portal 409 Kiosk 410 Providing Internet Information 410 Internet Service Provider 410 Online Service Provider 411 Application Service Provider 412 Organizational Strategies for E-Business 412 Marketing/Sales 412 Financial Services 415 Procurement 416 Customer Service 417 Intermediaries 417 Measuring E-Business Success 419 Web Site Metrics 419 New Trends in E-Business: E-Government and M-Commerce 422 M-Commerce 422 Plug-In Summary 425 Key Terms 425 Closing Case One: Mail with PostalOne 425 Closing Case Two: Made-to-Order Businesses 427 Making Business Decisions 428 >> Plug-In B12 Emerging Trends and Technologies 430 Introduction 430 Reasons to Watch Trends 430 Trends Shaping Our Future 431 The World?s Population Will Double in the Next 40 Years 431 People in Developed Countries Are Living Longer 432 The Growth in Information Industries Is Creating a Knowledge-Dependent Global Society 432 The Global Economy Is Becoming More Integrated 433 The Economy and Society Are Dominated by Technology 434 Pace of Technological Innovation Is Increasing 434 Time Is Becoming One of the World?s Most Precious Commodities 434 Technologies Shaping Our Future 435 Digital Ink 435 Digital Paper 435 Teleliving 437 Alternative Energy Sources 438 Autonomic Computing 438 Plug-In Summary 440 Key Terms 440 Closing Case One: Autonomic Railways 440 Closing Case Two: Wireless Progression 441 Making Business Decisions 442 >> Plug-In B13 Strategic Outsourcing 444 Introduction 444 The Outsourcing Phenomenon 444 Outsourcing Benefits 446 Outsourcing Options 446 Offshore Outsourcing 447 The Challenges of Outsourcing 453 Future Trends 455 Multisourcing 455 Plug-In Summary 456 Key Terms 456 Closing Case One: Mobil Travel Guide 456 Closing Case Two: Outsourcing Brew 457 Making Business Decisions 458 >> Plug-In B14 Systems Development 460 Introduction 460 Systems Development Life Cycle 461 Phase 1: Planning 461 Phase 2: Analysis 463 Phase 3: Design 466 Phase 4: Development 468 Phase 5: Testing 468 Phase 6: Implementation 469 Phase 7: Maintenance 471 Software Problems Are Business Problems 471 Unclear or Missing Business Requirements 472 Skipping SDLC Phases 472 Failure to Manage Project Scope 472 Failure to Manage Project Plan 473 Changing Technology 473 Plug-In Summary 474 Key Terms 474 Closing Case One: Disaster at Denver International Airport 475 Closing Case Two: Reducing Ambiguity in Business Requirements 475 Making Business Decisions 477 >> Plug-In B15 Project Management 478 Introduction 478 Project Management Fundamentals 478 Choosing Strategic Projects 479 Setting the Project Scope 480 Managing Resources and Maintaining the Project Plan 481 Change Management and Risk Management 481 Change Management 482 Preparing for Change 483 Risk Management 484 Mitigating Risk 485 Successful Project Management Strategies 486 Plug-In Summary 487 Key Terms 487 Closing Case One: Staying on Track?Toronto Transit 487 Closing Case Two: Change at Toyota 488 Making Business Decisions 490 >> PLUG-IN T1 ON CD Personal Productivity Using IT Introduction Creating Strong Passwords Create Strong Passwords That You Can Remember Keep Your Passwords a Secret Manage Your Passwords Monitor Your Accounts Performing Good File Management Implementing Effective Backup and Recovery Strategies Determining What to Back Up How to Back Up Your Computer Files Microsoft?s Backup and Recover Utility Using Zip Files To Create a Zipped Compressed Folder To Add Files to a Zipped Compressed Folder To Extract Files from a Zipped Compressed Folder To Open a Zipped Compressed Folder Writing Professional E-Mails Netiquette 101 Stopping Spam How Do Spammers Get E-Mail Addresses? How to Handle Spam Preventing Phishing What Is Phishing? How Does Phishing Work? What Does a Phishing Scam Look Like? Help Prevent Identity Theft from Phishing Scams Detecting Spyware Preventing Spyware How to Get Rid of Spyware Restricting Instant Messages Increasing PC Performance Free Disk Space Speed Up Access to Data Detect and Repair Disk Errors Using Anti-Virus Software Anti-Virus Software Cell Phone Viruses Installing a Personal Firewall To Open Windows Firewall Plug-In Summary Making Business Decisions >> PLUG-IN T2 Basic Skills Using Excel 492 Introduction 492 Workbooks and Worksheets 494 Creating Workbooks Using Templates 495 Saving a Workbook 495 Inserting and Deleting Worksheets 496 Working with Cells and Cell Data 497 Inserting and Deleting Cells 497 Merging and Splitting Cells 497 Cutting, Copying, and Pasting Cells 498 Entering Text in Cells 498 Applying Number Formats 498 Applying Styles 499 Printing Worksheets 499 Setting Up the Page for Printing 499 Setting Margins for Printing 500 Previewing a Print Area 501 Printing Selections, Worksheets, and Workbooks 501 Formatting Worksheets 502 Inserting Rows and Columns 502 Deleting Rows and Columns 502 Modifying Row Heights 502 Modifying Column Widths 504 Formulas 505 Entering Formulas 505 Using the Formula Bar 505 Using Absolute and Relative References 506 Using the Sum Function 506 Using the Min and Max Functions 507 Using the Date or NOW Function 507 Working with Charts and Graphics 508 Creating a Chart Using the Chart Wizard 508 Modifying Charts 509 Moving a Chart 509 Adding Graphics 510 Plug-In Summary 511 Making Business Decisions 511 >> PLUG-IN T3 ON CD Problem Solving Using Excel Introduction Lists Sorting Rows and Columns Sorting More Than One Column Creating Your Own Custom Sort Order Creating Conditional Formatting Using AutoFilter to Find Records Creating a Custom AutoFilter Analyzing a List with the Subtotals Command PivotTables PivotTable Terminology Building a PivotTable Modifying a PivotTable View PivotTable Tools Building a PivotChart Plug-In Summary Making Business Decisions >> PLUG-IN T4 ON CD Decision Making Using Excel Introduction Creating Formulas Using the IF Function Goal Seek Using the Goal Seek Command Solver Installing Solver Setting Up the Problem Editing a Solver Forecast Scenario Manager Setting Up Scenarios Modifying a Scenario Creating a Scenario Summary Report Plug-In Summary Making Business Decisions >> PLUG-IN T5 ON CD Designing Database Applications Introduction Entities and Data Relationships Entities and Their Attributes Attributes Documenting Logical Data Relationships Basic Data Relationships Relationship Connectivity and Cardinality Dealing with Many-to-Many Relationships Schemas The Relational Data Model Understanding Relations Representing Data Relationships Relationships and Business Rules Normalization Normal Forms Normalized Relations and Database Performance Plug-In Summary Making Business Decisions >> PLUG-IN T6 Basic Skills and Tools Using Access 514 Introduction to Access 514 Creating a New Blank Database 516 Opening an Existing Database 517 Using the Database Wizard 517 Using the Database Window and Object Views 518 Using Table Views 519 Creating and Modifying Tables 519 Creating a Table with the Table Design Wizard 519 Creating a Table Using Data Entry 520 Creating a Table in Design View 520 Changing Data Types 522 Using the Input Mask Wizard 522 Using the Format Property 524 Defining Relationships 524 Using the Relationships Window 525 Plug-In Summary 527 Making Business Decisions 527 >> PLUG-IN T7 ON CD Problem Solving Using Access Introduction to Queries Creating Simple Queries Reordering Columns in the Select Query Datasheet Creating a Select Query in Design View Adding Selection Criteria to a Select Query Sorting Data in a Select Query Advanced Queries Using the Expression Builder Using Aggregate Functions to Calculate Totals in Queries Formatting Results Displayed in a Calculated Field Creating and Running Queries to Modify Data Plug-In Summary Making Business Decisions >> PLUG-IN T8 ON CD Decision Making Using Access Introduction Forms Creating a Form Using the Form Wizard Creating and Saving AutoForms Modifying the Properties of a Form Modifying Specific Controls on a Form Aligning Controls in a Form Reports Using the Report Wizard Modifying the Report Design Changing Margins and Page Orientation for Reports Plug-In Summary Making Business Decisions >> PLUG-IN T9 ON CD Designing Web Pages Introduction The World Wide Web The Web Is Media Rich The Web Is Interactive Web Pages Can Be Designed The Web Is Nonlinear The Web Has No Control Designing for the Unknown The Process of Web Design Analyze and Plan Create and Organize Content Develop the Look and Feel Produce Graphics and HTML Documents Creating a Working Prototype Test, Test, Test Upload to a Web Server and Test Again Maintain HTML Basics Viewing the Source HTML 101 Types of Tags The Anatomy of a Tag Basic Fonts Web Graphics Graphic Formats Limited Color Palettes Pixels, Not Inches Tools of the Trade Plug-In Summary Making Business Decisions >> PLUG-IN T10 ON CD Basic Skills Using FrontPage Introduction Web Sites, Web Pages, and HTML FrontPage Builds Web Sites Big and Small Navigation in FrontPage Understanding the Interface FrontPage Views Building a Web Site Starting FrontPage Creating a Web Site with Templates Creating a Web Site with a Wizard Creating an Empty Web Site Saving a Web Site Building a Web Page Creating a Web Page from a Template Creating a Blank Web Page Entering Text on a Web Page Formatting Text Paragraphs Working with Graphics Using Ruled Lines Putting Your Own Images on a Web Page Including Hyperlinks Creating a Hyperlink Creating a Link to an E-Mail Address Presenting Information in Lists and Tables Working with Lists Working with Tables Working with Rows and Columns Working with Cells Formatting Pages Setting Page Properties Themes Plug-In Summary Making Business Decisions Apply Your Knowledge Projects 530 Glossary 570 Notes 583 Illustration Credits 590 INDEX 592
Tags from this library: No tags from this library for this title. Log in to add tags.
    Average rating: 0.0 (0 votes)
Item type Current location Home library Call number Copy number Status Date due Barcode Item holds
BOOK BOOK COLLEGE LIBRARY
COLLEGE LIBRARY
SUBJECT REFERENCE
658.4038 B218 2009 (Browse shelf) c.1 Available CITU-CL-39762
BOOK BOOK COLLEGE LIBRARY
COLLEGE LIBRARY
SUBJECT REFERENCE
658.4038 B218 2009 (Browse shelf) c.2 Available CITU-CL-43088
Total holds: 0

Rev. ed. of: Business driven technology / Stephen Haag, Paige Baltzan, Amy Phillips. 2nd ed. c2008.

Includes bibliographical references (p. 573-583) and index.

TABLE OF CONTENTS
Preface xix
About the Authors xxxvii
UNIT 1
Achieving Business Success Through Information Technology 1
Apple?Merging Technology, Business, and Entertainment 2
Introduction 6
CHAPTER 1: BUSINESS DRIVEN TECHNOLOGY 7
Information Technology?s Role in Business 7
Information Technology?s Impact on Business Operations 7
Information Technology Basics 8
Information 9
IT Resources 9
IT Cultures 10
Chapter 1 Case: The World Is Flat?Thomas Friedman 12
>> Plug-In Pointers: B1, B2, B3, B4, B5, T1 13?14
CHAPTER 2: IDENTIFYING COMPETITIVE ADVANTAGES 15
Identifying Competitive Advantages 15
The Five Forces Model?Evaluating Business Segments 15
Buyer Power 16
Supplier Power 16
Threat of Substitute Products or Services 17
Threat of New Entrants 17
Rivalry among Existing Competitors 18
The Three Generic Strategies?Creating a Business Focus 18
Value Chain Analysis?Targeting Business Processes 18
Value Creation 19
Chapter 2 Case: Say ?Charge It? with Your Cell Phone 21
CHAPTER 3: STRATEGIC INITIATIVES FOR IMPLEMENTING COMPETITIVE ADVANTAGES 23
Strategic Initiatives 23
Supply Chain Management 23
Customer Relationship Management 25
CRM Strategy 26
Business Process Reengineering 27
Finding Opportunity Using BPR 27
Pitfalls of BPR 28
Enterprise Resource Planning 28
ERP Software 29
Finding the Right ERP Solution 29
Chapter 3 Case: Consolidating Touchpoints for Saab 31
>> Plug-In Pointer: T2 31
CHAPTER 4: MEASURING THE SUCCESS OF STRATEGIC INITIATIVES 32
Measuring Information Technology?s Success 32
Efficiency and Effectiveness 32
Benchmarking?Baseline Metrics 33
The Interrelationships of Efficiency and Effectiveness IT Metrics 33
Determining IT Efficiency and Effectiveness 35
Web Traffic Analysis 36
Chapter 4 Case: How Do You Value Friendster? 38
CHAPTER 5: ORGANIZATIONAL STRUCTURES THAT SUPPORT STRATEGIC INITIATIVES 40
Organizational Structures 40
IT Roles and Responsibilities 40
The Gap Between Business Personnel and IT Personnel 42
Improving Communications 42
Organizational Fundamentals?Ethics and Security 42
Ethics 43
Security 44
Chapter 5 Case: Executive Dilemmas in the Information Age 46
>> Plug-In Pointers: B5, B6 47
Unit Summary 48
Key Terms 48
Unit Closing Case One: How Levi?s Jeans Got into Wal-Mart 49
Unit Closing Case Two: Delta Airlines Plays Catch-Up 51
Making Business Decisions 54
UNIT 2
Managing Information for Business Initiatives 56
It Takes a Village to Write an Encyclopedia 57
CHAPTER 6: VALUING ORGANIZATIONAL INFORMATION 60
Organizational Information 60
The Value of Transactional and Analytical Information 61
The Value of Timely Information 62
The Value of Quality Information 63
Understanding the Costs of Poor Information 64
Understanding the Benefits of Good Information 65
Chapter 6 Case: Fishing for Quality 66
CHAPTER 7: STORING ORGANIZATIONAL INFORMATION?DATABASES 67
Storing Organizational Information 67
Relational Database Fundamentals 67
Entities, Entity Classes, and Attributes 68
Keys and Relationships 68
Relational Database Advantages 68
Increased Flexibility 70
Increased Scalability and Performance 70
Reduced Information Redundancy 70
Increased Information Integrity (Quality) 71
Increased Information Security 71
Database Management Systems 71
Data Definition Component 72
Data Manipulation Component 73
Application Generation and Data Administration Components 74
Integrating Information among Multiple Databases 76
Chapter 7 Case: Hotcourses Increases Revenues by 60 Percent 78
>> Technology Plug-In Pointers: T5, T6 79
CHAPTER 8: ACCESSING ORGANIZATIONAL INFORMATION?DATA WAREHOUSE 80
Accessing Organizational Information 80
History of Data Warehousing 80
Data Warehouse Fundamentals 81
Multidimensional Analysis and Data Mining 82
Information Cleansing or Scrubbing 83
Business Intelligence 86
Enabling Business Intelligence 86
Chapter 8 Case: Mining the Data Warehouse 87
>> Technology Plug-In Pointers: T3, T7 88
Unit Summary 89
Key Terms 89
Unit Closing Case One: Harrah?s?Gambling Big on Technology 90
Unit Closing Case Two: Searching for Revenue?Google 92
Making Business Decisions 95
UNIT 3
Enhancing Business Decisions 98
Gearing Up at REI 99
Introduction 102
CHAPTER 9: ENABLING THE ORGANIZATION?DECISION MAKING 103
Decision Making 103
Transaction Processing Systems 104
Decision Support Systems 105
Executive Information Systems 107
Digital Dashboards 108
Artificial Intelligence (AI) 109
Expert Systems 110
Neural Networks 111
Genetic Algorithms 111
Intelligent Agents 112
Data Mining 112
Cluster Analysis 112
Association Detection 113
Statistical Analysis 113
Chapter 9 Case: Defense Advanced Research Projects Agency (DARPA) Grand
Challenge 115
>> Technology Plug-In Pointers: T4, T8 116
CHAPTER 10: EXTENDING THE ORGANIZATION?SUPPLY CHAIN MANAGEMENT 117
Supply Chain Management 117
Basics of Supply Chain 117
Information Technology?s Role in the Supply Chain 118
Visibility 120
Consumer Behavior 121
Competition 121
Speed 122
Supply Chain Management Success Factors 122
Make the Sale to Suppliers 123
Wean Employees off Traditional Business Practices 123
Ensure the SCM System Supports the Organizational Goals 123
Deploy in Incremental Phases and Measure and Communicate Success 124
Be Future Oriented 124
SCM Success Stories 124
Chapter 10 Case: BudNet 125
>> Business Plug-In Pointer: B8 126
CHAPTER 11: BUILDING A CUSTOMER-CENTRIC ORGANIZATION?CUSTOMER RELATIONSHIP
MANAGEMENT 127
Customer Relationship Management (CRM) 127
Customer Relationship Management?s Explosive Growth 128
Using Analytical CRM to Enhance Decisions 129
Customer Relationship Management Success Factors 130
Chapter 11 Case: The Ritz-Carlton?Specializing in Customers 132
>> Plug-In Pointer: B9 133
CHAPTER 12: INTEGRATING THE ORGANIZATION FROM END TO END?ENTERPRISE
RESOURCE PLANNING 134
Enterprise Resource Planning (ERP) 134
Enterprise Resource Planning?s Explosive Growth 136
The Connected Corporation 136
Integrating SCM, CRM, and ERP 138
Chapter 12 Case: Hilton Purchases New Suite 140
>> Plug-In Pointer: B10 141
Unit Summary 142
Key Terms 142
Unit Closing Case One: Dell?s Famous Supply Chain 143
Unit Closing Case Two: Revving Up Sales at Harley-Davidson 145
Making Business Decisions 147
UNIT 4
Creating Collaborative Partnerships in Business 150
EBay?The Ultimate E-Business 151
Introduction 154
CHAPTER 13: CREATING INNOVATIVE ORGANIZATIONS 155
Disruptive Technology 155
Disruptive versus Sustaining Technology 155
The Internet?Business Disruption 157
Evolution of the Internet 157
Evolution of the World Wide Web 158
Chapter 13 Case: Direct Groceries 160
>> Plug-In Pointers: T9, T10 161
CHAPTER 14: E-BUSINESS 162
E-Business 162
E-Business Models 162
Business-to-Business (B2B) 163
Business-to-Consumer (B2C) 164
Consumer-to-Business (C2B) 165
Consumer-to-Consumer (C2C) 165
E-Business Benefits and Challenges 165
Chapter 14 Case: 7-Eleven?s Dream Team 168
>> Plug-In Pointer: B11 168
CHAPTER 15: CREATING COLLABORATIVE PARTNERSHIPS 169
Teams, Partnerships, and Alliances 169
Collaboration Systems 170
Knowledge Management 172
KM in Business 175
Knowledge Management Systems 173
Explicit and Tacit Knowledge 173
KM Technologies 175
KM and Social Networking 175
Content Management Systems 176
Workflow Management Systems 176
Groupware Systems 179
Collaboration Trends 180
Chapter 15 Case: Dreamworks Animation Collaboration 181
CHAPTER 16: INTEGRATING WIRELESS TECHNOLOGY IN BUSINESS 183
Wireless Fidelity (Wi-Fi) 183
Business Drivers for Wireless Technologies 183
Advantages of Enterprise Mobility 184
Bluetooth 185
Radio Frequency Identification (RFID) 186
Satellite 188
Global Positioning System (GPS) 188
The Future of Wireless 189
Chapter 16 Case: UPS versus FedEx: Head-to-Head on Wireless 190
>> Plug-In Pointer: B12 191
Unit Summary 192
Key Terms 192
Unit Closing Case One: Improving Highway Safety Through Collaboration 193
Unit Closing Case Two: Amazon.com?Not Your Average Bookstore 195
Making Business Decisions 196
UNIT 5
Transforming Organizations 198
The Digital Hospital 199
Introduction 201
CHAPTER 17: BUILDING SOFTWARE TO SUPPORT AN AGILE ORGANIZATION 202
Systems Development 202
Developing Software?The Systems Development Life Cycle (SDLC) 203
Software Development Methodologies 204
Waterfall Methodology 205
Rapid Application Development Methodology (RAD) 206
Extreme Programming Methodology 206
Agile Methodology 207
Developing Successful Software 208
Slash the Budget 208
If It Doesn?t Work, Kill It 208
Keep Requirements to a Minimum 208
Test and Deliver Frequently 208
Assign Non-IT Executives to Software Projects 209
Project Managing the Systems Development Effort 209
Chapter 17 Case: Transforming the Entertainment Industry?Netflix 211
>> Plug-In Pointers: B14, B15 213
CHAPTER 18: OUTSOURCING IN THE 21ST CENTURY 214
Outsourcing Development 214
Insourcing 214
Outsourcing 215
Financial Savings 215
Increased Technical Abilities 215
Market Agility 216
Developing Strategic Outsourcing Partnerships
Sourcing?s New Surge?Offshoring 217
Chapter 18 Case: UPS in the Computer Repair Business 218
>> Plug-In Pointer: B13 219
CHAPTER 19: DEVELOPING A 21ST CENTURY ORGANIZATION 220
Developing Organizations 220
21st Century Organization Trends 220
Increased Focus on IT Infrastructure 220
Increased Focus on Security 221
Increased Focus on E-Business 223
Increased Focus on Integration 223
Chapter 19 Case: Creating a Clearer Picture for Public Broadcasting Service
(PBS) 225
Unit Summary 227
Key Terms 227
Unit Closing Case One: RFID?Future Tracking 228
Unit Closing Case Two: Masters of Innovation, Technology, and Strategic Vision
229
Making Business Decisions 232
>> Plug-In B1
Business Basics 236
Introduction 236
Types of Business 236
Sole Proprietorship 237
Partnership 237
Corporation 237
Internal Operations of a Corporation 239
Accounting 239
Financial Statements 240
Finance 242
Financial Analysis 242
Human Resources 242
Management Techniques 243
Sales 244
The Sales Process 244
Market Share 245
Marketing 246
Marketing Mix 247
Customer Segmentation 248
The Product Life Cycle 248
Operations/Production 248
Business Process Reengineering 248
Transforming Corporations 249
Management Information Systems 250
Plug-In Summary 252
Key Terms 253
Closing Case One: Battle of the Toys?FAO Schwarz Is Back! 253
Closing Case Two: Innovative Business Managers 255
Making Business Decisions 257
>> Plug-In B2
Business Process 258
Introduction 258
Examining Business Processes 258
Understanding the Importance of Business Processes 259
Business Process Improvement 262
Business Process Reengineering 263
Business Process Design 263
Selecting a Process to Reengineer 266
Business Process Management (BPM) 267
Is BPM for Business or IT? 267
BPM Tools 268
BPM Risks and Rewards 268
Critical Success Factors 269
Business Process Modeling Examples 270
Plug-In Summary 273
Key Terms 273
Closing Case One: Streamlining Processes at Adidas 273
Closing Case Two: 3Com Optimizes Product Promotion Processes 274
Making Business Decisions 276
>> Plug-In B3
Hardware and Software 278
Introduction 278
Hardware Basics 278
Central Processing Unit 279
Primary Storage 281
Read Only Memory (ROM) 282
Secondary Storage 282
Input Devices 284
Output Devices 284
Communication Devices 286
Computer Categories 286
Software Basics 289
System Software 289
Application Software 290
Plug-In Summary 292
Key Terms 292
Closing Case One: Changing Circuits at Circuit City 292
Closing Case Two: Electronic Breaking Points 294
Making Business Decisions 296
>> Plug-In B4
Enterprise Architectures 298
Enterprise Architectures 298
Information Architecture 299
Backup and Recover 300
Disaster Recovery 300
Information Security 302
Infrastructure Architecture 303
Flexibility 303
Scalability 304
Reliability 304
Availability 304
Performance 305
Application Architecture 305
Web Services 305
Open Systems 307
Plug-In Summary 308
Key Terms 308
Closing Case One: Chicago Tribune?s Server Consolidation a Success 308
Closing Case Two: Fear the Penguin 309
Making Business Decisions 311
>> Plug-In B5
Networks and Telecommunications 314
Networks and Telecommunications 314
Network Basics 314
Architecture 316
Peer-to-Peer Networks 316
Client/Server Networks 316
Topology 317
Protocols 317
Ethernet 318
Transmission Control Protocol/Internet Protocol 318
Media 322
Wire Media 322
Wireless Media 323
E-Business Networks 323
Plug-In Summary 326
Key Terms 326
Closing Case One: Watching Where You Step?Prada 326
Closing Case Two: Banks Banking on Network Security 328
Making Business Decisions 329
>> Plug-In B6
Information Security 330
Introduction 330
The First Line of Defense?People 330
The Second Line of Defense?Technology 332
Authentication and Authorization 334
Prevention and Resistance 335
Detection and Response 337
Plug-In Summary 340
Key Terms 340
Closing Case One: Thinking Like the Enemy 340
Closing Case Two: Hacker Hunters 341
Making Business Decisions 343
>> Plug-In B7
Ethics 344
Introduction 344
Ethics 345
Information Has No Ethics 346
Developing Information Management Policies 348
Ethical Computer Use Policy 348
Information Privacy Policy 349
Acceptable Use Policy 350
E-mail Privacy Policy 350
Internet Use Policy 351
Anti-spam Policy 351
Ethics in the Workplace 352
Monitoring Technologies 353
Plug-In Summary 355
Key Terms 355
Closing Case One: Sarbanes-Oxley: Where Information Technology, Finance, and
Ethics Meet 356
Closing Case Two: Invading Your Privacy 357
Making Business Decisions 358
>> Plug-In B8
Supply Chain Management 360
Introduction 360
Supply Chain Drivers 360
Facilities Driver 361
Inventory Driver 362
Transportation Driver 363
Information Driver 364
Applying a Supply Chain Design 365
Future Trends 367
Plug-In Summary 369
Key Terms 369
Closing Case One: Listerine?s Journey 369
Closing Case Two: Katrina Shakes Supply Chains 371
Making Business Decisions 373
>> Plug-In B9
Customer Relationship Management 376
Introduction 376
The Evolution of CRM 377
Using IT to Drive Operational CRM 378
Marketing and Operational CRM 378
Sales and Operational CRM 379
Customer Service and Operational CRM 382
Analytical CRM 384
Current Trends: SRM, PRM, and ERM 386
Supplier Relationship Management 386
Partner Relationship Management 386
Employee Relationship Management 387
Future Trends 387
Plug-In Summary 388
Key Terms 388
Closing Case One: Fighting Cancer with Information 389
Closing Case Two: Calling All Canadians 390
Making Business Decisions 391
>> Plug-In B10
Enterprise Resource Planning 394
Introduction 394
Core and Extended ERP Components 394
Core ERP Components 396
Extended ERP Components 397
ERP Benefits and Risks (Costs) 398
The Future of ERP 399
Internet 401
Interface 401
Wireless Technology 401
Plug-In Summary 402
Key Terms 402
Closing Case One: PepsiAmericas? Enterprises 402
Closing Case Two: Campus ERP 403
Making Business Decisions 405
>> Plug-In B11
E-Business 408
Introduction 408
Accessing Internet Information 408
Intranet 409
Extranet 409
Portal 409
Kiosk 410
Providing Internet Information 410
Internet Service Provider 410
Online Service Provider 411
Application Service Provider 412
Organizational Strategies for E-Business 412
Marketing/Sales 412
Financial Services 415
Procurement 416
Customer Service 417
Intermediaries 417
Measuring E-Business Success 419
Web Site Metrics 419
New Trends in E-Business: E-Government and M-Commerce 422
M-Commerce 422
Plug-In Summary 425
Key Terms 425
Closing Case One: Mail with PostalOne 425
Closing Case Two: Made-to-Order Businesses 427
Making Business Decisions 428
>> Plug-In B12
Emerging Trends and Technologies 430
Introduction 430
Reasons to Watch Trends 430
Trends Shaping Our Future 431
The World?s Population Will Double in the Next 40 Years 431
People in Developed Countries Are Living Longer 432
The Growth in Information Industries Is Creating a Knowledge-Dependent Global
Society 432
The Global Economy Is Becoming More Integrated 433
The Economy and Society Are Dominated by Technology 434
Pace of Technological Innovation Is Increasing 434
Time Is Becoming One of the World?s Most Precious Commodities 434
Technologies Shaping Our Future 435
Digital Ink 435
Digital Paper 435
Teleliving 437
Alternative Energy Sources 438
Autonomic Computing 438
Plug-In Summary 440
Key Terms 440
Closing Case One: Autonomic Railways 440
Closing Case Two: Wireless Progression 441
Making Business Decisions 442
>> Plug-In B13
Strategic Outsourcing 444
Introduction 444
The Outsourcing Phenomenon 444
Outsourcing Benefits 446
Outsourcing Options 446
Offshore Outsourcing 447
The Challenges of Outsourcing 453
Future Trends 455
Multisourcing 455
Plug-In Summary 456
Key Terms 456
Closing Case One: Mobil Travel Guide 456
Closing Case Two: Outsourcing Brew 457
Making Business Decisions 458
>> Plug-In B14
Systems Development 460
Introduction 460
Systems Development Life Cycle 461
Phase 1: Planning 461
Phase 2: Analysis 463
Phase 3: Design 466
Phase 4: Development 468
Phase 5: Testing 468
Phase 6: Implementation 469
Phase 7: Maintenance 471
Software Problems Are Business Problems 471
Unclear or Missing Business Requirements 472
Skipping SDLC Phases 472
Failure to Manage Project Scope 472
Failure to Manage Project Plan 473
Changing Technology 473
Plug-In Summary 474
Key Terms 474
Closing Case One: Disaster at Denver International Airport 475
Closing Case Two: Reducing Ambiguity in Business Requirements 475
Making Business Decisions 477
>> Plug-In B15
Project Management 478
Introduction 478
Project Management Fundamentals 478
Choosing Strategic Projects 479
Setting the Project Scope 480
Managing Resources and Maintaining the Project Plan 481
Change Management and Risk Management 481
Change Management 482
Preparing for Change 483
Risk Management 484
Mitigating Risk 485
Successful Project Management Strategies 486
Plug-In Summary 487
Key Terms 487
Closing Case One: Staying on Track?Toronto Transit 487
Closing Case Two: Change at Toyota 488
Making Business Decisions 490
>> PLUG-IN T1 ON CD
Personal Productivity Using IT
Introduction
Creating Strong Passwords
Create Strong Passwords That You Can
Remember
Keep Your Passwords a Secret
Manage Your Passwords
Monitor Your Accounts
Performing Good File Management
Implementing Effective Backup and Recovery Strategies
Determining What to Back Up
How to Back Up Your Computer Files
Microsoft?s Backup and Recover Utility
Using Zip Files
To Create a Zipped Compressed Folder
To Add Files to a Zipped Compressed Folder
To Extract Files from a Zipped Compressed Folder
To Open a Zipped Compressed Folder
Writing Professional E-Mails
Netiquette 101
Stopping Spam
How Do Spammers Get E-Mail Addresses?
How to Handle Spam
Preventing Phishing
What Is Phishing?
How Does Phishing Work?
What Does a Phishing Scam Look Like?
Help Prevent Identity Theft from Phishing Scams
Detecting Spyware
Preventing Spyware
How to Get Rid of Spyware
Restricting Instant Messages
Increasing PC Performance
Free Disk Space
Speed Up Access to Data
Detect and Repair Disk Errors
Using Anti-Virus Software
Anti-Virus Software
Cell Phone Viruses
Installing a Personal Firewall
To Open Windows Firewall
Plug-In Summary
Making Business Decisions
>> PLUG-IN T2
Basic Skills Using Excel 492
Introduction 492
Workbooks and Worksheets 494
Creating Workbooks Using Templates 495
Saving a Workbook 495
Inserting and Deleting Worksheets 496
Working with Cells and Cell Data 497
Inserting and Deleting Cells 497
Merging and Splitting Cells 497
Cutting, Copying, and Pasting Cells 498
Entering Text in Cells 498
Applying Number Formats 498
Applying Styles 499
Printing Worksheets 499
Setting Up the Page for Printing 499
Setting Margins for Printing 500
Previewing a Print Area 501
Printing Selections, Worksheets, and Workbooks 501
Formatting Worksheets 502
Inserting Rows and Columns 502
Deleting Rows and Columns 502
Modifying Row Heights 502
Modifying Column Widths 504
Formulas 505
Entering Formulas 505
Using the Formula Bar 505
Using Absolute and Relative References 506
Using the Sum Function 506
Using the Min and Max Functions 507
Using the Date or NOW Function 507
Working with Charts and Graphics 508
Creating a Chart Using the Chart Wizard 508
Modifying Charts 509
Moving a Chart 509
Adding Graphics 510
Plug-In Summary 511
Making Business Decisions 511
>> PLUG-IN T3 ON CD
Problem Solving Using Excel
Introduction
Lists
Sorting Rows and Columns
Sorting More Than One Column
Creating Your Own Custom Sort Order
Creating Conditional Formatting
Using AutoFilter to Find Records
Creating a Custom AutoFilter
Analyzing a List with the Subtotals Command
PivotTables
PivotTable Terminology
Building a PivotTable
Modifying a PivotTable View
PivotTable Tools
Building a PivotChart
Plug-In Summary
Making Business Decisions
>> PLUG-IN T4 ON CD
Decision Making Using Excel
Introduction
Creating Formulas Using the IF Function
Goal Seek
Using the Goal Seek Command
Solver
Installing Solver
Setting Up the Problem
Editing a Solver Forecast
Scenario Manager
Setting Up Scenarios
Modifying a Scenario
Creating a Scenario Summary Report
Plug-In Summary
Making Business Decisions
>> PLUG-IN T5 ON CD
Designing Database Applications
Introduction
Entities and Data Relationships
Entities and Their Attributes
Attributes
Documenting Logical Data Relationships
Basic Data Relationships
Relationship Connectivity and Cardinality
Dealing with Many-to-Many Relationships
Schemas
The Relational Data Model
Understanding Relations
Representing Data Relationships
Relationships and Business Rules
Normalization
Normal Forms
Normalized Relations and Database Performance
Plug-In Summary
Making Business Decisions
>> PLUG-IN T6
Basic Skills and Tools Using Access 514
Introduction to Access 514
Creating a New Blank Database 516
Opening an Existing Database 517
Using the Database Wizard 517
Using the Database Window and Object Views 518
Using Table Views 519
Creating and Modifying Tables 519
Creating a Table with the Table Design Wizard 519
Creating a Table Using Data Entry 520
Creating a Table in Design View 520
Changing Data Types 522
Using the Input Mask Wizard 522
Using the Format Property 524
Defining Relationships 524
Using the Relationships Window 525
Plug-In Summary 527
Making Business Decisions 527
>> PLUG-IN T7 ON CD
Problem Solving Using Access
Introduction to Queries
Creating Simple Queries
Reordering Columns in the Select Query Datasheet
Creating a Select Query in Design View
Adding Selection Criteria to a Select Query
Sorting Data in a Select Query
Advanced Queries
Using the Expression Builder
Using Aggregate Functions to Calculate Totals in Queries
Formatting Results Displayed in a Calculated Field
Creating and Running Queries to Modify Data
Plug-In Summary
Making Business Decisions
>> PLUG-IN T8 ON CD
Decision Making Using Access
Introduction
Forms
Creating a Form Using the Form Wizard
Creating and Saving AutoForms
Modifying the Properties of a Form
Modifying Specific Controls on a Form
Aligning Controls in a Form
Reports
Using the Report Wizard
Modifying the Report Design
Changing Margins and Page Orientation for Reports
Plug-In Summary
Making Business Decisions
>> PLUG-IN T9 ON CD
Designing Web Pages
Introduction
The World Wide Web
The Web Is Media Rich
The Web Is Interactive
Web Pages Can Be Designed
The Web Is Nonlinear
The Web Has No Control
Designing for the Unknown
The Process of Web Design
Analyze and Plan
Create and Organize Content
Develop the Look and Feel
Produce Graphics and HTML Documents
Creating a Working Prototype
Test, Test, Test
Upload to a Web Server and Test Again
Maintain
HTML Basics
Viewing the Source
HTML 101
Types of Tags
The Anatomy of a Tag
Basic Fonts
Web Graphics
Graphic Formats
Limited Color Palettes
Pixels, Not Inches
Tools of the Trade
Plug-In Summary
Making Business Decisions
>> PLUG-IN T10 ON CD
Basic Skills Using FrontPage
Introduction
Web Sites, Web Pages, and HTML
FrontPage Builds Web Sites Big and Small
Navigation in FrontPage
Understanding the Interface
FrontPage Views
Building a Web Site
Starting FrontPage
Creating a Web Site with Templates
Creating a Web Site with a Wizard
Creating an Empty Web Site
Saving a Web Site
Building a Web Page
Creating a Web Page from a Template
Creating a Blank Web Page
Entering Text on a Web Page
Formatting Text
Paragraphs
Working with Graphics
Using Ruled Lines
Putting Your Own Images on a Web Page
Including Hyperlinks
Creating a Hyperlink
Creating a Link to an E-Mail Address
Presenting Information in Lists and Tables
Working with Lists
Working with Tables
Working with Rows and Columns
Working with Cells
Formatting Pages
Setting Page Properties
Themes
Plug-In Summary
Making Business Decisions
Apply Your Knowledge Projects 530
Glossary 570
Notes 583
Illustration Credits 590
INDEX 592

There are no comments for this item.

to post a comment.