InhaltsangabeIntroduction 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

Alison Barrows is the author or coauthor of several books about Access, Windows, and the Internet. Joseph Stockman is an 18-year software designer who has authored or coauthored five Access programming books. Allen Taylor is a 30-year veteran of the computer industry and the author of over 20 books.

Leseprobe