Table of Contents
Introduction 1
Book I: Getting Started with Access 2013 7
Chapter 1: Introducing Access 2013 9
Chapter 2: Getting Started, Getting Around 17
Chapter 3: Designing Your Database the Relational Way 37
Book II: Tables for Storing Your Data 65
Chapter 1: Creating and Modifying Tables 67
Chapter 2: Refi ning Your Table in Design View 105
Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet 121
Chapter 4: Importing and Exporting Data 137
Chapter 5: Avoiding “Garbage In, Garbage Out” 157
Chapter 6: Relating Your Tables and Protecting Your Data 175
Book III: Queries (Or Getting Information from Your Data) 187
Chapter 1: Creating Select Queries 189
Chapter 2: Letting Queries Do the Math 221
Chapter 3: Doing Neat Things with Action Queries and Query Wizards 255
Chapter 4: Viewing Your Data from All Angles Using Crosstabs 277
Book IV: Forms for Editing Data 287
Chapter 1: Designing Custom Forms (and Reports) 289
Chapter 2: Jazzing Up Your Forms (and Reports) 313
Chapter 3: Creating Smarter Forms 339
Chapter 4: Doing Calculations in Forms and Subforms (and Reports) 365
Book V: Reporting in Words and Pictures 385
Chapter 1: Creating and Spiffing Up Reports 387
Chapter 2: Printing Beautiful Reports 415
Chapter 3: Creating Charts and Graphs from Your Data 435
Book VI: Automation with Macros 457
Chapter 1: Making Macros Do the Work 459
Chapter 2: Making Macros Smarter 477
Book VII: Database Administration 497
Chapter 1: Database Housekeeping 499
Chapter 2: Sharing the Fun: Managing Multiuser Access 511
Chapter 3: Securing Your Data 523
Book VIII: Programming in VBA 535
Chapter 1: What the Heck Is VBA? 537
Chapter 2: Writing Code 557
Chapter 3: Writing Smarter Code 581
Chapter 4: Controlling Forms with VBA 605
Chapter 5: Using SQL and Recordsets 629
Chapter 6: Debugging Your Code 641
Book IX: Going Beyond Access 651
Chapter 1: Automation with Other Office Programs 653
Chapter 2: Using Access As a Front End to SQL Server 671
Chapter 3: Using Access with SharePoint 685
Appendix: Installing Microsoft Access 709
Index 717