Table of Contents Acknowledgments xxiii Using the Companion CD xxv Introduction xxvii Part I Understanding Microsoft Access 1 Chapter 1 Microsoft Access Is a Database and More 3 What Is a Database? 4 Relational Databases 4 Database Capabilities 6 Microsoft Access as an RDBMS 6 Data Definition and Storage 6 Data Manipulation 9 Data Control 12 Microsoft Access as Something More 13 Developing Application Logic 13 Deciding to Move to Database Software 15 Chapter 2 The Uses of Microsoft Access 19 In a Small Business 20 In Contract Work 22 As a Sales and Marketing Tool 23 In a Large Corporation 24 Workgroup Applications 27 Information Processing Systems 27 As a Personal RDBMS 28 Chapter 3 Touring Microsoft Access 31 Windows Features 31 The Architecture of Microsoft Access 34 Exploring the Entertainment Scheduling Database 37 Tables 40 Table Window in Design View 42 Table Window in Datasheet View 45 Queries 47 Query Window in Design View 49 Query Window in Datasheet View 50 Forms 51 Form Window in Design View 54 Form Window in Form View 56 Reports 57 Report Window in Design View 60 Report Window in Print Preview 62 Data Access Pages 63 Data Access Page Window in Design View 65 Data Access Page Window in Page View 68 Macros 69 Modules 72 Organizing Your Objects 74 Part II Building a Database 77 Chapter 4 Designing Your Database Application 79 Application Design Fundamentals 80 Step 1: Identifying Tasks 80 Step 2: Charting Task Flow 81 Step 3: Identifying Data Elements 81 Step 4: Organizing the Data 81 Step 5: Designing a Prototype and a User Interface 81 Step 6: Constructing the Application 82 Step 7: Testing, Reviewing, and Refining 82 An Application Design Strategy 83 Analyzing the Tasks 85 Data or Information? 86 Selecting the Data 87 Organizing Tasks 89 Data Analysis 90 Choosing the Database Subjects 90 Mapping Subjects to Your Database 92 Database Design Concepts 92 Waste Is the Problem 93 No

The complete reference made by Microsoft to help you be more productive with this bestselling relational database. This authoritative handbook has the answers you need for learning how to use Access 2000 for everything from personal desktop applications and workgroup systems to scalable back-end enterprise databases. Comprehensive Take advantage of enhanced integration with the Web for seamless data-sharing across platforms and user levels Publish live data to the Web with new data access pages Use the built-in programming language, Microsoft Visual Basic(r) for Applications, to automate tasks, customize menus and toolbars, connect applications to the Internet, and more Gain insight into using Microsoft Access 2000 as a component within Microsoft Office 2000 Easy Access to Information Chapters at a Glance for quick reference Master table of contents Extensive cross-referenced index Two-color interior for easier navigation Everything Is Clear Step-by-step instructions Hundreds of screen illustrations Real-world examples Tips and advice from the experts The CD contains all sample databases from the book, which you can study and reuse.