Get started with the new Access 2013 with this impressiveall-in-one reference!Microsoft Access allows you to store, organize, view, analyze,and share data; the new release enables you to build even morepowerful, custom database solutions that integrate with the web andenterprise data sources. This compilation of nine indispensibleminibooks is exactly what you need to get up to speed on the latestchanges to Access. This easy-to-understand resource provides bothnew and experienced Access users with invaluable advice forconnecting Access to SQL Server, manipulating data locally, gettingup to speed on the latest features of Access 2013, creating queriesand macros, and much more. From the basics to advanced functions,this book is what you need to make Access more accessible.* Shows you how to store, organize, view, analyze, and share datausing Access 2013* Includes nine minibooks that cover such topics as databasedesign, tables, queries, forms, reports, macros, databaseadministration, securing data, programming with Visual Basic forApplications (VBA), and using Access with the web* Helps you build database solutions that integrate with the weband other enterprise data solutions* Offers plenty of techniques, tips, and tricks to help you getthe most out of AccessThis all-in-one guide offers you access to all things Access2013!

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