Alison Barrows has written books on Access, Windows, and the Internet, including Access For Dummies Quick Reference. Margaret Levine Young is coauthor of over two dozen books, including The Internet For Dummies.Joseph C. Stockman is an independent consultant, software designer, and author.

• Introduction 1Book I: Essential Concepts 7Chapter 1: Introducing Access 2010 9Chapter 2: Getting Started, Getting Around 17Chapter 3: Designing Your Database the Relational Way 37Book II: Tables for Storing Your Data 65Chapter 1: Creating and Modifying Tables 67Chapter 2: Refining Your Table in Design View 103Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet 121Chapter 4: Importing and Exporting Data 137Chapter 5: Avoiding “Garbage In, Garbage Out” 161Chapter 6: Relating Your Tables and Protecting Your Data 179Book III: Queries (or Getting Information from Your Data) 189Chapter 1: Creating Select Queries 191Chapter 2: Letting Queries Do the Math 223Chapter 3: Doing Neat Things with Action Queries and Query Wizards 257Chapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables 279Book IV: Forms for Editing Data 303Chapter 1: Designing and Using Forms (and Reports) 305Chapter 2: Jazzing Up Your Forms (and Reports) 329Chapter 3: Creating Smarter Forms 353Chapter 4: Doing Calculations in Forms and Subforms (and Reports) 377Book V: Reporting in Words and Pictures 397Chapter 1: Creating and Spiffing Up Reports 399Chapter 2: Printing Beautiful Reports 427Chapter 3: Creating Charts and Graphs from Your Data 445Book VI: Automation with Macros 471Chapter 1: Making Macros Do the Work 473Chapter 2: Making Macros Smarter 491Book VII: Database Administration 509Chapter 1: Database Housekeeping 511Chapter 2: Sharing the Fun: Managing Multiuser Access 521Chapter 3: Securing Your Access Database 535Book VIII: Programming in VBA 547Chapter 1: What the Heck Is VBA? 549Chapter 2: Writing Code 569Chapter 3: Writing Smarter Code 593Chapter 4: Controlling Forms with VBA 617Chapter 5: Using SQL and Recordsets 641Chapter 6: Debugging Your Code 653Book IX: Going Beyond Access 663Chapter 1: Automation with Other Office Programs 665Chapter 2: Using Access as a Front-End to SQL Server 681Chapter 3: Using Access with SharePoint 697Appendix: Installing Microsoft Access 719Index 725

Alison Barrows has written books on Access, Windows, and the Internet, including Access For Dummies Quick Reference. Margaret Levine Young is coauthor of over two dozen books, including The Internet For Dummies.Joseph C. Stockman is an independent consultant, software designer, and author.

• Introduction 1Book I: Essential Concepts 7Chapter 1: Introducing Access 2010 9Chapter 2: Getting Started, Getting Around 17Chapter 3: Designing Your Database the Relational Way 37Book II: Tables for Storing Your Data 65Chapter 1: Creating and Modifying Tables 67Chapter 2: Refining Your Table in Design View 103Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet 121Chapter 4: Importing and Exporting Data 137Chapter 5: Avoiding “Garbage In, Garbage Out” 161Chapter 6: Relating Your Tables and Protecting Your Data 179Book III: Queries (or Getting Information from Your Data) 189Chapter 1: Creating Select Queries 191Chapter 2: Letting Queries Do the Math 223Chapter 3: Doing Neat Things with Action Queries and Query Wizards 257Chapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables 279Book IV: Forms for Editing Data 303Chapter 1: Designing and Using Forms (and Reports) 305Chapter 2: Jazzing Up Your Forms (and Reports) 329Chapter 3: Creating Smarter Forms 353Chapter 4: Doing Calculations in Forms and Subforms (and Reports) 377Book V: Reporting in Words and Pictures 397Chapter 1: Creating and Spiffing Up Reports 399Chapter 2: Printing Beautiful Reports 427Chapter 3: Creating Charts and Graphs from Your Data 445Book VI: Automation with Macros 471Chapter 1: Making Macros Do the Work 473Chapter 2: Making Macros Smarter 491Book VII: Database Administration 509Chapter 1: Database Housekeeping 511Chapter 2: Sharing the Fun: Managing Multiuser Access 521Chapter 3: Securing Your Access Database 535Book VIII: Programming in VBA 547Chapter 1: What the Heck Is VBA? 549Chapter 2: Writing Code 569Chapter 3: Writing Smarter Code 593Chapter 4: Controlling Forms with VBA 617Chapter 5: Using SQL and Recordsets 641Chapter 6: Debugging Your Code 653Book IX: Going Beyond Access 663Chapter 1: Automation with Other Office Programs 665Chapter 2: Using Access as a Front-End to SQL Server 681Chapter 3: Using Access with SharePoint 697Appendix: Installing Microsoft Access 719Index 725

Alison Barrows has written books on Access, Windows, and the Internet, including Access For Dummies Quick Reference. Margaret Levine Young is coauthor of over two dozen books, including The Internet For Dummies.Joseph C. Stockman is an independent consultant, software designer, and author.

• Introduction 1Book I: Essential Concepts 7Chapter 1: Introducing Access 2010 9Chapter 2: Getting Started, Getting Around 17Chapter 3: Designing Your Database the Relational Way 37Book II: Tables for Storing Your Data 65Chapter 1: Creating and Modifying Tables 67Chapter 2: Refining Your Table in Design View 103Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet 121Chapter 4: Importing and Exporting Data 137Chapter 5: Avoiding “Garbage In, Garbage Out” 161Chapter 6: Relating Your Tables and Protecting Your Data 179Book III: Queries (or Getting Information from Your Data) 189Chapter 1: Creating Select Queries 191Chapter 2: Letting Queries Do the Math 223Chapter 3: Doing Neat Things with Action Queries and Query Wizards 257Chapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables 279Book IV: Forms for Editing Data 303Chapter 1: Designing and Using Forms (and Reports) 305Chapter 2: Jazzing Up Your Forms (and Reports) 329Chapter 3: Creating Smarter Forms 353Chapter 4: Doing Calculations in Forms and Subforms (and Reports) 377Book V: Reporting in Words and Pictures 397Chapter 1: Creating and Spiffing Up Reports 399Chapter 2: Printing Beautiful Reports 427Chapter 3: Creating Charts and Graphs from Your Data 445Book VI: Automation with Macros 471Chapter 1: Making Macros Do the Work 473Chapter 2: Making Macros Smarter 491Book VII: Database Administration 509Chapter 1: Database Housekeeping 511Chapter 2: Sharing the Fun: Managing Multiuser Access 521Chapter 3: Securing Your Access Database 535Book VIII: Programming in VBA 547Chapter 1: What the Heck Is VBA? 549Chapter 2: Writing Code 569Chapter 3: Writing Smarter Code 593Chapter 4: Controlling Forms with VBA 617Chapter 5: Using SQL and Recordsets 641Chapter 6: Debugging Your Code 653Book IX: Going Beyond Access 663Chapter 1: Automation with Other Office Programs 665Chapter 2: Using Access as a Front-End to SQL Server 681Chapter 3: Using Access with SharePoint 697Appendix: Installing Microsoft Access 719Index 725