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 descriptionItem type | Current location | Home library | Call number | Copy number | Status | Date due | Barcode | Item holds |
---|---|---|---|---|---|---|---|---|
BOOK | COLLEGE LIBRARY | COLLEGE LIBRARY SUBJECT REFERENCE | 658.4038 B218 2009 (Browse shelf) | c.1 | Available | CITU-CL-39762 | ||
BOOK | COLLEGE LIBRARY | COLLEGE LIBRARY SUBJECT REFERENCE | 658.4038 B218 2009 (Browse shelf) | c.2 | Available | CITU-CL-43088 |
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.