Access 2016 For Dummies
Published on 13. October 2015
456 pages
978-1-119-08327-6 (ISBN)
Description
Access For Dummies is the book for people who don't know a relational database from an isolationist table, but still need to figure out how to organize and analyze their data. The book assumes no prior Access or database-building knowledge as it walks you through the basics of creating tables to store your data, building forms that ease data entry, writing queries that pull real information from your data, and creating reports that back up your analysis. Add in a For Dummies touch of fun and humor, and Access For Dummies becomes the book you need to go from data prude to data pro! The book covers:
- Learning database basics: a crash course on how databases work and how to build one from the ground up
- Setting the table: insight into how to structure data to make it useful
- Data management: steps on how to manipulate, edit, add, and import data into your database
- Getting some answers: expert advice on how to write and execute queries to gain insight from your data
- Building reports: sharing both quick and dirty as well as elegant ways to report data
- The Part of Tens: the traditional For Dummies closer shares info on troubleshooting a troublesome database along with expert tips to impress data pros
More details
Other editions
Additional editions
Laurie Ulrich Fuller | Ken Cook
Access 2016 For Dummies
Book
11/2015
Wiley
€28.50
Shipment within 15-20 days
Persons
Laurie Ulrich Fuller is a professional technology author and trainer. She's created training materials that cover Microsoft Office and Adobe Creative Suite. Ken Cook is a professional database developer, instructor, and author. The two experts have teamed to write the previous three editions of Access For Dummies.
Content
Introduction 1
Part I: Getting Started with Access 2016 5
Chapter 1: Access 2016 Basic Training 7
Chapter 2: Navigating the Access Workspace 27
Chapter 3: Database Basics 49
Chapter 4: Sounds Like a Plan 67
Part II: Getting It All on the Table 77
Chapter 5: Table Tune Ups 79
Chapter 6: Remodeling Your Data 97
Chapter 7: Types, Masks, and Triggers 113
Part III: Data Management Mania 137
Chapter 8: A Form for All Reasons 139
Chapter 9: Importing and Exporting Data 157
Chapter 10: Automatic Data Editing 171
Chapter 11: Access and the Web 183
Part IV: The Power of Questions 203
Chapter 12: Finding, Filtering, and Sorting Your Data -- Fast 205
Chapter 13: I Was Just Asking . for Answers 221
Chapter 14: I Want These AND Those OR Them 247
Chapter 15: Number Crunching with the Total Row 255
Chapter 16: Express Yourself with Formulas 267
Chapter 17: Take Charge with Action Queries 281
Part V: Simple and Snazzy Reporting 291
Chapter 18: Fast and Furious Automatic Reporting 293
Chapter 19: Professionally Designed Reports Made Easy 315
Chapter 20: Headers and Footers and Groups, Oh My! 341
Chapter 21: Magical Mass Mailings 361
Part VI: More Power to You 369
Chapter 22: Analyze This! 371
Chapter 23: Steer Users in the Right Direction with Navigation Forms 381
Part VII: The Part of Tens 391
Chapter 24: Ten Common Problems 393
Chapter 25: Ten Uncommon Tips 403
Appendix A: Getting Help 409
Index 417
