Details

Introduction 1 <p><b>Part I: Getting Started with Access 2013 9</b></p> <p>Chapter 1: Access 2013 Basic Training 11</p> <p>Chapter 2: Navigating the Access Workspace 33</p> <p>Chapter 3: Database Basics 55</p> <p><b>Part II: Setting the Table 73</b></p> <p>Chapter 4: Table Tune Ups 75</p> <p>Chapter 5: Remodeling Your Data 91</p> <p>Chapter 6: Types, Masks, and Triggers 109</p> <p><b>Part III: Data Management Mania 131</b></p> <p>Chapter 7: A Form for All Reasons 133</p> <p>Chapter 8: Importing and Exporting Data 147</p> <p>Chapter 9: Automatic Data Editing 159</p> <p>Chapter 10: Access and the Web 171</p> <p><b>Part IV: Ask Your Data, and Ye Shall Receive Answers 193</b></p> <p>Chapter 11: Finding, Filtering, and Sorting Your Data — Fast 195</p> <p>Chapter 12: I Was Just Asking for Answers 211</p> <p>Chapter 13: I Want These AND Those OR Them 237</p> <p>Chapter 14: Number Crunching with the Total Row 245</p> <p>Chapter 15: Express Yourself with Formulas 257</p> <p>Chapter 16: Take Charge with Action Queries 271</p> <p><b>Part V: Simple and Snazzy Reporting 281</b></p> <p>Chapter 17: Fast and Furious Automatic Reporting 283</p> <p>Chapter 18: Professionally Designed Reports Made Easy 305</p> <p>Chapter 19: Headers and Footers and Groups, Oh My! 331</p> <p>Chapter 20: Magical Mass Mailings 353</p> <p><b>Part VI: More Power to You 361</b></p> <p>Chapter 21: Analyze This! 363</p> <p>Chapter 22: Steer Users in the Right Direction with Navigation Forms 375</p> <p><b>Part VII: The Part of Tens 383</b></p> <p>Chapter 23: Ten Common Problems 385</p> <p>Chapter 24: Ten Uncommon Tips 397</p> <p>Appendix: Getting Help 405</p> <p>Index 413</p>

<b>Laurie Ulrich Fuller</b> is a professional technology trainer and author. She has written books on Excel, Photoshop, and Dreamweaver. <p><b>Ken Cook</b> is a professional database developer and author who has written extensively on Access and Excel.</p>

<p>Learn to:</p> <ul> <li>Navigate the Access interface and understand database architecture</li> <li>Build tables to organize data and create forms for easy data entry</li> <li>Query your data and produce reports</li> <li>Build custom interfaces for all users</li> </ul> <p>Drowning in data? Manage it all and make it useful with the tools in Access 2013</p> <p>You need Access. You need it to organize your data, produce reports that make you look like a genius, create forms that enable your staff to enter and manage more data, and find the significant drop of data you're looking for in that huge pool of information. This book is the key that unlocks the Access magic — read on, and access the power!</p> <ul> <li>Essential Access — learn what Access can do, navigate the workspace and new features, and master the lingo</li> <li>Begin building — plan your database, decide how to structure it and what to store, explore templates, and build tables</li> <li>Share data — reduce data-entry errors by bringing content into your database from text files and Excel</li> <li>Web publishing — add hyperlinks to your database and publish data online</li> <li>Info, please — use the Find, Sort, and Filter commands to locate the information you need quickly</li> <li>Rave reports — create quick one-table or multi-table reports, and learn to spruce up the work with the Report Wizard</li> <li>Analyze this — explore Analyzer tools that help document your database and fine-tune its performance</li> </ul> <p>Open the book and find:</p> <ul> <li>Advice on building a new database</li> <li>The difference between flat-file and relational databases</li> <li>A review of new features</li> <li>Ways to repurpose reports and forms</li> <li>How Access works with the web</li> <li>Guidance on finding, filtering, and sorting data</li> <li>Directions for creating mass mailings from Access</li> <li>Ten tips for Access success</li> </ul>

US