Contents
APPENDICES
ONLINE APPENDICES: SEE PAGE 590 FOR INSTRUCTIONS
Appendix A: Getting Started with Microsoft Access 2010 A-1
Chapter Objectives A-3
What Is the Purpose of This Appendix? A-3
Why Should I Learn to Use Microsoft Access 2010? A-3
What Will This Appendix Teach Me? A-4
What Is a Table Key? A-5
What Are Relationships? A-5
Creating a Microsoft Access Database A-5
The Microsoft Office Fluent User Interface A-8
The Ribbon and Command Tabs A-8 • Contextual Command Tabs A-9 •
Modifying the Quick Access Toolbar A-9 • Database Objects and the Navigation
Pane A-9
Closing a Database and Exiting Microsoft Access A-10
Opening an Existing Microsoft Access Database A-11
Creating Microsoft Access Database Tables A-13
Inserting Data into Tables—The Datasheet View A-22
Modifying and Deleting Data in Tables in the Datasheet View A-25
Creating Relationships Between Tables A-26
Working with Microsoft Access Queries A-30
Microsoft Access Forms and Reports A-35
Closing a Database and Exiting Microsoft Access 2010 A-36
Key Terms A-37 • Review Questions A-38
Appendix B: Getting Started with Systems Analysis and Design B-1
Chapter Objectives B-3
What Is the Purpose of This Appendix? B-3
What Is Information? B-4
What Is an Information System? B-5
What Is a Competitive Strategy? B-5
How Does a Company Organize Itself Based on Its Competitive Strategy? B-5
What Is a Business Process? B-6
How Do Information Systems Support Business Processes? B-7
Do Information Systems Include Processes? B-7
Do We Have to Understand Business Processes in Order to Create Information Systems? B-8
What Is Systems Analysis and Design? B-8
What Are the Steps in the SDLC? B-9
The System Definition Step B-9 • The Requirements Analysis
Step B-10 • The Component Design Step B-11 • The Implementation
Step B-11 • The System Maintenance Step B-12
What SDLC Details Do We Need to Know? B-12
What Is Business Process Modeling Notation? B-13
What Is Project Scope? B-14
How Do I Gather Data and Information About System Requirements? B-14
How Do Use Cases Provide Data and Information About System Requirements? B-14
The Highline University Database B-15
The College Report B-17 • The Department Report B-19 • The
Department/Major Report B-21 • The Student Acceptance Letter B-22
What Are Business Rules? B-24
What Is a User Requirements Document (URD)? B-25
What Is a Statement of Work (SOW)? B-26
Key Terms B-27 • Review Questions B-28 • Project Questions B-29