3 Copyright 6 Contents at a Glance 8 Contents 20 Acknowledgments 22 Introduction 26 Part I Get Started 28 Chapter 1 Getting Acquainted with Access 2002 29 Starting Access and Opening a Database 39 Open a Table 45 Get Help When You Need It 54 Get Help with What You恟e Doing 56 Chapter 2 Creating a Database 57 Design an Efficient Database 64 Create a Database with the Database Wizard 70 Run the New Application 73 Start with a Blank Database 76 Chapter 3 Creating and Modifying Tables 77 Create a Table with the Table Wizard 81 Create a Table from Scratch in Design View 98 Modify the Table Design 103 Ensure Data Validity 110 Copying an Existing Table Structure 112 Chapter 4 Relating Tables 113 Defining a Relationship 123 Viewing and Editing Relationships 125 Printing the Relationships 128 Chapter 5 Entering and Editing Data 129 Enter New Data 139 Customizing Data Entry 147 Changing the Datasheet Appearance 153 Changing Table Definition in Datasheet View 155 Editing Record Data 162 Part II Retrieve and Present Information 164 Chapter 6 Sorting, Filtering, and Printing Records 165 Sorting Records 166 Filtering Records 181 Preview and Print Sorted or Filtered Table Data 184 Chapter 7Extracting Information with Queries 186 Creating a Select Query 199 Adding Selection Criteria 204 Setting Query Properties 205 Modifying a Query 207 Performing Calculations in a Query 212 Creating Special Queries with the Query Wizard 220 Chapter 8 Creating Advanced Queries 221 Creating Special Purpose Queries 226 Designing Action Queries 233 Introducing Structured Query Language (SQL) 235 Creating SQL-Specific Queries 238 Creating a Subquery 242 Chapter 9 Understanding Form and Report Design Basics 243 Using AutoForm and AutoReport Features 244 Common Form and Report Design Elements 246 Working in the Design Window 256 Modifying Controls 267 Adding Other Objects and Special Effects 273 Modifying Form or Report Properties 278 Chapter 10 Creating Custom Forms and Subforms 279 Creating a New Form Design 283 Modifying the Form Design 299 Using the Form for Data Entry 302 Creating a Multiple-Page Form 306 Adding Special Controls 307 Creating a Hierarchical Form 314 Adding Custom User Guidance 315 Adding Data Validation 318 Chapter 11 Creating and Customizing Reports and Subreports 319 Starting a New Report 324 Preview and Print the Report 330 Modifying the Report Design 335 Saving the Report Design 336 Sorting and Grouping Records in a Report 348 Adding a Subreport 355 Designing a Multiple-Column Report 357 Printing Mailing Labels and Envelopes 362 Chapter 12 Creating Charts, PivotTables, and PivotCharts 363 Choosing a Chart Type 364 Creating a New Chart with the Chart Wizard 370 Creating a New Chart Without the Chart Wizard 373 Adding an Existing Chart to a Form or Report 374 Modifying the Chart 386 Creating a PivotTable or PivotChart 396 Part III Improve the Access 2002 Workplace 398 Chapter 13 Customizing the Workplace 399 Personalizing the Workplace 412 Creating Custom Groups 413 Changing the Way Access Starts 418 Modifying the Office Assistant 422 Chapter 14 Using Access to Improve Performance 423 Optimizing a Database 435 Backing Up and Restoring a Database 436 Compacting and Repairing a Database 442 Chapter 15 Automating with Macros 443 Creating a Simple Macro 447 Testing and Debugging a Macro 449 Assigning a Macro to an Event Property 451 Adding Conditions to a Macro 454 Creating Other Commonly Used Macros 460 Creating a Macro Group 466 Chapter 16 Customizing Menus and Toolbars 467 Using Access Command Bars 473 Customizing Command Bars 485 Modifying Command Bars 492 Chapter 17 Creating Custom Switchboards and Dialog Boxes 493 Creating Switchboards 505 Creating a Custom Dialog Box 513 Creating a Dialog Box for User Input 516 Part IV Exchange Data with Others 518 Chapter 18 Exchanging Database Objects and Text 519 Copying Objects Among Access Databases 521 Importing or Linking Access Data 527 Importing from or Linking to Other Databases 529 Working with Linked or Imported Tables 531 Importing and Linking Text Files 537 Exporting to an Existing Access Database 539 Exporting to Another Database Format 539 Exporting to Text Files 542 Chapter 19 Exchanging Data with Outside Sources 543 Copying or Moving Records 547 Saving Access Output as an External File 548 Working with Word 553 Working with Excel 562 Chapter 20 Creating Data Access Pages 563 Understanding Data Access Pages 563 Creating a Data Access Page 572 Modifying a Data Access Page 581 Organizing Data in a Data Access Page 586 Editing and Protecting Data in Data Access Pages 589 Customizing a Record Navigation Bar 590 Adding a Spreadsheet, Chart, PivotTable or PivotChart 598 Publishing and Printing Data Access Pages 600 Part V Application Development 602 Chapter 21 Sharing with Multiple Users 603 Replicating a Database 619 Modifying a Replica Set 622 Sharing a Database on a Network 625 Managing the Database in a Multiuser Environment 630 Chapter 22 Securing a Database 631 Securing a Database with a Password 633 Securing a Multiple-User Database 651 Other Security Measures 654 Appendix A Converting to Access 2002 655 Deciding on a Conversion Strategy 655 Converting a Database 661 Enabling a Database 661 Sharing a Database Across Several Access Versions 662 Converting from Access 2002 to Access 97 663 Converting From Access 2002 to Access 2000 664 Index
